日期:2014-05-17  浏览次数:20785 次

c#打开excel出现的问题,哪位大侠帮解决下?(下面是代码)
OpenFileDialog dlg = new OpenFileDialog();
  dlg.Filter = "Shape地图文件(*.xlsx)|*.xlsx|全部文件(*.*)|*.*";
  dlg.Title = "打开Shape地图文件";
  dlg.Multiselect = true;
  dlg.ShowDialog();
  string[] files = dlg.FileNames;
  foreach (string file in files)
  {
  int index1 = file.LastIndexOf("\\");
  //string filepath = file.Substring(0, index1);
  string filename = file.Substring(index1 + 1);
   
  Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();
  listBox1.Items.Add(filepath);
  listBox1.Items.Add(filename);

  object missing= System.Reflection.Missing.Value;



  Microsoft.Office.Interop.Excel.Workbook book1 = excel1.Application.Workbooks.Open(filename, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);(这条语句报的错)


  book1.SaveAs("D:\\text.xlsx", Microsoft.Office.Interop.Excel.XlFileFormat.xlOpenXMLWorkbook, Type.Missing, Type.Missing, false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Microsoft.Office.Interop.Excel.XlSaveConflictResolution.xlLocalSessionChanges, Type.Missing, Type.Missing, Type.Missing, Type.Missing);


  excel1.Quit();
  }


错误信息:

------解决方案--------------------
excel1.Application.Workbooks.Open(filename)试试看。我记得后面参数不写也行。
------解决方案--------------------
missing默认个数查下!
------解决方案--------------------
string filename = file.Substring(index1 + 1);
Microsoft.Office.Interop.Excel.Workbook book1 = excel1.Application.Workbooks.Open(filename............
这个filename是不是没有路径只有文件名?参数换成file看看。