如何将Excel文件数据转换为DataTable [英] How to convert excel file data into DataTable

问题描述

大家好，

i希望将excel文件数据转换为数据表

我有一个像9 ******的数据是excel表中的手机号码



我尝试使用以下代码但不起作用

hi everyone,
i want to convert a excel file data into datatable
I have a data like 9****** is mobile number in excel sheet

I tried following code but it does not work

System.Data.DataTable dtExcel = new System.Data.DataTable();
   dtExcel.TableName = "MyExcelData";
   string SourceConstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" +filename+";      Extended Properties= 'Excel 8.0;HDR=Yes;IMEX=1'";
   OleDbConnection con = new OleDbConnection(SourceConstr);
   con.Open();
   string query = "Select * from [Sheet1$]";
   OleDbDataAdapter data = new OleDbDataAdapter(query, con);
   data.Fill(dtExcel);
   return dtExcel;

请帮帮我....



在此先感谢...

please help me....

Thanks in advance...

推荐答案

;
OleDbDataAdapter data = new OleDbDataAdapter（query，con）;
data.Fill（dtExcel）;
return dtExcel;

"; OleDbDataAdapter data = new OleDbDataAdapter(query, con); data.Fill(dtExcel); return dtExcel;

请帮帮我....



提前致谢...

please help me....

Thanks in advance...

System.Data.DataTable dtExcel = new System.Data.DataTable();
dtExcel.TableName = "MyExcelData";
string SourceConstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" +filename+";      Extended Properties= 'Excel 8.0;HDR=Yes;IMEX=1'";
OleDbConnection con = new OleDbConnection(SourceConstr);
con.Open();
string query = "Select * from [Sheet1

;
OleDbDataAdapter data = new OleDbDataAdapter（查询，con）;
data.Fill（dtExcel）;
返回 dtExcel;

"; OleDbDataAdapter data = new OleDbDataAdapter(query, con); data.Fill(dtExcel); return dtExcel;

获取文件的完整路径

Take a full path of the file

这篇关于如何将Excel文件数据转换为DataTable的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！