Export To Excel Advanced

[DJCRIS12]

http://i287.photobucket.com/albums/ll145/_DJ_CRIS_08_/prog.jpg[^] Here is a picture of my app, as you know i want to export selected columns to an excel file, but if theres another easy way to create a report please let me know, sorry about this i'm not an expert of C#. :(

[Lost User]

DJCRIS12 wrote:

as you know i want to export selected columns to an excel file, but if theres another easy way to create a report please let me know

I didn't know. The simplest way of creating a report is by exporting it as text. The second simplest way is to export is as HTML. Excell accepts a lot of weird formats; you could save your file as "comma separated values", as HTML/XML and as their native format. I'd recommend the CSV-version, as that would be the most simple to achieve.

Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

[RobCroll]

I agree with Eddy. I'd go for a CSV format because it's supported by other spreadsheet applications and requires no dependency on Excel. If you do go with Excel also be aware that if it crashes you can start creating new instances. Unless handled properly. Depending on where you are, you're also going to have to change the regional settings to US and back again to avoid exceptions.

"You get that on the big jobs."

[ignrod]

I use ExcelLibrary which can be downloaded from Google code

License is GNU LGPL.