Worksheet level protection for .xlsm files using Aspose.Cells

Aspose.Cells Product Family
1

Hi,

We are able to do protection at work book level for .xlsm file. But we are not able to perform work sheet level protection for .xlsm file.

If we take .xls file we are able to do worksheet level protection.

Could you please let us know how to do worksheet level protection for .xlsm file using Aspose.Cells?

Thanks,

Valli.

2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Please download and try the latest version: Aspose.Cells for .NET 7.5.1 and see if it works fine for you.

If your problem still occurs, please provide us your sample runnable project replicating this issue with the latest version along with sample source files if you are using any.

We will look into your issue and help you asap.

3

Hi Faiz,

We have downloaded the latest version of dll from Aspose.Cells for .NET 7.5.1 as suggested
and added this to our solution. But after adding this, Aspose.Cells namespace is
not recognized by the new dll. Is there any change in the namespace with this
new dll?

Error details: The type or namespace name ‘Aspose’ could not be found
(are you missing a using directive or an assembly reference?)

Please find attached screenshot for your reference.

Could you please look into this issue asap?

Thanks in Advance,

Valli.

4
Hi,

I think you might be migrating from your Web application to your desktop (e.g console application) or using a console application. I think your VS.NET project’s Target framework is “.NET Framework 4 Client Profile”, then you should use the Aspose.Cells.dll component file located in "net3.5_ClientProfile" folder @ your installation directory. If your VS.NET project’s Target framework is “.NET Framework 4” or other (greater than or equal to 2.0), then you may simply use the Aspose.Cells.dll component file located in "net2.0" folder.

For your information, after installing the version, you will get different Dlls complied versions (net1.1, net2.0, net3.5_ClientProfile etc.). Please use "Aspose.Cells.Dll" in "net3.5_ClientProfile" at your installation directory if your target framework for your desktop application is .NET client profile.

Alternatively, you may change the Target Framework for your desktop application to other than .NET client profile, now you do not need to change the existing Aspose.Cells.Dll version.

Let us know if you still find the issue.

Thank you.