Small and medium business | Business Central, N...

How to modify the excel data

(2) Share

Report

Posted on by Vishok

I just want to read the excel file from my PC. And also if i try to insert a new record into that file it will insert. And if the record is already in the file it will modify that value.

All responses (4)

Answers (0)

Vishok 10 on at

Like (0)

Report

How to modify the excel data

I just want to achieve the above functionality using AL programming?
Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (2)

Report

How to modify the excel data

This sounds like standard functionality, you can do it in Configuration Package, or Edit in Excel

Hope the following helps.

Microsoft Dynamics 365 Business Central: How to Export and Import Data (Using Configuration Packages)

https://yzhums.com/4286/

Dynamics 365 Business Central: How to use Edit in Excel in the browser/web (Excel Online)

https://yzhums.com/39161/

Thanks.

ZHU
Suggested answer

Valentin Castravet 24,910 Super User 2024 Season 2 on at

Like (2)

Report

How to modify the excel data

You can do this by using the 'Edit in Excel' function that exists throughout the system. More info here - Viewing and Editing in Excel From Business Central - Business Central | Microsoft Learn

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
Suggested answer

Mohamed Amine Mahmoudi 9,738 Super User 2024 Season 2 on at

Like (2)

Report

How to modify the excel data

Hi,

I hope this can help you and give you some hints.

https://learn.microsoft.com/en-us/dynamics365/business-central/across-work-with-excel

https://www.youtube.com/watch?v=eGJrtFJAfao

Best regards,

Mohamed Amine MAHMOUDI