Write protect a worksheet


#1

I didn’t found a way to protect(write protect) a worksheet.
Is it possible to do that? How?
I need a quick answer.


#2

Hi, thanks for your consideration.

Now you can create a designer file with sheet-protected. Then you can use Aspose.Excel to read it and put your data.

I will investigate to add an API to enable you to do so.


#3

Yes, it is a solution, but I would like to set the protection from code.
I will use it the way you said for now, but I’d love to set it using the API.
When the new API will have this feature, please reply to this post.

Thank you.


#4

Sure.

I plan to provide this api in the next month.

Now thanks for your patience.


#5

OK.

Thank you


#6

Hi,

Now you can use Worksheet.Protect to protect a worksheet. Please download 1.8.0.0.


#7

It works.

Thanks for your quick support.

Calin