Set a name to Excel Table with Python

Question

I'am trying to set a name to Excel table (that i created with the code below) in order to replace the default one

    with pd.ExcelWriter('pandas_table.xlsx', engine='xlsxwriter') as writer:
        df.to_excel(writer, sheet_name='StgFull', startrow=1, header=False, index=False)
        workbook = writer.book
        worksheet = writer.sheets['StgFull']
        (max_row, max_col) = df.shape
        tabname = 'abcd'
        column_settings = [{'header': column} for column in df.columns]
        worksheet.add_table(0, 0, max_row, max_col - 1
                            , {'columns': column_settings}
                            )
        worksheet.set_column(0, max_col - 1, 12)
    writer.save()

This help? xlsxwriter.readthedocs.io/working_with_tables.html — Jonathan Leon
– Jonathan Leon, Commented Nov 18, 2020 at 19:15
When i tried to add the parameter name, i've got an error : TypeError: add_table() takes from 5 to 6 positional arguments but 7 were given — Maher Kebaier
– Maher Kebaier, Commented Nov 18, 2020 at 19:20

Maher Kebaier · Accepted Answer · 2020-11-18 19:54:05Z

2

Well, i had to do this :

worksheet.add_table(0, 0, max_row, max_col - 1
                            , {'columns': column_settings
                            ,"name": "TabName"}
                            )

answered Nov 18, 2020 at 19:54

Maher Kebaier

1233 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Set a name to Excel Table with Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related