CODEWITHSUNDEEP
pythonxlsxwriter
Stuart
Stuart

Reputation: 13

xlsxwriter unable to write more than 1,048,576 rows to multiple tables and worksheets

I have found that xlsxwriter supports the limits set by Excel Total number of 1,048,576 rows by 16,384 columns rows and columns on a worksheet. https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 https://xlsxwriter.readthedocs.io/worksheet.html?highlight=1%2C048%2C576

As my data is more than 1048576 row I am writing it to a unique table in a unique worksheet, I have tried setting the limit to 1000000 rows per table per worksheet and I get multiple tables and worksheets but only up to 1,048,576 rows.

I guess the question is can the workbook support more than 1,048,576 rows? If so there seems to be a problem, anybody any experience in writing beyond that?

Thanks

Upvotes: 1

Views: 3114

Answers (1)

jmcnamara
jmcnamara

Reputation: 41554

can the workbook support more than 1,048,576 rows?

No. That is the maximum row number that Excel supports per worksheet.

Update:

Here is an example that creates 1,048,576 rows in 2 worksheets:

import xlsxwriter

workbook = xlsxwriter.Workbook('row_file.xlsx')

for _ in range(2):
    worksheet = workbook.add_worksheet()

    for row in range(1048576):
        worksheet.write(row, 0, 'Hello')

workbook.close()

Output:

enter image description here

Upvotes: 3

Related Questions