/// <summary>
/// 点击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
#region
//OleDbConnection objConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Information.xls;" + "Extended Properties=Excel 8.0;");
//objConn.Open();
//DataTable schemaTable = objConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
//string tableName = schemaTable.Rows[0][2].ToString().Trim();//获取 Excel 的表名,默认值是sheet1
//string strSql = "select * from [" + tableName + "]";
//OleDbCommand objCmd = new OleDbCommand(strSql, objConn);
//OleDbDataAdapter myData = new OleDbDataAdapter(strSql, objConn);
//myData.Fill(ds, tableName);//填充数据
//dgBom.DataSource = ds;
//dgBom.DataBind();
//objConn.Close();
// ExcelTable = ds.Tables[tableName];
//int iColums = ExcelTable.Columns.Count;//列数
///int iRows = ExcelTable.Rows.Count;//行数
// MessageBox.Show(iRows.ToString());
string SheetName = "Sheet1";
string savePath = "D:\\";
string filename = "Information";
DataSet ds = ExecleDs(SheetName, savePath, filename); //调用自定义方法
DataRow[] dr = ds.Tables[0].Select(); //定义一个DataRow数组
int rowsnum = ds.Tables[0].Rows.Count;
//判断是否有数据
if (rowsnum == 0 )
{
return;<
C# 窗体 将EXCEL文件存入datatable内,通过读取文本框数据存入数据表,然后再存入EXCEL内
最新推荐文章于 2022-03-14 17:18:56 发布