Protect an excel file | Infragistics Forums

Protect an excel file

Usuario posted over 15 years ago

Hi,

I need to load an excel file using the Infragistic.Excel component, insert some values in it and save it as a new document. The user must download this document for print out the document, but he cannot change anything from it. There is were my problem start! I load an excel with a protected sheet, and save it as a new document. This new document is protected, but if the user go to Tools --> Unprotect, he can unprotect it and change the values!
There is a way to protect an Excel using a password?

Best regards!

Parents

No Data

Reply

44743

Mike Dour posted over 15 years ago

There is currently no way to password protect an Excel document using the Excel assembly. You can submit a feature request for this: http://devcenter.infragistics.com/Protected/RequestFeature.aspx.
Cancel
Reply

Cancel

Children

145

Yamini posted over 14 years ago in reply to Mike Dour

I tried the following scenarios:

1.) Protected Workbook:

--> Protected workbook (excel file)with a password

--> Set Locked property for specific cell /row to "False" eg Cell F6

--> Result --> I get a stream exception when writing to the file. This feature is not supported in Infragistics.Excel as confirmed by the support team in a previous post.

2.) Protected Worksheet:

(a)--> Protected worksheet with a password

--> Set Locked property for specific cell/row to "False" eg Cell F6

--> Result --> Cell F6 is editable and other cells are non-editable .

Code:

String filename = "C:\\ABC.xls";

Infragistics.Excel.Worksheet sheet = filename.Worksheets[0];

sheet.Rows[5].Cells[7].CellFormat.Locked =

ExcelDefaultableBoolean.False;// Cell locking disabled

sheet.Rows[5].CellFormat.Locked =

ExcelDefaultableBoolean.False; // Row locking disabled

(b)--> Protected worksheet with a password

--> Set Locked property for specific cell/row to "True" eg Cell F6

--> Result --> Cell F6 is non-editable and other cells are editable .However,if I set the Locked property of entire row to "True", all cells become editable . This looks like a bug, posted a query to the support team.

Code:

String filename = "C:\\ABC.xls";

Infragistics.Excel.Worksheet sheet = filename.Worksheets[0];

sheet.Rows[5].Cells[7].CellFormat.Locked =

ExcelDefaultableBoolean.True;// Cell locking

sheet.Rows[5].CellFormat.Locked =

ExcelDefaultableBoolean.True; // Row locking, doesnt work.

For Both (a) and (b),However, when I goto Tools-->Protection --> Unprotect Sheet, i dont get prompted for a password. This means the protection property has no purpose.Will this feature be implemented in future release. Also there is no option to protect entire workbook.
Cancel
Reply

Cancel