将EXCEL数据读出,该功能的实现代码网络上已重复出现多次,我贴出此段代码是因为遇到一个问题:
导出Excel 数据
privateArrayList GetXlsSheetNames(stringfilePath)
{
ArrayList list=newArrayList();stringconnectString="Provider=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="+filePath+"; Extended properties=Excel 8.0;";
OleDbConnection con=newOleDbConnection(connectString);
con.Open();
DataTable sheetNames=con.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables,newobject[] {null,null,null,"TABLE"});
con.Close();foreach(DataRow drinsheetNames.Rows )