在参考Excel表，Iam试图清除工作表的内容，Workbook.Save（）不反映的变化在哪里作为Workbook.Saveas（）工作Fyn哪个在其他文件中保存... [英] In Ref To Excel Sheet , Iam Trying To Clear The Content Of Worksheet ,Workbook.Save() Is Not Reflecting The Changes Where As Workbook.Saveas() Is Working Fyn Which Save It In Some Other File...

问题描述

Microsoft.Office.Interop.Excel.Application myApp;
Microsoft.Office.Interop.Excel.Workbook myWorkBook;
Microsoft.Office.Interop.Excel.Worksheet myWorkSheet;
Microsoft.Office.Interop.Excel.Range range;

myApp = new Microsoft.Office.Interop.Excel.Application();
myWorkBook = myApp.Workbooks.Open("E:\\test101.xls", 0, true, 5, "", "", true,       Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
myWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)myWorkBook.Worksheets.get_Item(1);

if(myWorkSheet.ProtectContents == true)
   myWorkSheet.Unprotect("abc");
range = myWorkSheet.get_Range("B1:B2", Type.Missing);
range.Delete(Microsoft.Office.Interop.Excel.XlDirection.xlUp);

myWorkBook.Save();
//myWorkBook.SaveAs("E:\\test101.xls", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, System.Reflection.Missing.Value, System.Reflection.Missing.Value, false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlShared, false, false, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value);
			

myApp.Quit();

推荐答案

这篇关于在参考Excel表，Iam试图清除工作表的内容，Workbook.Save（）不反映的变化在哪里作为Workbook.Saveas（）工作Fyn哪个在其他文件中保存...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！