Exporting CSP page with table to excel and retaining the format.

Question

Question

subbarao bellamkonda · Feb 22, 2016

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.

Discussion (4)0

Log in or sign up to continue

Ben Spead · Feb 22, 2016

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.

0 0

Robert Cemper · Aug 23, 2017

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

3 0

score 0 · Answer 1 · 2016-02-22T13:20:03-05:00

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.

score 0 · Answer 2 · 2016-02-22T14:46:28-05:00

Once exported it will be an excel report / table. So Zen has better control on that is what you mean then?

Thank you,

Subba.