Import data from xls xlsx

This Q&A forum allows users to post and respond to "How Do I Do ....." questions. Please do not use to report (suspected) errors - you must use your regional help desk for this. The information contained in this forum has not been validated by LANSA and, as such, LANSA cannot guarantee the accuracy of the information.
Post Reply
User avatar
MARCOREMMEDATA
Posts: 14
Joined: Mon Apr 11, 2022 4:48 pm
Location: ITALIA
Contact:
Contact MARCOREMMEDATA

Import data from xls xlsx

Post 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?
MARCO ROSSI | Software Developer Sr. - Software Production
Top
User avatar
Dino
Posts: 472
Joined: Fri Jul 19, 2019 7:49 am
Location: Robbinsville, NC
Contact:
Contact Dino

Re: Import data from xls xlsx

Post by Dino »

If you have lansa integrator, use the excelservice. Then you can read any content in an excel file
Top
appbuilder
Posts: 28
Joined: Sat Jan 16, 2016 9:53 am

Re: Import data from xls xlsx

Post by appbuilder »

Transform file works with .xls files not .xlsx.
Thanks,

Don
Top
User avatar
Jiri
Posts: 52
Joined: Thu Feb 11, 2016 11:41 pm

Re: Import data from xls xlsx

Post 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.
Top
Post Reply

Return to “Questions & Answers”