请教:Excel导入到GridView1字符显示的问题
gdlpc 2009-10-08 11:16:49 我用以下代码进行Excel导入到GridView1
string path=Server.MapPath(@"~\xls\test.xls");//指定路径
//string path = this.File1.Value;//获取选择的路径
String strConnectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=\"Excel 8.0\"", path);
OleDbConnection oleDbConnection = new OleDbConnection(strConnectionString);
oleDbConnection.Open();
DataSet ds = new DataSet();
OleDbDataAdapter oleDbDataAdapter = new OleDbDataAdapter("Select * from [Sheet1$]", oleDbConnection);
oleDbDataAdapter.Fill(ds, "excel_data");
oleDbConnection.Close();
this.GridView1.DataSource = ds.Tables["excel_data"];
this.GridView1.DataBind();
可以导入,但有如下问题不会解决:
如果Excel单元格内容是:123456,不论是文本或数字类型导入到GridView1的单元格无内容,是空白的,
而Excel单元格内容改为:a123456,即可以在GridView1中显示:a123456,
不知是什么原因?
请各位帮忙解决,十分感谢!