Export to excel

mitnishant

hi
I need to create a report, which export all data of the particular report in separate sheets of the same workbook in excel.

means if i have two field like "No. " ans description, then

i need separate sheet for each "No." and "description."

No. Description
A1 abcdef
in one sheet

A2 123456 in another sheet in the same Excel .

BardurKnudsen

And the issue is...?

gvolkov

Create another sheet and put the data wherever required.

If Excel.CreateAnotherSheet THEN
InsertData INTO WHERE Required();

=D>

BardurKnudsen

There are some good examples in codeunit 424 Export Analysis View.
For example, adding a sheet:

xlApp.ActiveWorkbook.Sheets.Add();
xlWorkSheet3 := xlApp.ActiveSheet;
xlWorkSheet3.Name := FORMAT(Text002) + CONVERTSTR("Analysis View Code",' -+','___');
xlWorkSheet3.Range('A1').Value := AnalysisView.TABLECAPTION;
xlWorkSheet3.Range('B2').Value := Rec.FIELDCAPTION("Analysis View Code");

... and so on.

bangswit

after successful export to excel, it usually open that excel file
how to make after the export, the excel file doesn't opened automatically?
thanks

geronimo

bangswit wrote:

after successful export to excel, it usually open that excel file
how to make after the export, the excel file doesn't opened automatically?
thanks

you could keep the visible property of the xlapp to false and quit it when done by using it
some example of this can be seen in the excel buffer table

for example:
XlApp.Visible(FALSE); //when creating the xlapp variable

//when finished exporting
XlWrkBk.Close(FALSE);
XlApp.Quit;