Export to All in a signle Excel Sheet

navuser1
navuser1 Member Posts: 1,334
edited 2008-12-03 in NAV/Navision Classic Client
Hi All,

Using Excel Buffer Can I create a excel sheet which contains the both Header and Line part of a document(PO, SO etc)?

waiting for your reply..
Now or Never

Comments

  • kapamarou
    kapamarou Member Posts: 1,152
    Using Excel Buffer you say Where you want to place any data you want. So you can say ant Cell(x,y) place Sell-To Customer and at Cell(x+1,y+1) place item no from line... You can do whatever you want. You fill the buffer and then send it to excel. So either you don't have a problem or I don't quite get the question... :D
  • navuser1
    navuser1 Member Posts: 1,334
    Thanks for your reply.
    Now or Never
  • navuser1
    navuser1 Member Posts: 1,334
    kapamarou wrote:
    Using Excel Buffer you say Where you want to place any data you want. So you can say ant Cell(x,y) place Sell-To Customer and at Cell(x+1,y+1) place item no from line... You can do whatever you want. You fill the buffer and then send it to excel. So either you don't have a problem or I don't quite get the question... :D


    Where is Cell(x+1,y+1) In Excel Buffer ??

    I think that i hv to use Automation Server Also..
    Now or Never
  • kapamarou
    kapamarou Member Posts: 1,152
    Cell(x+1,y+1) is an example meaning Row X+1 and Column Y+1.


    What you need in table 370 is to insert a line With :

    Row No. <- This represents the Excel Line.
    Column No. <- This represents the Excel Column.
    Both make up the Cell.
    Cell Value as Text <- This represents the value of the cell.

    You don't really need an automation. Everything can be done through table 370 in which an automation is used.

    I suggest you investigate this table with it's fields and functions and see an example of how it is used...

    You could find a first example in Form 554 Analysis by Dimensions...
  • navuser1
    navuser1 Member Posts: 1,334
    Thanks =D>
    Now or Never
  • kapamarou
    kapamarou Member Posts: 1,152
    Glad to help.

    And a tip: Usually when I use excel buffer I declare it as a Temporary table variable in order to avoid filling the real table and deleting the values after my process has finished...
  • navuser1
    navuser1 Member Posts: 1,334
    Before insert the data into the Temp table I always delete the data from It.
    But you mentioned that you delete the data after all process finished
    why??
    Now or Never
  • kapamarou
    kapamarou Member Posts: 1,152
    I said that whenever I use Excel Buffer I declare the record variable as a Temporary in order to avoid having to delete the records first and clearing the records when I finish. Also since many users might be inserting records to that table they may come across problems, since if the variable is not Temporary then the actual database table is filled with data.
  • navuser1
    navuser1 Member Posts: 1,334
    How can I change the font Size & color of text at the time of Exporting??
    Now or Never
  • kapamarou
    kapamarou Member Posts: 1,152
    viewtopic.php?f=23&t=17881&start=0&st=0&sk=t&sd=a&hilit=Excel+font+color
  • navuser1
    navuser1 Member Posts: 1,334
    kapamarou wrote:
    http://www.mibuso.com/forum/viewtopic.php?f=23&t=17881&start=0&st=0&sk=t&sd=a&hilit=Excel+font+color


    This link says about Excel Buffer table modification :!:
    [-X
    Now or Never
  • kapamarou
    kapamarou Member Posts: 1,152
    kapamarou wrote:
    This link says about Excel Buffer table modification :!:

    So? You don't want to modify that table???
  • navuser1
    navuser1 Member Posts: 1,334
    No. No modification I want.
    Now or Never

Categories