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
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.
You can prepare your Excel with “named range” and send data into these ranges.