I’m having problems converting xls to XLSX, every time I perform the conversion the data in column “E” and “Y”, lose their original value.
XLS Before Conversion
XLSX After Conversion
I have attached the original file for testing.
teste2.xls (15.5 KB)
Your attached file is not xls format but text format.
Anyway, how did you convert it to xlsx? I recommend to use SaveExcelFileAs activity in modern-excel as the following.
Sample20220119-1.zip (4.3 KB)
Hope this helps you.
Another way is to use “Read Range” activity to read XLS file and “Write Range” activity to write Datatable to XLSX file. You refer to the screenshot.
It worked!!, thanks a lot
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.