C#对EXCEL的操作,首先打开一个EXCEL文件,操作后保存,文件保存的默认路径竟然不是打开的文件路径?
(注:有些机器保存的路径是打开的文件的路径)
请问这是为什么?部分代码如下: Excel.Application xlsApp = new Excel.Application();
Excel.Workbook xlsBook = xlsApp.Workbooks.Open(strFile, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing);
string fileName1 = xlsBook.FullName;
xlsBook.Save();
string fileName2 = xlsBook.FullName;
xlsBook.Close(false, System.Type.Missing, System.Type.Missing); 现在问题是fileName1 != fileName2;
但有些电脑上确相等,请问为什么?怎样解决?
(注:有些机器保存的路径是打开的文件的路径)
请问这是为什么?部分代码如下: Excel.Application xlsApp = new Excel.Application();
Excel.Workbook xlsBook = xlsApp.Workbooks.Open(strFile, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing);
string fileName1 = xlsBook.FullName;
xlsBook.Save();
string fileName2 = xlsBook.FullName;
xlsBook.Close(false, System.Type.Missing, System.Type.Missing); 现在问题是fileName1 != fileName2;
但有些电脑上确相等,请问为什么?怎样解决?
book=(Excel._Workbook)app.Workbooks.Open(strPath,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,
Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value);
sheet=(Excel._Worksheet)book.Sheets[1];book.Save();
book.Close(null,null,null);
app.Workbooks.Close();