search

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 : add engine option #43

Closed amoradell closed 6 days ago

amoradell commented 6 days ago

Default engine is openpyxl but Excel shows a warning when reading file saved with this engine. When I use xlsxwriter as engine, no warning

filter2.to_excel("c:/dev/db/localites3.xlsx", sheet_name="cp_multi_localites", engine = "xlsxwriter")

tgourdel commented 6 days ago

Hi @amoradell, thanks for your suggestion. It's been added in the latest version: 0.4.7. I actually chose xlsxwriter as the default engine. You can update with: pip install --upgrade --force-reinstall amphi-etl