从Excel读数据,怎么才能读出Sheet1/Sheet2工作簿的名字? 一般的用 select * from [sheet1$] 的语句来读取数据,但是,Sheet1的名字有时后被改掉了,比如改成"固定资产"的名字,那语句是不是就应当为 select * from [固定资产$] 的形式?问题是,我怎么知道Sheet1是什么名字? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 http://community.csdn.net/Expert/topic/3481/3481988.xml?temp=.7964289 OleDbConnection ExcelConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+pathName+@"\"+fileName+";Extended Properties=Excel 8.0;"); OleDbCommand ExcelCommand = new OleDbCommand(); ExcelCommand.Connection = ExcelConnection; OleDbDataAdapter ExcelAdapter = new OleDbDataAdapter(ExcelCommand); ExcelConnection.Open(); DataTable ExcelSheets = ExcelConnection.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables,new object[] {null, null, null, "TABLE"}); string SpreadSheetName = "["+ExcelSheets.Rows[workSheetNumber]["TABLE_NAME"].ToString()+"]"; DataSet ExcelDataSet = new DataSet(); ExcelCommand.CommandText = @"SELECT * FROM "+SpreadSheetName; ExcelAdapter.Fill(ExcelDataSet); ExcelConnection.Close(); return ExcelDataSet; Oracle数据库问题 如何处理登陆验证的问题 请问如何控制上传文件的大小? 用户控件A与B在同一个页面,用户控件A有GridView1,用户控件B想访问GridView1,代码如何写?? 高手求助!!!!! 关于用Enterprise Template Projects做项目的疑问(谁会改vbdataaccess\scripts\1033\default.js) 关于拼音码的问题 怪问题啦,我的系统被我弄得断点都设置无效了,我怎么把它设回来啊? datagrid的问题 为什么访问数据库背拒绝 为了表达清晰,说得比较细,其实逻辑简单。大傢幫忙看看,非常着急 简单的listbox初始化问题
OleDbCommand ExcelCommand = new OleDbCommand();
ExcelCommand.Connection = ExcelConnection;
OleDbDataAdapter ExcelAdapter = new OleDbDataAdapter(ExcelCommand); ExcelConnection.Open();
DataTable ExcelSheets = ExcelConnection.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables,new object[] {null, null, null, "TABLE"});
string SpreadSheetName = "["+ExcelSheets.Rows[workSheetNumber]["TABLE_NAME"].ToString()+"]"; DataSet ExcelDataSet = new DataSet();
ExcelCommand.CommandText = @"SELECT * FROM "+SpreadSheetName;
ExcelAdapter.Fill(ExcelDataSet);
ExcelConnection.Close();
return ExcelDataSet;