How to Export to EXCEL with multiple entities to the same worksheet
I have a requirement to export a page content to EXCEL. The page contents involves 3 different entities and all of them have to be exported into the same worksheet as different blocks. The page contents are structured as one header record and its associated line records. (1-* relationship). Can EXCEL Exporter appstore module be used for this purpose? From what i read about it , it can handle only one entity per worksheet. The document template generation option helps design a template for this scenario but the output format cannot be EXCEL. Any ideas on how to achieve this requirement?
Prasanna Shanmugakumarasamy DONOTUSE
What you could try is creating one big (NP)E and dump all the contents in there before doing the export to Excel. Depends a bit on how much data we talk if you should use persistent or non persistent entities. Other option might be is creating the Excel in Java.