Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have been stuck on this for some time now... no matter what I do, I can't seem to programmatically delete a worksheet from a spreadsheet! I've tried many different approaches, and none of them seem to work. There must be something staring me in the face, but I just can't see it! Below is a stripped down app to delete a sheet (not working) - can anyone identify why? or give me some pointers as to how to approach this? Many many thanks for your help Luvic. static void Main(string[] args) { Microsoft.Office.Interop.Excel.Application ExcelApp = new ApplicationClass(); Workbook workbook = null; try { workbook = ExcelApp.Workbooks.Open(path,0,true,5,"","",true,X lPlatform.xlWindows,"",false,false,0,false,null,nu ll); ExcelApp.Visible = true; ExcelApp.DisplayAlerts = false; ((Worksheet)workbook.Sheets["Sheet1"]).Delete(); } catch { } finally { NAR(workbook); ExcelApp.Quit(); NAR(ExcelApp); } } private static void NAR(object o) { try { System.Runtime.InteropServices.Marshal.ReleaseComO bject(o); } catch { } finally { o = null; } } |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
deleting of worksheet | Excel Discussion (Misc queries) | |||
Deleting a worksheet but retaining values from the worksheet. | Excel Discussion (Misc queries) | |||
Deleting a worksheet but retaining values from the worksheet. | Excel Discussion (Misc queries) | |||
deleting values in a worksheet without deleting the formulas | Excel Worksheet Functions | |||
deleting worksheet | Excel Discussion (Misc queries) |