Excel File Output : incorrect option for sheet name

amphi-ai / amphi-etl

Low-code ETL for structured and unstructured data. Generates Python code you can deploy anywhere.

https://docs.amphi.ai

Other

551 stars 12 forks source link

Excel File Output : incorrect option for sheet name #32

Closed amoradell closed 1 week ago

amoradell commented 1 week ago

Excel File Output component doesn't use correct name for sheet_name option

it uses "sheet" instead of "sheet_name"

incorrect sqlQuery1.to_excel("c:/dev/db/localites2.xlsx", index=False, sheet='Feuil1')
correct sqlQuery1.to_excel("c:/dev/db/localites2.xlsx", index=False, sheet_name='Feuil1')

tgourdel commented 1 week ago

Thanks for reporting, it's been fixed in the latest version: pip install --upgrade --force-reinstall amphi-etl (or jupyterlab-amphi if using Jupyterlab)

amoradell commented 6 days ago

I add engine = "xlsxwriter" option to pandas to_excel to compare with openpyxl