在ExcelFile中获取数据 [英] Get Data in ExcelFile

问题描述

我想读取Exel文件，我做了:

I want read file Exel file, I done:

static DataTable GetSheetData(string excelFile, int sheetindex){  
string sheetname = GetExcelSheetNames(excelFile)[sheetindex];  
string srcConnString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + excelFile + @";Extended Properties=""Excel 8.0;HDR=YES;""";  
string srcQuery = "Select * from [" + sheetname + "]";  
OleDbConnection srcConn = new OleDbConnection(srcConnString);  
srcConn.Open();  
OleDbCommand objCmdSelect = new OleDbCommand(srcQuery, srcConn);  
DataSet ds = new DataSet();  
OleDbDataAdapter da = new OleDbDataAdapter(objCmdSelect);  
da.Fill(ds, sheetname);  
srcConn.Close();  
return ds.Tables[0];  
}  

如果工作表名称包含空白字符字符，则无法读取文件. sheetname空白字符时如何读取文件?谢谢

If sheetname have blank charaters blanks, I can''t read file. How can read the file when sheetname blank characters? Thanks

推荐答案

尝试:
字符串srcQuery =从*"中选择* *"

try:
string srcQuery = "Select * from [" + sheetname + "

";

这篇关于在ExcelFile中获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！