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	10986	October 28, 2020
Convert xlsx to xls Help excel , activities , question	13	3190	January 10, 2020
Change Excel file format .xls to xlsx Studio excel , studio , excel-scope , excel-automation	3	264	November 30, 2023
File conversion error OLE2 stream Help excel , activities , question	2	2191	October 12, 2020
Convert CSV file to Excel Activities excel , activities , question	4	378	May 24, 2023

Most Active Users - Yesterday
ashokkarale
anjani_priya
Dheerendra_vishwakarma
Parvathy
Aakash_Singh_Rawat
Luis_Fernando
bjorn2390
neco
pere
Shiva_Nikhil
More details...

Convert XLS to XLSX problems

Related Topics