Lock Cells

Aspose.Cells Product Family
1

Hi,

I’m working on a report and I want to export it to Excel. However, the report will be emailed to people through an email subscription and users cannot edit the Excel file? How would I lock the cells?

Thanks,
Sandra

2

Hi,

Please try our latest version/fix (attached): Aspose.Cells for Reporting Services for SSRS2008R2 V1.9.0.42.

And modify the encryption parameters in Aspose.Cells.ReportingServices.xml

====================================================================================

<Aspose>

…………….

<Encryption value="ON">

<EncryptionType value="Microsoft Strong Cryptographic Provider"/>

<KeyLength value="128"/>

<IsWriteProtected value="true" pwd="123456"/>

……………………

</Aspose>

====================================================================================

When you need that all exported Excel files are read-only, you must set the name attribute of the report element to null.

Otherwise, you set the name attribute of report element to not null.

Please copy Aspose.Cells.ReportingServices.dll into following folder : ${SQL Server 2008 R2 Reporting Services}\Reporting Services\ReportServer\bin.

Please let us know your run result.

If you need other versions (e.g. for SSRS2008 SSRS2005 …. ), please tell us, we will provide you the new DLL file accordingly.

If you still face have any question, please tell us too, we will check it ASAP.

Thank you.