Excel Automation - How to add a new sheet by report header..

gison
gison Member Posts: 128
edited 2007-11-23 in NAV/Navision Classic Client
Dear all,

I need to print a document and add new sheet by report header.
Does anyone know how to create one sheet for this report.
Here are my codes, even I repeat these code it still just one sheet for the workbook. Does any one have idea? thank you. :?
===
xlBook := xlApp.Workbooks.Add(-4167);
xlSheet := xlBook.ActiveSheet();
xlSheet.Name := 'Picking List';
===

Comments

  • gison
    gison Member Posts: 128
    I meant, If we got 2 Dataitem in the report and underneath one is indented.
    Could we add new sheet depend on how many record we got in the dataitem(no indented one) ?! :-s

Categories