excel中列名"N.W",读取到.net中变成"N#W"的情况???
开发环境:vs.net 2008(C#)+Office2013
测试代码如下:
DataSet result = new DataSet();
//数据库连接
string fileName = @"f:\Size_Import.xlsx";
string my_StrConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + fileName + ";" + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\"";
using (System.Data.OleDb.OleDbConnection my_conn = new System.Data.OleDb.OleDbConnection(my_StrConnection))
{
my_conn.Open();
DataTable schemaTable = my_conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
string workAreaName = schemaTable.Rows[0][2].ToString().Trim();
string my_StrSelect = "SELECT * FROM [" + workAreaName + "]";
using (System.Data.OleDb.OleDbDataAdapter my_Adapter = new System.Data.OleDb.OleDbDataAdapter(my_StrSelect, my_conn))
{
//填充数据集
my_Adapter.Fill(result, "check");
}
}
excel中数据如下:
.net中读取excel数据后的结果如下: