Data on more than one sheet of same excel workbook.

mrigya
mrigya Member Posts: 124
edited 2009-06-12 in NAV/Navision Classic Client
Hello All,
hw can i export the data on more than one sheet of same excel workbook,different sheet for different conditions,while exporting the report to excel, using excel buffer.

Regards
Mrigya

Comments

  • dkone
    dkone Member Posts: 59
    Hi,

    What are you using to export to excel ?

    dkone.
  • bbrown
    bbrown Member Posts: 3,268
    Use the CREATESHEET function
    There are no bugs - only undocumented features.
  • mrigya
    mrigya Member Posts: 124
    Will you please eleborate your answer
  • Sandeep_Prajapati
    Sandeep_Prajapati Member Posts: 151
    1)fill excel buffer with your data for first sheet
    call CREATESHEET('YoursheetName1')

    2)fill excel buffer with your data for 2nd sheet
    call CREATESHEET('YoursheetName2')

    3)fill excel buffer with your data for 3rd sheet
    call CREATESHEET('YoursheetName3')

    ...and so on.
    Sandeep Prajapati
    Technical Consultant, MS Dynamics NAV
  • mrigya
    mrigya Member Posts: 124
    But how to fill the DATA on the second sheet?
  • Sandeep_Prajapati
    Sandeep_Prajapati Member Posts: 151
    CREATESHEET function cretaes a new excel sheet in the workbook and writes all the data you have pushed in excel buffer table, in that sheet.
    so,

    1)fill excel buffer with your data for first sheet
    call CREATESHEET('YoursheetName1'); //will create first sheet
    excelBuffer.Deletall;

    2)fill excel buffer with your data for 2nd sheet
    call CREATESHEET('YoursheetName2'); //will create 2nd sheet
    excelBuffer.Deletall;

    3)fill excel buffer with your data for 3rd sheet
    call CREATESHEET('YoursheetName3');//will create 3rd sheet
    excelBuffer.Deletall;

    ...and so on.
    Sandeep Prajapati
    Technical Consultant, MS Dynamics NAV

Categories