Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi @FrancescoRusso ,
In addition to what has been suggested, you may also consider the Multisheet Excel export plugin which lets you take several different datasets and export them onto different tabs of a single Excel file.
Cheers,
Ashley W.
Hi,
This is quite easy to do with a bit of Python code: see example on http://xlsxwriter.readthedocs.io/example_pandas_multiple.html.
The equivalent also exists in R code:
https://statmethods.wordpress.com/2014/06/19/quickly-export-multiple-r-objects-to-an-excel-workbook/
Cheers,
Alex
Hi Francesco,
You can write to a folder with a python script. The file below shows how to write in the test_writeExcel.
test_writeExcel = dataiku.Folder("RaZzKNKs")
test_writeExcel_info = test_writeExcel.get_info()
name = 'test.xlsx'
df = pd.DataFrame({'Data': [10, 20, 30, 20, 15, 30, 45]})
path = os.path.join(test_writeExcel_info['path'], name)
writer = pd.ExcelWriter(path)
df.to_excel(writer, sheet_name='Sheet1', encoding='utf-8')
writer.save()
Hi @FrancescoRusso ,
In addition to what has been suggested, you may also consider the Multisheet Excel export plugin which lets you take several different datasets and export them onto different tabs of a single Excel file.
Cheers,
Ashley W.