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 [image] XLSX After Conversion [image] I have attached the original file for testing. teste2.xls (15.5 KB)

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]

Convert XLS to XLSX problems

Help Activities

Yoichi (Yoichi) January 18, 2022, 11:35pm 2

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

Forum Engagement Daily Reports

Topic		Replies	Views
Convert xls to xlsx Help datatable , excel , activities	16	11730	October 28, 2020
Convert xlsx to xls Help excel , activities , question	13	3805	January 10, 2020
Change Excel file format .xls to xlsx Studio excel , studio , excel-scope , excel-automation	3	532	November 30, 2023
File conversion error OLE2 stream Help excel , activities , question	2	2358	October 12, 2020
Convert CSV file to Excel Activities excel , activities , question	4	490	May 24, 2023

Most Active Users - Yesterday
parvathi_ayanala
jamiejam
Anirudh_Tugawe
More details...

Convert XLS to XLSX problems

Related topics