StrataFrame Forum » .NET Forums » General .NET Discussion » Export data to Excel

RE: Export data to Excel

StarkMike — Fri, 07 Sep 2007 12:01:13 GMT

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

Export data to Excel

Randy Moore — Fri, 07 Sep 2007 12:01:13 GMT

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?

RE: Export data to Excel

Peter Jones — Tue, 20 Mar 2007 17:35:55 GMT

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

RE: Export data to Excel

Paul Chase — Tue, 20 Mar 2007 15:32:10 GMT

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