python2.7 xlsxwriter doesn't write more then 65533 rows

Question

Hi I am tring to create a xlsx file but, I can write more the 65533 rows the object I am using is Xlsxwriter?

how can I write more rows?

Answer 1

Simple test:

import xlsxwriter
workbook = xlsxwriter.Workbook("test.xlsx")
sheet = workbook.add_worksheet()
for i in range(1, 70000):
    sheet.write('B' + str(i), "Blub")
workbook.close()

After that I have opened the file test.xlsx in Libreoffice, eh voila :)