Testing To See If An Excel Workbook Is Protected

[dtqbterror]

I have an application that opens a Excel Workbook and updates several cells. Sometime the Workbook will be Password Protected and sometimes it will not. I have searched all over the Internet to find a way to test to see if the Workbook is protected before opening it. This way I can prompt for the password. Does anyone know if there is a way to check this in C#?

Thanks.

http://www.chiefscoalition.com

 

[ninjadeathmonkey]

Well, to my knowledge, there is not a way to open a password protected Excel file (at least using ADO.net). So I wouldn't be able to help you out there if you wanted to do that.

But if you are just looking to open unprotected files, and skip over protected ones, the best I could think of would be to open the file and do the updates in a try/catch block. I'm not sure what type of exception it throws, but catch for it and skip all the rest if it goes to the catch. Hopefully that helps a little.



Ron Wheeler

http://www.tekdev.com/