Excel export stuff...

The_Taco
The_Taco Member Posts: 6
edited 2003-11-26 in Navision Attain
Ok, i'm very new to Navision and its C/AL language. The task I was asked for is to export data from Navision to Excel.

I know how to open or create Excel document from C/AL, but now, I need to transfert the data. I found some source code that explain me how to transfert the data by cell. The thing is that this method will be way to long to accomplish, I've got like 40k row to transfert from a table in Navision.

Is there any other do to this task?

Help would be greatly appreciated!
You love me, I love you.

Comments

  • Sbhat
    Sbhat Member Posts: 301
    Hi,

    Click on the the following link http://www.mibuso.com/dlinfo.asp?FileID=207 and you will have wonderful tool to export information from Navision to Excel. This should help you.

    Thanks
    Cheers
    Suresh. :lol:
  • The_Taco
    The_Taco Member Posts: 6
    Yeah, thx for the link!

    But I need to execute this at Run-Time. It's like, instead of using normal report in Navision, I'm using Excel, because I have to many columns (like 50).

    Or maybe I can use this tool at run-time via C/AL code?
    You love me, I love you.
  • Sbhat
    Sbhat Member Posts: 301
    Hi,

    Yes, you could just create a report with Dataitem integer and in the properties set Maxiteration to 1 and OnAfterGetRecord of the Data item call the link and you should be all set. I too did the same thing when i had to do exactly what you are trying to do.

    Thanks
    Cheers.
    Suresh. :lol:

Categories