Excel里有一列叫"No."，读取之后变成了No#，求大神
DataTable dt = new DataTable();
string connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 8.0;HDR=YES;IMEX=1;'", fileName);
OleDbConnection conn = new OleDbConnection(connectionString);
try
{
conn.Open();//打开数据库
string sql = @"[" + sheetName + "$] where 1=1";
OleDbCommand cmd = new OleDbCommand(sql, conn);
OleDbDataAdapter apt = new OleDbDataAdapter(cmd);
apt.Fill(dt);
dt.TableName = "Report";
}
catch (Exception ex)
{
dt = new DataTable();
}
finally
{
conn.Close();
}
return dt;
}
微信扫一扫