Export Data in to Excel - Error be'z of to many records

Hello,
there are too much of entries in G/L and Excel has limitations for rows count to 65XXX (BIFF format).
If this type of exporting for analysis purposes try using ODBC connection from Excel to Navision.
Otherwise if you need to export data to excel in any way, then you can split it to many sheets, f.e. - by date. Or smth. else.
Br,
Igor Beeone

Hi there,

You can change the tab on the worksheet by using the following:

Excelsheet := xlSheet.Item(pagenumber);
excelsheet.activate;

where:
Excelsheet is an instance of the Excel object 'Worksheet'
xlSheet is an instance of the Excel object 'Sheets'
pagenumber is an integer and is the number of the current sheet in Excel

I'd just put a simple IF statement in to change the increment the page/sheet number and reset the row pointer when you hit a certain row number on the current sheet e.g.

IF rowno > 50000 then begin
sheetno := sheetno + 1;
rowno := 1;
end;

This is all off the top of my head so it would probably pay to double check it (i've been known to be wrong in the past! )

By the way, I think there is some more information in the Tips&Tricks section on Excel.

Hope this helps

Igor Beeone wrote:

Hello,
there are too much of entries in G/L and Excel has limitations for rows count to 65XXX (BIFF format). ...

In Excel 2007 its over 1 million rows, so wont it be fun when people try to copy paste one million records from Navision to excel.