sakeryu 你好,
1.使用 Spread 打开 “zjk000303 - 副本.xls”,读取利润表中的 D7 和 F7 单元格,可以正常读取并且存储,需要注意的是利润表表单的索引为 1,下面是我的代码。
- private void button1_Click(object sender, EventArgs e)
- {
- this.fpSpread1.OpenExcel(@"E:\zjk000303 - 副本.xls");
- }
- private void button2_Click(object sender, EventArgs e)
- {
- SqlCommand dbComm = new SqlCommand();
- string sqlCommand = string.Format("insert into table1 (col1,col2,col3) values({0},{1},'{2}')", this.fpSpread1.Sheets[1].Cells[6, 3].Value, 1, this.fpSpread1.Sheets[1].Cells[6, 5].Value);
- dbComm.CommandText = sqlCommand;
- dbComm.Connection = dbCon;
- try
- {
- dbCon.Open();
- dbComm.ExecuteNonQuery();
- dbCon.Close();
- }
- catch (Exception)
- {
- throw;
- }
- finally
- {
- dbCon.Close();
- }
- }
复制代码 |