Export DataGridView to Excel And Word WithOut Ms Excel And Word

[mehrnoosh]

hi every body how can we export a datagridview data to excel and word when Ms excel and ms word is not instal in system... can you help me please?! :doh: :confused::confused:

M.Alizadeh

[Wendelius]

Whole lot of good articles found with simple search: http://www.codeproject.com/info/search.aspx?artkw=export++data+to+excel&sbo=kw[^]

The need to optimize rises from a bad design.My articles[^]

[Ashutosh Phoujdar]

Hi, You can use following library for exporting to Excel : CarlosAg Excel Xml Writer Library[^] And for exporting to word : Gios WORD .NET Library (using RTF specification)[^] For exporting to word/excel, you must have to iterate through Row of datagridview rows, using following code snippet

For Each currentRow As DataRow In DataGridView1.Rows
'Use the values in current cell using following syntax.
currentRow.Cells(0).Value
currentRow.Cells(1).Value
currentRow.Cells(3).Value
'until all cells are covered.
Next

Alternatively if you are looking for only copying the data to excel/word, just select the data copy using (ctrl+c) and paste to word/excel (This will work with .NET framework version 2.0 and greater). Hope I answered your query. :) Thanks, Ashu

dnpro "Very bad programmer"

[rohan_puranik]

You can do one thing. Write the data of your DGV to a CSV (comma separated value) file. Whenever a user opens a CSV (on a machine having MS-Office) it will get open in MS-Excel by default. Here's a raw code snippet for each row in DGV get value of cell and store it in string append , (i.e. comma) end for trim last character of string //(because it would contain last appended comma) write this string to file "file.csv" save the file Whenever user open this CSV it will get open in MS-Excel. If a user does not have MS-Excel he/she may do one thing. Right click the file and open it in notepad. Hope this help you out.