I am trying to download the report in .xlsx format which originally is in .xls format using Open option displayed on Pop-up.
Pop-up has an option to Open, Save & Save As somehow i cant use Save As because doing so is corrupting the data.
Instead I am opening the excel sheet and trying to save it in .xlsx via User Interaction like Click etc. but lately i observed that due to this not complete data is written in new excel sheet if the file size is large. For e.g. if file has 6000 rows then writes only around 1200-1300 rows then stops and save the file.
We can run the command young START PROCESS activity
—open notepad and mention the command with filepaths you have and save it as .bat file
— then mention the filepath of that .bat in start process activity as Filename