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!
I am trying to create and excel output with multiple sheet. This is what i've come up with so far.
with output.get_writer("Summary_File"+current_day+".xlsx") as writer:
report_df.to_excel(writer, sheet_name='summary')
cleaned_inbound_prepared_distinct_prepared_joined_df.to_excel(writer, sheet_name='Duplicates')
distinct_biomakers_df.to_excel(writer, sheet_name='Biomakers')
distinct_subjid_df.to_excel(writer, sheet_name='SubjectIDS')
distinct_visits_df.to_excel(writer, sheet_name='Vists')
all_df.to_excel(writer, sheet_name='numeric')
less_than_df.to_excel(writer, sheet_name='non_numeric')
Operating system used: windows
Hi @Scobbyy2k3 ,
You might want to try the 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.
more formatting
Hi @Scobbyy2k3 ,
You might want to try the 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.