c#读取excel内容内容示例分享
发布时间:2020-12-15 05:55:53 所属栏目:百科 来源:网络整理
导读:1、Excel 需是.xls 格式 2、添加引用Microsoft.Office.Interop.Excel.dll 复制代码 代码如下: using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Data.OleDb; using Excel = Microso
1、Excel 需是.xls 格式 复制代码 代码如下: using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Data.OleDb; using Excel = Microsoft.Office.Interop.Excel; using System.Diagnostics; namespace ReadExcel { class Program { static void Main(string[] args) { string fileName = @"D:TransferPlant111.xls"; DataTable dt = ExcelToDataSet(fileName); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { Console.WriteLine(dt.Rows[i][0].ToString()); } } } static public DataTable ExcelToDataSet(string filename) { string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = "+filename+";Extended Properties=Excel 8.0"; OleDbConnection conn = new OleDbConnection(strCon); conn.Open(); //返回Excel的架构,包括各个sheet表的名称,类型,创建时间和修改时间等 DataTable dtSheetName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,new object[] { null,null,"Table" }); //包含excel中表名的字符串数组 string[] strTableNames = new string[dtSheetName.Rows.Count]; for (int k = 0; k < dtSheetName.Rows.Count; k++) { strTableNames[k] = dtSheetName.Rows[k]["TABLE_NAME"].ToString(); } OleDbDataAdapter myCommand = null; DataTable dt = new DataTable(); //从指定的表明查询数据,可先把所有表明列出来供用户选择 string strExcel = "select * from [" + strTableNames[0] + "]"; myCommand = new OleDbDataAdapter(strExcel,strCon); myCommand.Fill(dt); return dt; } } } (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |