Exporting CSP page with table to excel and retaining the format.
Hi,
I have been working on a csp page and trying to export it to excel using the standard activex object. I would like to know if it is possible to export the table on the page with formatting to excel? Thank you in advance for any insight.
Thank you,
Subba.
If you are planning on exporting to Excel and showing as a web page, I would suggest that you look at using Zen Reports. It would give you the most control and you could get HTML, PDF and Excel all as output options.
Once exported it will be an excel report / table. So Zen has better control on that is what you mean then?
Thank you,
Subba.
Zen Reports is its own technology (not really related to our Zen web development stack). It's a full report-creation technology which some people use instead of reporting tools like Crystal Reports:
http://docs.intersystems.com/cache20152/csp/docbook/DocBook.UI.Page.cls?...
Because you are actually defining the report output, you can choose how it displays on HTML, PDF, Excel, etc.
this could have been what you were looking for.
it's pure CSP.
Light weight EXCEL download
https://community.intersystems.com/post/light-weight-excel-download
HTH