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.
How to avoid this data loss ?
Thanks in Advance