Multi-sheet Excel Export within a template
Options
scholaschl
Dataiku DSS Core Concepts, Registered Posts: 8 ✭✭✭
I would like to know if there is a way to use the Multi-sheet Excel Export Plugin by importing data into an existing Excel sheet (template)?
Answers
-
Keiji Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 52 DataikerOptionsHello @scholaschl
,Thank you for posting the question on Community.
Unfortunately, it is not possible to append sheets/data to existing workbooks/sheets.
- https://github.com/dataiku/dss-plugin-multisheet-excel-export/blob/23c234fa1603a72b708ff4f445a95c262b132efb/custom-recipes/to-excel/recipe.py#L53-L60
- https://github.com/dataiku/dss-plugin-multisheet-excel-export/blob/23c234fa1603a72b708ff4f445a95c262b132efb/python-lib/xlsx_writer.py#L24-L30
Would you please elaborate on your use cases (what you would like to achieve)? Would you like to append sheets to an existing workbook? Or, would you like to append rows to an existing sheet?
Sincerely,
Keiji, Dataiku Technical Support