vanoord / pandas-xlsx-tables Goto Github PK

I got this error when using df_to_xlsx_tables
ValueError: NaTType does not support isocalendar

I have a data in master excel file which I am trying to split and store it in multiple child excel files.

I would like to format the data in child files as a table.

So, I tried the below code (using openpyxl)

tab = Table(displayName = "Table1", ref = "A1:" + get_column_letter(wb1.worksheets[0].max_column) + str(wb1.worksheets[0].max_row) )
style = TableStyleInfo(name="TableStyleMedium2", showFirstColumn=True, showLastColumn=True, showRowStripes=True, showColumnStripes=True)
tab.tableStyleInfo = style
wb1.worksheets[0].add_table(tab)

I found out that openpyxl doesn't allow to turn off bandedcolumns feature. That's when I came to know about this package

Is there anyway to format the tables based on table formatting options using pandas-xlsx-tables?

If you would like to know more about my issue, you can refer this SO post https://stackoverflow.com/questions/73188383/openpyxl-bandedcolumns-turn-off-table-formatting

Can your package support to format tables in excel based on table formatting options? Is there any documentation etc to know arguments, parameters etc?

Hi,

I think It would be great if there was a parameter to add the total row to the resulting xlsx file table,
like sum for column a, average for column b, something like a dict as parameter.
total_row = True, total_values = {'col1': 'sum', 'col2': 'avg'}

just an idea.
thx for this simple and practical lib :)