StrataFrame Forum

Export data to Excel

http://forum.strataframe.net/Topic7611.aspx

By Randy Moore - 3/20/2007

I would like to be able to read a text file, extract what I need from it and create a datatable based on the extraction. Then I would like to be able to export that data to excel. Some cells would have to have custom formatting at run time and I don't want to have to use a template in order to achieve this. I've already done some research and found several ways of doing this, but wanted to know if anyone has their own way of doing it, an industry standard, or if there are any 3rd party software that would accomplish this task. I think DevExpress' XtrReports can do this but don't want to bother creating the report first. Any thoughts?
By Paul Chase - 3/20/2007

Not 2 sure about 3rd party stuff but I have used both Com Interop and XSLT to export data from excel if I needed to do formatting otherwise I just comma delimit it and write it to file. Like anything else it takes a little time to figure out how to do what you want but there are tons of examples on google.

Paul

By Peter Jones - 3/20/2007

Hi Randy,

If you have DevExpress then doing a 'report' on a grid is really easy and once you have the report on screen (in preview mode) then exporting it to Excel (or pdf or rtf etc) just takes a few clicks.

Peter

By StarkMike - 9/7/2007

Hi Peter, could you provide some more detailed info about this topic? Thanks