Ennvironment: Mac OS X 13.0.1; Service Studio - Version 11.53.33 / Build 61790
I am new to Outsystems.
I am trying to create the database from loading an Excel file. The system complains about the .xlsx file: Unable to import Excel file: The file is not an Excel fileClick Help for more information on supported formats.
I checked the mime type: Microsoft Excel 2007+Then file is created using Libre Office calc, Version: 7.4.3.2
How can I load the file?
can you please share the excel file here or snapshot of data ?
did you check below document ?
https://success.outsystems.com/Documentation/10/Developing_an_Application/Use_Data/Bootstrap_an_Entity_Using_an_Excel_File?_gl=1*135zf8*_ga*NDMxNTk1ODI1LjE2NTU4MDc2OTM.*_ga_ZD4DTMHWR2*MTY3MzE5NDAwOS4zMzEuMS4xNjczMTk1NDc4LjYwLjAuMA..
Please give one try to below forge component also,
https://www.outsystems.com/forge/component-overview/355/advanced-excel
Thanks,
Ajit Kurane.
The file failing has data I can't share... But I created a file from scratch and that worked fine. So, I must assume my file, although it open fine in both Libreoffice and MS-Excel must contain something that makes it fail. I'll try to find what makes it fail by reducing the file in small steps. The file has 36 sheets, 91605 cells, 43 pages, 3759 formula groups so that will take some time.
Thank you for referring me to the document.
In the mean time we can assume this solved.
Thans again
You are welcome.
Good to know.