Posted: 13 Mar 2020 6:56 EDT Last activity: 16 Mar 2020 16:21 EDT
Error opening Excel using ExcelConnector
I have an excel sheet which is password protected, and i am able to open it using MSExcel through studio, but if i use ExcelConnetor to open the same excel, its throwing error as "Error opening'Excel Path' workbook".
I have even given password in the ExcelConnector's password property, still the same issue. However, i am able to open other excel which is also password protected using ExcelConnector.
can anyone please help me understand where i went wrong