We are generating an excel file
from our .NET application using Aspose Cells and there is a need for some
restrictions on the generated excel:
1) We do not
want to let user insert columns as it’s a fixed template
2) It’s a
template with a pre populated data so we want to restrict adding additional rows
as well.
3) On the
generated excel, user can ‘edit’ values on cell, but we want to restrict the cells
that can be editable.
4) We want
to add ‘drop down list’ with pre populated values and user can only make selection
from the pre populated values.
What are the Aspose features we
can leverage here for adding these restrictions?
Hi,
Thanks for providing us details.
Well, you may try to use MS Excel’s advanced protection options to restrict users for inserting rows and columns in the protected worksheet, see the document with examples for your reference:
Moreover, you may try to either protect your desired cells or use allow edit ranges feature while protecting worksheet, see the document sections with examples for your reference:
I see you also want users to select predefined values only from dropdowns/lists in your editable ranges in the protected sheet. Well, you may try
data validation feature here, see the document section specially for your needs:
Hope, this helps a bit.
Thank you.