i have a winforms application and i want to export data from the datagridview into excel. how would i do this? thank u for any help
i want the simplest approach.
maybe exporting to CSV is easier?
1
-
Please see article [enter link description here][1] [1]: stackoverflow.com/questions/8667291/…prem30488– prem304882014-03-03 11:36:15 +00:00Commented Mar 3, 2014 at 11:36
Add a comment
|
4 Answers
You have a number of options
- Write the data to a comma separated value (csv) file
- Use OleDB to write to create an Excel file and write the data to it
- Use the OOXML SDK to create an Excel file
- Write the data to an XML file that can be read by Excel
- Use the NPOI library to create and write to the Excel file
Those are a few options off the top of my head. Personally I would go with NPOI, I have used this in server based solutions and it is really easy to work with and quite fast. However it does not currenly support the xlsx file format, only standard xls. The library can be found here
I also found EPPlus, supports xlsx, but I cannot vouch for it since I have not personally used it.
Comments
The simplest approach would be to write the data to an XML file and then import that into Excel.
There's a WriteXML method on the DataTable class that will write the schema out as well so when you import it into Excel all your column headings will be imported as well.
It has the added advantage that you can import the data into other XML aware packages as well.
2 Comments
pstrjds
I agree, just iterate the rows in a foreach loop and export your cells to an xml file. This will really make it easy to import the data in a myriad of locations.
ChrisF
@pstrjds - if you want a simple data dump then you don't even have to iterate over the data yourself.
WriteXML will do it all for you. Obviously if you want to filter the data then you do need to do more work.There are many ways if you search Google. Here is one:
3 Comments
pstrjds
The article linked works as long as the user has excel on the machine. If you are looking for something more generic where it is exported into a format that can be imported into excel and does not require Excel to be installed than I would go with the XML output suggested by ChrisF.
Evan Mulawski
If you include the Excel DLL required and include it with your application when distributing it, Excel does not need to be installed on the user's computer.
pstrjds
you can distribute the PIA's but I don't think they work without Office installed, and actually reading the EULA in the Office PIA it sure sounds like you aren't allowed to install them if Office isn't installed.
Another option is to use something like the OpenDocument toolkit to create a "Spreadsheet" using the OpenDocument format. This way it can be opened in Excel, OpenOffice, LibreOffice, etc.
http://odftoolkit.org/projects/aodl/downloads
Here is a link to code snippets for the toolkit
http://odftoolkit.org/projects/aodl/pages/AODL-examples
Link to example creating a spreadsheet
http://odftoolkit.org/projects/aodl/pages/AODL-example-1
