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

JAYESH

Hi to all,

I am trying to export data from General Ledger Entry table.
Be'z of to many records in the G/L Table it is shoing me error while it is export data in to excel sheet.

Can any one have idea how to handle this situation.

Thank you..

Waiting for your reply..

Igor_Beeone

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

JAYESH

Hi Thanks for the reply

Can you please tell me how to split in to 2 or more sheet.

Thank you

chris_johnson

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

JAYESH

Thanks for the information....

David_Singleton

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.