.NET 导入Excel表提示“外部表不是预期的格式”，然而如果新建一个Excel文件导入则不会报错

[magicwang188]

以下代码是我的导出excel代码
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
string strFileName = "Total";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + strFileName + ".xls");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.ContentType = "application/ms-excel";
StringWriter oStringWriter = new StringWriter();
HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);
this.GridView1.RenderControl(oHtmlTextWriter);
Response.Output.Write(oStringWriter.ToString());
Response.Flush();
Response.End();
然后我再次将导出的excel文件导入时，提示“外部表不是预期的格式”
以下是我导入excel的部分代码
fpath = Server.MapPath("file\\") + "PUD" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";//确定文件名
fpath1 = "PUD" + DateTime.Now.ToString("yyyyMMddHHmmss");
FileUpload1.SaveAs(fpath);
selstr = "select * from [Sheet1$]";
constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + fpath + "';Extended Properties='Excel 8.0;HDR=False;IMEX=1;'";
xlsTb = GetOleTbXls(selstr, constr);
然而如果新建一个Excel文件导入则不会报错，研究了好久，求解！！！

[dickwxyz]

你原来的excel文件是通过什么方法保存的？如果是网上找的datagridview保存成的excel文件的三种方法之一，那实际上是txt文件。所以再另存一个真正的excel文件，才能用上面的方法导入。看我的帖子吧。 http://bbs.csdn.net/topics/390749439?page=1#post-397234418