'OPENPYXL get_column_letter not working with exported PANDAS dataframe - any help? :)
I am taking data from a workbook using PANDAS and then exporting it into a new workbook. This is working as expected. When I create a table using OPENPYXL I usually use the following code:
table = Table(displayName="Table2", ref="B1:"+ get_column_letter(data_sheet.max_column) + str(data_sheet.max_row))
However this isn't working as my get_column_letter & row is returning 0. Here’s how I'm writing to excel:
pd.to_excel(destination_file_name,sheet_name="Sheet3")
Am I doing something wrong while writing to excel??
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
