Posts
1150
Comments
891
Trackbacks
1
C# Programming in Excel: To delete a worksheet, make it visible

Is programming in Excel better or worse than programming Sharepoint?

Anyhoo, I was trying to merge 5 single worksheet excel spreadsheets into a new spreadsheet, and then deleting the blank worksheet created when you create the new spreadsheet.

But when calling delete on it, I would get one of those fantastic COM errors you get when programming like it’s 1989.  I tried many different things before realizing:

app.Visible = true;

would do the trick (I made it invisible because it is a server side process).

Fantastic.

posted on Wednesday, October 19, 2016 4:24 PM Print
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 6 and 7 and type the answer here: