Reading password protected excel file

Question

Hi I want to open an password protected excel file. I search from internet and read lots of page but I couldnt able to success. http://www.codeproject.com/Articles/10257/Automating-MS-Excel-Using-Visual-Studio-NET I add using Microsoft.Office.Interop.Excel; to my web project and try lots of codes but its not working. Basically how may I do that? Regards.

yokzu · Answer

Isnt this possible?

yokzu · Answer

Thanks for your reply Suthish but it cant help me. I find another page; http://www.codeproject.com/Articles/10257/Automating-MS-Excel-Using-Visual-Studio-NET But VS doesnt recognise the codes below; this .excelWorkbook = this .excelApp.Workbooks.Open( fileName vk_update_links vk_read_only vk_format vk_password vk_write_res_password vk_ignore_read_only_recommend vk_origin vk_delimiter vk_editable vk_notify vk_converter vk_add_to_mru vk_local vk_corrupt_load); I cant create an instance of excelWorkbook.

Suthish Nair · Answer

I think Jet OLEDB does not support password protected Excels. But still you can refer: http://stackoverflow.com/questions/1502781/read-write-excel-2007-password-protected-documents http://social.msdn.microsoft.com/Forums/da-DK/csharpgeneral/thread/9f6f60d8-24f5-4b99-b547-f9938d4abff4