我想通过c#修改excel,然后保存退出,注意是保存,不是另存为,但是我workbook.saveas时,提示说不能操作只读文件,要怎么保存退出啊?我的代码如下所示
Excel.ApplicationClass myExcel = new Excel.ApplicationClass();
Excel.Application App = new Excel.Application();
object missing = Missing.Value;
Excel.Workbooks workBooks = myExcel.Workbooks;
Excel.Workbook myExcelbook = workBooks.Open(parth, missing, false, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
Excel.Sheets sheet = myExcelbook.Worksheets;
Excel.Worksheet workSheet = (Excel.Worksheet)sheet.get_Item("Demand");
for (int i = 1; i <= col; i++)
{
workSheet.Cells[1,i] = headddd[i-1];
} myExcelbook.SaveAs(parth, missing, missing, missing, false, missing, Excel.XlSaveAsAccessMode.xlExclusive, missing, missing, missing, missing, missing);//在这里出错,提示不能操作只读文件
workSheet.SaveAs(parth,missing,missing,missing,missing,missing,missing,missing,missing,missing);
myExcelbook.Save();
myExcelbook.Saved = true;
myExcelbook.Close(missing, parth, true); //确保Excel进程关闭
//workSheet = null;
myExcelbook = null;
//myExcel = null;
App.Quit();
App = null;
GC.Collect();
哪位大虾能帮忙解决下啊,谢谢。
Excel.ApplicationClass myExcel = new Excel.ApplicationClass();
Excel.Application App = new Excel.Application();
object missing = Missing.Value;
Excel.Workbooks workBooks = myExcel.Workbooks;
Excel.Workbook myExcelbook = workBooks.Open(parth, missing, false, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
Excel.Sheets sheet = myExcelbook.Worksheets;
Excel.Worksheet workSheet = (Excel.Worksheet)sheet.get_Item("Demand");
for (int i = 1; i <= col; i++)
{
workSheet.Cells[1,i] = headddd[i-1];
} myExcelbook.SaveAs(parth, missing, missing, missing, false, missing, Excel.XlSaveAsAccessMode.xlExclusive, missing, missing, missing, missing, missing);//在这里出错,提示不能操作只读文件
workSheet.SaveAs(parth,missing,missing,missing,missing,missing,missing,missing,missing,missing);
myExcelbook.Save();
myExcelbook.Saved = true;
myExcelbook.Close(missing, parth, true); //确保Excel进程关闭
//workSheet = null;
myExcelbook = null;
//myExcel = null;
App.Quit();
App = null;
GC.Collect();
哪位大虾能帮忙解决下啊,谢谢。
解决方案 »
- access表中有一列为时间型的,这个和C#中的datetime类型怎么互相转换存储?
- 请教关于更新数据库的问题
- 简单为题考验算法
- 在C#中如何双击图片调用ACDsee来看这个图片
- 初级问题-如何禁止别人调用我的dll
- 请问一下为什么表格的图片拉伸之后,button和textbox控件都不能用鼠标点,只能按住键盘的TAB来控制这2个控件.?求解决方法
- 神啊!!!救救我吧!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- 各位大侠,请教DataGridTableStyle的一个问题
- 100分求解:8bit编码的邮件如何解码?各位大大请帮忙
- c#通过INTERNET远程访问数据库都有什么办法?(请高手指点)
- C#中怎么把Image转换成bitmap
- 水晶报表重复显示,不知道为什么?
FileAttributes attrs = File.GetAttributes("");
attrs = (FileAttributes)((int)attrs & ~(1));
File.SetAttributes("", attrs);
将
workSheet.SaveAs(parth,missing,missing,missing,missing,missing,missing,missing,missing,missing);myExcelbook.Save();
myExcelbook.Saved = true;
myExcelbook.Close(missing, parth, true);都去掉,试试看吧!我就是这么写的!