Export more than one table to single worksheet

1

Hi there I am new to easy morph , I have this use case where I want to export the table as well as some derived aggregation to the same worksheet in excel. Like I have the report of customer payment this month and a derived table with total purchases and total no of customers. I need both of the table to be exported to the same excel file. Is there a way to do this?? Thank you

2

Hello Raj and welcome to the Community!

EasyMorph can only export one table into a sheet. However, you can organize your Excel as follows:

Have a raw data sheet. EasyMorph will import data into that sheet.

Have a user-facing sheet that references data from the raw data sheet. This sheet can have pivot tables, charts or regular tables that use the raw data sheet (or a range defined in that sheet) as a source.

1 Like
3

Hello,

You can prepare your Excel with “named range” and send data into these ranges.

1 Like