Notifications
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 3,229
Jainam M. Kothari 1,867 Super User 2025 Season 2
YUN ZHU 1,153 Super User 2025 Season 2
