OWC 11.0 in ASP.NET and C# to create excel file

S

sreedeeplal

I'm using OWC 11.0 in ASP.NET and C# to create excel file.

I need to protect/unprotect the sheet by a password. I tried to protect the
sheet by following code.




string Password = "Password123";
object getPasswordFromUser =(object)Password;
xl.ActiveSheet.Protect(ref getPasswordFromUser, ref obj,
ref obj, ref obj, ref obj, ref obj, ref obj, ref obj, ref obj, ref obj,
ref obj, ref obj, ref obj, ref obj, ref objTrue, ref obj);But it throws an
exception "Exception from HRESULT: 0xE0040059"

Kindly help me to resolve this issue. Code works well if I miss the password.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

C# and Excel 13
How to convert and xml to excel ? 1
how to read word document in ASP.Net & C# 3
How to use java class object in ASP.NET? 1
how to create sub menu items in Excel? 1
Trying to use unmanaged with C# 0
How to replace an image in MS word using c# 1
deriving COM class compiles in C#, doesnt in VB.net 1

Top