从DataGrid中导出的数据保存在Excel中,这样生成Excel实际上是Html的,如果我要更新后再次导入的话就无法用System.Data.OleDb.OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;"+ "Data Source=" + filePath + ";" + "Extended Properties=\"Excel 8.0;\"");这样的对象访问了,有没有什么办法能将这样的excel文件也导进去??
private void ToExcel(System.Web.UI.Control ctl)
{
Response.Charset="GB2312";
Response.AppendHeader("Content-Disposition","attachment;filename=Excel.xls");
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.ContentType = "application/ms-excel"; ctl.Page.EnableViewState = false;
System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new HtmlTextWriter(tw); ctl.RenderControl(hw); Response.Write(tw.ToString());
Response.End();
}