open protected excel

[GHWels]

Hi Betsy,

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

GH

[Betsy.jiang]

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