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();
}
错误信息:
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();
}
错误信息:
解决方案 »
- 奇怪的问题:获取硬盘ID,GetInstances()报错
- 关于c#属性和集合的不解,拜求高手解答!求详解!
- 请教C#实现类似动画效果的问题
- asp.net如何实现根据各省份的二级域名(同一站)
- 请问下:使用ProcessStartInfo启动安装程序,如何在安装结束获取安装程序的安装路径
- 50分 解决C#截取字符串 问题 在线等~~ 可以解决 立即结帐
- 请问高手:如何在一个DataGrid中同时显示2张表的内容(附例子,请教解决方案)?
- 我做了线程 循环添加数据 怎么跑了 30 几好就不跑了啊
- C# 获取文件夹中 文件名类似的文件数量
- .Net Socket组件含原码,列子!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- 端口映射的vs无法调试么?
- Socket通信死循环问题~大家帮忙分析~有源码
Microsoft.Office.Interop.Excel.Workbook book1 = excel1.Application.Workbooks.Open(filename............
这个filename是不是没有路径只有文件名?参数换成file看看。
app.Visible = true;
Microsoft.Office.Interop.Excel.Workbook book1 = app.Workbooks.Open("e:\\oldpc\\Book1.xlsx");
楼上正解,filename是excel文件的路径。