Export to Excel

Business Central/NAV Developers Forum
1

Dear all,

How to Export Table’s data to a Excel Sheet (Sheet No. 1) which is already exist ??

2

Using Excel automation so you can have more control on your cell-pointers.

3

I do it all the time. I have master excel sheet for each individual table I want to export. Just open the Excel sheet first. Click - Clear contents - Open the Navision table and put the corner in the upper left corner. Click Copy - wait for the hourglass to go away - Click on the excel sheet and click paste.

Do any filtering of the Navision table before copying.

4

Hi Subrata,

  1. if you have NAV 40 and lesser version then you have to use Excel automation.

  2. if you ahev NAV 5 and more vesion then you can export table by creating form and click on "Send to Micorosft office excel ".

5

Hello Subrata,

If you want to use the existing file to send the data from NAVISION.

Then you have to use automation.

If you know how to use automation variables, then use the function GetOpenFileName to get the path (including file name), assign workbooks to the automation variable created for workbooks, open the workbook (existing file) using the open function of workbooks…!!

Here i have given you few hints, i hope you can manage to write code as per your requirements.

I have created 5-6 reports for my clients, and they are working well, I also have code, but better you try yourself, you will come to know more things about automation… that what I have done.

Best of luck…!!

Remember, workbooks and workbook both are different.

6

For convenient exports from dynamics into excel try this product (thousands of installs).

Use ez-gp from datapresentation.com for fast and reproduceable excel exports from dynamics

http://www.datapresentation.com/products/ez-gp.cfm

and download trial at www.datapresentation.com/downloads/dppi/ez-gp.exe

Steve

7

how to export to excel like in matrix form?

thanks

8

Sorry to disturb you all. I have done this with the automation.

Thanks