Convert XLS to XLSX problems

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)

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,

2 Likes

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.

image

1 Like

It worked!!, thanks a lot

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.