My usecase is pretty simple. i just have to copy data from one sheet in a workbook(.xls format) and paste it in an another workbook dynamically creating a sheet(.xlsx format). when i tried it, it worked well for the first time. i deleted the sheet in the workbook and tried pasting it again. it should have created a new sheet in workbook and pasted it just like it did first time. but i am getting error as “object reference not set to an instance of an object”.
Now, i am not able to do anything in that sheet. read range and write range also gives the same error.
(Note: I don’t have excel i am working libre office software for accessing .xlsx format files .).
Kindly help me with this one.