Page 1 of 1

Import data from xls xlsx

Posted: Sat Jul 27, 2024 8:13 pm
by MARCOREMMEDATA
Is there a way to import data from an xls or xlsx file?
Like BIF TRANSFORM_FILE that works with these file types?

Re: Import data from xls xlsx

Posted: Sat Jul 27, 2024 11:43 pm
by Dino
If you have lansa integrator, use the excelservice. Then you can read any content in an excel file

Re: Import data from xls xlsx

Posted: Tue Jul 30, 2024 3:22 am
by appbuilder
Transform file works with .xls files not .xlsx.

Re: Import data from xls xlsx

Posted: Tue Oct 22, 2024 12:10 am
by Jiri
XLS are supported? I suppose only A / B /C /D /O /T formats (or variants with unicode) are supported.
In fact D (DBF) is obsolete and XLS or XLSX would be much better, but I have no information about XLS format support in BIFs.
Of course, Integrator supports it a long time.