Restrict adding columns and limit editable cells on generated excel

[rdikshitdeloitte]

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?

[Amjad_Sahi]

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:

https://docs.aspose.com/display/cellsnet/Advanced+Protection+Settings+since+Excel+XP

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:

https://docs.aspose.com/display/cellsnet/Protecting+Worksheets#ProtectingWorksheets-ProtectafewCellsintheWorksheetUsingAsposeCells

https://docs.aspose.com/display/cellsnet/Protecting+Worksheets#ProtectingWorksheets-AllowUserstoEditRanges

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:

https://docs.aspose.com/display/cellsnet/Data+Filtering+and+Validation#DataFilteringandValidation-ListDataValidation

Hope, this helps a bit.

Thank you.