Announcements
No record found.
i'm trying to read xlsx file in xmlport but i get error: '', hexadecimal value 0x03, is an invalid character. Line 1, position 81.
but when i copy the data too csv it works fine. is there anyway to fix this?
XLSX is not a pure XML file.
If you rename XLSX into zip and then extract that, then you will see that is made of a lot of files.
If you have an XSLX file you should read it through Excel utilities. You might find some piece of code inside the standard application how to handle XLSX files (e.g. check rapidstart).
You can refer to "Import budget from Excel" report on how to import excel file. But you need to change the import file to use Stream if you are using business central cloud.
You can use below code upload file to blob
Use below code to get excel sheet from stream
Use below code to read the excel book from stream
so i should import the file using excel buffer right?
and can i skip columns and rows in excel buffer?
ty both i did it i had to remove all xml code and make excel buffer to get the data, thank you
Please mark this thread as answered then, many thanks.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 554 Super User 2026 Season 2
YUN ZHU 360 Super User 2026 Season 2
Teagen Boll 201 Super User 2026 Season 2