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

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

Reply

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

Children

185

Nick posted over 10 years ago in reply to Mike Dour

For anyone else who may need this functionality the ability to password protect a workbook was added in 13.2 Service Release February 2014
Cancel
Reply

Cancel
44743

Mike Dour posted over 12 years ago in reply to Ron

As explained by Dimi here, we cannot support password protected files for legal reasons.
Cancel
Reply

Cancel
20

Ron posted over 12 years ago in reply to [Infragistics] Vince McDonald

Hi Vince,

I was wondering if FR12065 was ever done or if it's on the list for the next release. I'm looking to password-protect a workbook.

Thanks,

- Ron
Cancel
Reply

Cancel
45049

[Infragistics] Vince McDonald posted over 14 years ago in reply to Mike Dour

yaminih2,

I've just submitted feature request FR12065 for the functionality to password-protect a workbook or worksheet through our Excel engine to be added to a future version of the toolset.

For anyone else who is interested in seeing similar functionality in a future version of the NetAdvantage for .NET toolset, you can submit a feature request here. Remember, as Mike mentioned, the number of requests we receive for a given feature is one of the tools we use to prioritize what functionaltiy goes in to a given release.
Cancel
Reply

Cancel
44743

Mike Dour posted over 14 years ago in reply to Yamini

You can protect the entire workbook by setting the Workbook.Protected property to True.

As far as whether this will get implemented, I cannot say. But the number of feature requests for a particular feature does play a big part in what gets implemented. So I will ask the Developer Support Manager to add you to this feature request and that will increase its priority.
Cancel
Reply

Cancel