Spire.Spreadsheet is a powerful component to view spreadsheet. As a standalone spreadsheet class library, Spire.Spreadsheet is a companion component to Spire.XLS, which mainly focus on how to display spreadsheet.

Wed Jan 02, 2019 6:45 am

Hi Betsy,

it is not posssible to open a password protected excel in the viewer.

GH

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

Wed Jan 02, 2019 8:10 am

Hi GH,

Thanks for your inquiry.
We have a method which could set the password when loading a password protected Excel file.
Code: Select all
                //set the password
                spreadsheet1.Password = "123";               
                spreadsheet1.LoadFromFile("FileName");

Yet, this code only work for Excel2010, if your file is generated by Excel2013, the method would not work. I have posted the issue with Excel2013 to our Dev team. Once there is any good news, we will let you know.

Sincerely,
Betsy
E-iceblue support team
User avatar

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

Return to Spire.Spreadsheet