Workaround to ‘Edit in Excel’ functionality with Import/Export using Excel Buffer in Business Central

olisterr No Comments

Problem Definition:

When working with ‘Edit In Excel’ functionality in Business Central, there was an error( https://github.com/Microsoft/AL/issues/4060 ) when the page fields were modified using extensions.


Excel Buffer is one of the feature that is widely used to Import & Export data to and from Excel Sheets. With NAV evolving to Business Central, few of the existing functions are deprecated and cannot be used in AL Extensions.


Microsoft Dynamics 365 Business Central


  1. Excel Buffer Import:

In this code, total rows and columns to be imported is found, then each field is stored as ‘CellValue’ in new records in Excel Buffer. Thus, I’ve used GetValueAtIndex(Row,Column) function to get the exact ‘CellValue’.

2. Excel Buffer Export:


In this blog I’ve demonstrated how to use Excel Buffer for Import/Excel of Excel from a table using AL Extensions.

NOTE: Code is located( https://github.com/olisterr/ExcelBufferImportExportforBC )

Building a bottle light for the balcony part -1

olisterr One comment

Densing the climber framework for the garden

olisterr No Comments

Cleaning the window hanging money plant

olisterr One comment

Linux From Scratch – 12. Installation of GCC Compiler for the LFS final build

olisterr 9 comments

Linux From Scratch – 11. Installation of the packages for the LFS final build.

olisterr No Comments

Project Liter of Light

olisterr No Comments

Linux From Scratch – 6. Compilation of GCC-6.2.0 Pass 2 Part – II ,Tcl Core, Expect and Check

olisterr 12 comments

Linux From Scratch – 7. Installation of DejaGNU, Expect, Check, Bash, Ncurses and CoreUtils

olisterr No Comments

Linux From Scratch – 8. Installation of required Linux Packages.

olisterr No Comments