Altering table heading values results in corrupted output

Issue #1258 new
Allan Barcellos created an issue

Running openpyxl-2.6.2

When loading an existing workbook with a table, altering one of the table headings will always result in a corrupted output file.

I have attached a test script and the input and output results.

Comments (2)

  1. CharlieC

    The problem is that Excel expects the data in the table and in the worksheet to be kept in sync. openpyxl can do this when a table is created, but it would become a lot more complicated for existing files. Also, this is not a requirement of the OOXML specification, just something that Excel likes. Excel is normally happy to complain about the file but fix it.

    This is the kind of application-like functionality that we don't intend to provide. We hope soon to improve the API for working with tables so that it's easier for client code to manage them.

  2. Log in to comment