New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bug report: add_table to multiple sheets #51

Closed
calfzhou opened this Issue Sep 23, 2013 · 2 comments

Comments

2 participants
@calfzhou

calfzhou commented Sep 23, 2013

I'm using Python 2.7.5 and XlsxWriter 0.4.3, on Windows 8 x64 system. My MS Excel is Excel 2013.

I want to create two sheets, then add two tables to them in a reversed order (add the 1st table to sheet2, which is created later than sheet1; and then add the 2nd table to sheet1). But the output excel file will have some problem to open: "Repaired Records: Table from /xl/tables/table1.xml part (Table)", reported by Microsoft Excel.

Here is the sample code.

import xlsxwriter

book = xlsxwriter.Workbook('output.xlsx')

sheet1 = book.add_worksheet('Sheet1')
sheet2 = book.add_worksheet('Sheet2')

sheet2.add_table('A1:D10')
sheet1.add_table('A1:F5')

book.close()

I can fix it by calling sheet1.add_table before sheet2.add_table. But in real-life scenarios, it's very hard to do the exchange.

Fig: Expected Result:
tabel_expected

Fig: Actual Result:
tabel_actual

@jmcnamara

This comment has been minimized.

Show comment
Hide comment
@jmcnamara

jmcnamara Sep 23, 2013

Owner

Hi @calfzhou

Thank you once more for the detailed bug reports. They really make it easier to track down the issue.

This looks like a bug. I'll look into it. I had a similar issue with charts several months ago.

Owner

jmcnamara commented Sep 23, 2013

Hi @calfzhou

Thank you once more for the detailed bug reports. They really make it easier to track down the issue.

This looks like a bug. I'll look into it. I had a similar issue with charts several months ago.

@jmcnamara jmcnamara closed this in d7bc776 Sep 23, 2013

@calfzhou

This comment has been minimized.

Show comment
Hide comment
@calfzhou

calfzhou commented Sep 24, 2013

👍

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment