conn.Close();
datagrid1.DataMember =
"[Sheet1$]"
;
datagrid1.DataSource = ds;
datagrid1.DataBind();
//Excel.Application excel = new Excel.Application();
//excel.Application.Workbooks.Add(true);
//excel.Visible = true;
}
2.一个一个单元格的进行插入
§§代码
1
string
str =
@"Data Source=IT-
428E4EA4B0C7\SQLEXPRESS;Initial Catalog=TestBase;Integrated
Security=True"
;
2
SqlConnection conn =
new
SqlConnection(str);
3
conn.Open();
4
int
n =
0
;
5
for
(
int
i =
1
; i <
20
; i++)
6
{
7
if
(n >
3
)
8
break
;
9
else
10
if
(msheet.Cells.get_Range(
"A"
+ i,
Type.Missing).Text.ToString() ==
""
&& n <=
3
)
11
{ n++; }
12
else
13
{
14
//循环获取 excel 单元格的值一次一次的插入,excuteSql 为执行的存储
过程
15
excuteSql(msheet.Cells.get_Range(
"B"
+ i,
Type.Missing).Text.ToString(),
16
msheet.Cells.get_Range(
"B"
+ (i +
1
),
Type.Missing).Text.ToString(),
17
msheet.Cells.get_Range(
"B"
+ (i +
2
),
Type.Missing).Text.ToString(),