topic Excel Sheet Reporting Getting to Maximum in Report Server

Excel Sheet Reporting Getting to Maximum

M_nwadibia — Thu, 16 Feb 2023 14:55:31 GMT

Hello,

I am currently doing Excel Reporting in Reporting service. Currently I have 108k records and it will get to the max 150k.

What will happen to additional records when it get to maximum 150k?

I know in .xls format when the record gets to 65k, a new sheet starts with 6501 row.

So in .Xlsx what will hapen when it gets to 150k?

d_gosbell — Fri, 17 Feb 2023 02:37:00 GMT

M_nwadibia wrote:

I know in .xls format when the record gets to 65k, a new sheet starts with 6501 row.

Are you sure it does this? I was pretty sure it just stopped at 65000 rows.

M_nwadibia wrote:

So in .Xlsx what will hapen when it gets to 150k?

It just keeps going, the xlsx format can hold upto 1 million rows in a single sheet.

M_nwadibia — Tue, 11 Apr 2023 13:10:42 GMT

Thank you. My excel record just exceeded 150k records and it is still going. This confirms it can go up to one million