Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed Nov 21, 2018 9:33 am

Hey,

Dim wb As Workbook = New Workbook()
wb.LoadFromFile(FileName)
Try
wb.Worksheets(0).Protect("", SheetProtectionType.All)
wb.SaveToFile("C:\temp\test.xlsx")
Catch ex As Exception
Finally
wb.Dispose()
End Try

GHWels
 
Posts: 90
Joined: Sun Nov 23, 2014 7:22 pm

Wed Nov 21, 2018 9:53 am

Hi,

Thanks for your inquiry.
After an initial testing with the latest Spire.Office Platinum (DLL Only) Version:3.11.4, I didn't notice the issue you mentioned. To help us investigate further, please share your input and the output Excel files.

Thanks,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Tue Nov 27, 2018 9:23 am

Hi,

Greeting from E-iceblue.
How is your issue going now? Could you please give us some feedback at your convenience?

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.XLS