C#导数据到excel的问题

[木子十甫寸]

code如下，生成xlsx文件一切正常，但是xls会出现“您尝试打开的**.xls的格式与文件扩展名指定的格式不一致”。
请问这是为什么了？

private void ExtractResult_Click(object sender, EventArgs e)
{
//由于使用的是COM库，因此有许多变量需要用Nothing 代替
Object Nothing = Missing.Value;
//WdSaveFormat 为Excel文档的保存格式
object format = Excel.XlFileFormat.xlOpenXMLWorkbook;
Excel.XlFileFormat version = Excel.XlFileFormat.xlExcel8;
SaveFileDialog saveexcel = new SaveFileDialog();
saveexcel.Filter = "文件类型(*.xlsx)|*.xlsx|文件类型(*.xls)|*.xls";
if (saveexcel.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string path = saveexcel.FileName;//文件路径变量
if (System.IO.Path.GetExtension(saveexcel.FileName).ToLower() == ".xlsx")
{
version = Excel.XlFileFormat.xlOpenXMLWorkbook;
}
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
try
{
Excel.Application excelApp = new Excel.Application(); //Excel应用程序变量
Excel.Workbook excelDoc = excelApp.Workbooks.Add(Nothing); //Excel文档变量
Excel.Worksheet sheet = (Excel.Worksheet)excelDoc.Sheets[1];
sheet.Cells[1, 1] = "123";
//将 excelDoc文档对象的内容保存为XLSX文档
excelDoc.SaveAs(path, Nothing, Nothing, Nothing, Nothing, Nothing, Excel.XlSaveAsAccessMode.xlExclusive, Nothing, Nothing, Nothing, Nothing, Nothing);
//关闭excelDoc文档对象
excelDoc.Close(Nothing, Nothing, Nothing);
//关闭excelApp组件对象
excelApp.Quit();
MessageBox.Show(path.ToString() + " 导出成功");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}

[木子十甫寸]

private void ExtractResult_Click(object sender, EventArgs e)
  {
  //由于使用的是COM库，因此有许多变量需要用Nothing 代替  
  Object Nothing = Missing.Value;
  //WdSaveFormat 为Excel文档的保存格式  
  object format = Excel.XlFileFormat.xlOpenXMLWorkbook;
  Excel.XlFileFormat version = Excel.XlFileFormat.xlExcel8;
  SaveFileDialog saveexcel = new SaveFileDialog();
  saveexcel.Filter = "文件类型(*.xlsx)|*.xlsx|文件类型(*.xls)|*.xls";
  if (saveexcel.ShowDialog() == System.Windows.Forms.DialogResult.OK)
  {
  string path = saveexcel.FileName;//文件路径变量  
  if (System.IO.Path.GetExtension(saveexcel.FileName).ToLower() == ".xlsx")
  {
  version = Excel.XlFileFormat.xlOpenXMLWorkbook;
  }
  if (System.IO.File.Exists(path))
  {
  System.IO.File.Delete(path);
  }
  try
  {
  Excel.Application excelApp = new Excel.Application(); //Excel应用程序变量  
  Excel.Workbook excelDoc = excelApp.Workbooks.Add(Nothing); //Excel文档变量
  Excel.Worksheet sheet = (Excel.Worksheet)excelDoc.Sheets[1];
  sheet.Cells[1, 1] = "123";
  //将 excelDoc文档对象的内容保存为XLSX文档   
  excelDoc.SaveAs(path, Nothing, Nothing, Nothing, Nothing, Nothing, Excel.XlSaveAsAccessMode.xlExclusive, Nothing, Nothing, Nothing, Nothing, Nothing);
  //关闭excelDoc文档对象  
  excelDoc.Close(Nothing, Nothing, Nothing);
  //关闭excelApp组件对象   
  excelApp.Quit();
  MessageBox.Show(path.ToString() + " 导出成功");
  }
  catch (Exception ex)
  {
  MessageBox.Show(ex.Message);
  }
  }
  }

[木子十甫寸]

代码重发了一下

[木子十甫寸]

周末没人上网么

[orochiheart]

if (System.IO.Path.GetExtension(saveexcel.FileName).ToLower() == ".xlsx" || System.IO.Path.GetExtension(saveexcel.FileName).ToLower() == ".xls" )
{
version = Excel.XlFileFormat.xlOpenXMLWorkbook;
}

没细看，，先试试

[XUKEKE2600]

文件格式设置的地方不对，上网查一下。

[木子十甫寸]

还是不行

[Quote=引用 4 楼 的回复:]

if (System.IO.Path.GetExtension(saveexcel.FileName).ToLower() == ".xlsx" || System.IO.Path.GetExtension(saveexcel.FileName).ToLower() == ".xls" )
{
version = Excel.XlFileFormat.xlOpenXMLWorkboo……
[/Quote]

[木子十甫寸]

额，我也知道是格式不对.....

[Quote=引用 5 楼 的回复:]

文件格式设置的地方不对，上网查一下。
[/Quote]

[orochiheart]

查扩展名是否是XLS

[木子十甫寸]

搞定了，把saveas的第二个参数传version就好了

[orochiheart]

恭喜 学习！

[ditto0723]

excelDoc.SaveAs(path, Nothing, Nothing, Nothing, Nothing, Nothing, Excel.XlSaveAsAccessMode.xlExclusive, Nothing, Nothing, Nothing, Nothing, Nothing);
改成
excelDoc.SaveAs(path, version , Nothing, Nothing, Nothing, Nothing, Excel.XlSaveAsAccessMode.xlExclusive, Nothing, Nothing, Nothing, Nothing, Nothing);

[ditto0723]

晚了？