Exporting formatted data from listgrid

[researching]

Hi,

I'm a newbie, so please bear with me if I don't get the terms right.

I really like the nice on-screen formatting options with list grids. Is there a way to export a list -- with formatting -- to options such as PDF / Excel / etc.?

Best regards.

[Isomorphic]

There are options to print (as HTML) and SmartGWT EE has an option to Export to CSV, which preserves column order and whether columns are hidden, but not formatting such as date formats or custom cell formatters.

[senordhuff]

We've actually developed logic to export all the custom formatted cell values from the browser to the server and then to excel/csv/pdf. And, if the user is trying to export a large number of rows, we break the upload to the server into multiple requests. This way the user gets an export that looks exactly like what they are seeing in the ListGrid including column widths, column order, etc. The trade-off is the amount of data you have to upload to the server but it's worth it overall.

I'd be happy to share more details if interested. I know that Isomorphic has built an exportData feature into 7.0 but it looks like it is not capturing the formatted value from the browser like they mentioned in the previous post.

[kedavra]

senordhuff, I am interested in such kind of exporting. Can you show your code, please?

[gacisco]

Hi senordhuff,

Can you please share your solution for Excel export. We are not using smartgwt EE.

[mihai007]

I made a simple example of csv export in another thread, maybe you find it useful or even more, you could improve it and add into smartgwt extentions so all of us could benefit from: http://forums.smartclient.com/showthread.php?t=6788

[johndow777]

Hi, senordhuff. I was told that you managed to integrate light streamer with smart client( smart gwt?!) could you give me a clue how did you do this?

Regards.