web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to upload excel fi...
Small and medium business | Business Central, N...
Answered

How to upload excel file and read data

(0) ShareShare
ReportReport
Posted on by JustZM 962

Hi All

Does anyone know how to upload excel from PC and read data from excel? I found something, but all of them are enter file path, file name, and sheet name. However I want to open a dialog, and select file from PC. Then I can ready data from excel.

I found some code like this can help to upload excel file, but I have no idea how to ready data from excel row by row.

          FileMgt.BLOBImportWithFilter(TempBlob,ImportFromExcelTxt,'',FileExtensionFilterTok,ExcelFileExtensionTok)

Best Regards,

JustZM

I have the same question (0)
  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 95,597 Super User 2025 Season 2 on at

    Hi, here are two simple examples from BC that I hope will be helpful.

    How to use Excel Buffer to Import data
    https://yzhums.com/4223/

    How to use Excel Buffer to Export data
    https://yzhums.com/4180/

    By the way, if you search for 'ExcelBuffer', you should soon find the answer.

    https://www.cloudfronts.com/importing-excel-file-microsoft-dynamics-nav-using-excel-buffer/

    ZHU

  • Suggested answer
    JAngle Profile Picture
    JAngle 133 on at

    What you will note with Yun’s advice is it is worksheet by worksheet. That is how the file is handled. If you need to ignore that kind of logic you may consider a different file type like csv or xml. Alternatively you can get data from excel into NAV with a configuration package which reads all the data in the file. Note that uses an excel table so it can pass the data in a xml structure - which can ignore the worksheet logic

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 8,635 Super User 2025 Season 2 on at

    You will find lot of materials on this over internet, I will request you to give some more time and conquer this of your own, this is too simple and you will find complete code exactly the same you want over internet. :)

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,917

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,161 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,025 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans