Export zen page to CSV
Hi guys,
I've a zen page report that I would like to export to .csv file, any ideas on how to do that?
Thanks
Product version: Caché 2014.1
Hi guys,
I've a zen page report that I would like to export to .csv file, any ideas on how to do that?
Thanks
Hello Rochdi,
Have you resolved this? If not, are you using a report that is derived from %ZEN.Report.reportPage? If you are, you can use the "GenerateReport()" instance method to create an "xlsx" Excel file, which can then be exported to ".csv" after opening it from Excel.
https://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?...
Alternatively, the following code highlights how to generate a CSV file containing the results of a query:
Please confirm if this is helpful or if you have other questions.
Thank you
Yes thank you very much Jean
See %SQL.StatementResult:%DisplayFormatted()
Simple sample (for namespace "SAMPLES"):
As a result, the following files are generated:
Thanks Vitaliy
What is the process for a report that is derived from %ZEN.ComponentPage. Is it the same as %ZEN.Report.reportPage? As outlined in Jean Millette's comments.