Password Protecting an Excel file in C

Question

Anyone who is familiar with this syntax? I've looked all everywhere, but the only thing I can find is C++ code for this. Using the System.IO.Packaging namespace, I'm attempting to programmatically password-protect an excel file.

Any thoughts?

Answer 1

Try this:

using Microsoft.Office.Interop.Excel

//create your spreadsheet here...

WorkbookObject.Password = password;
WorkbookObject.SaveAs("spreadsheet.xls")

I hope this helps you.