Hi,
I have to download an .xls file which is done through automation. Along with that .xls file, a folder is automatically formed containing html, css, xml files with the same name as that Excel file.,
After downloading, I have to insert a column in that worksheet and update the same column with some data from BP. Whenever, I insert a column it usually deletes the entire sheet and while I am using Write Collection stage to write in that particular column, it does write.
But while working the same with .xlsx file, I am not facing this error.
Could anyone please suggest?
Thanks well in advance.