Convert XLS to XLSX problems

[Israel_Silva]

Hi people.

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)

[Yoichi]

Hi,

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.

Regards,

[liu_shubin (Shubin)]

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.

[Israel_Silva]

It worked!!, thanks a lot