Unable to create a new worksheet in Excel using Microsoft Excel plugin

261 Views
Last Post 16 April 2018

muthut@myvamla.com posted this 16 April 2018

I am just trying to open an Excel file and to create a new worksheet in the excel. I have used Microsoft Excel connectors and in that used AddnewWorksheet feature and tried. When i execute the scripts I am getting an error as
"An error occured while executing method 'MicrosoftExcel_2.AddNewWorksheet'.

Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))".