When creating a pivot table, if the source data contains French characters in column names (like "Quantité", "No. du produit"), the creation fails with error:
"The field name is not valid. To create a pivot table report, you must use data that is in list format with column labels."
This happens even when using the correct column names with accents. The issue seems to be in how win32com passes the field names to Excel's PivotTableWizard.
Steps to reproduce:
- Have an Excel file with French column names (e.g., "Quantité", "No. du produit")
- Run:
xlforge pivot create file.xlsx "Sheet" "A1:U13459" --sheet "Pivot" --rows "Type" --values "SUM:Quantité"
- Error occurs even though column name is correct
This blocks users from creating pivot tables on French-language datasets.
When creating a pivot table, if the source data contains French characters in column names (like "Quantité", "No. du produit"), the creation fails with error:
"The field name is not valid. To create a pivot table report, you must use data that is in list format with column labels."
This happens even when using the correct column names with accents. The issue seems to be in how win32com passes the field names to Excel's PivotTableWizard.
Steps to reproduce:
xlforge pivot create file.xlsx "Sheet" "A1:U13459" --sheet "Pivot" --rows "Type" --values "SUM:Quantité"This blocks users from creating pivot tables on French-language datasets.