The CarlosAg Excel Xml Writer Library does not require Excel in order to generate Excel Workbooks. I already presented a method to print a DataGridView (here) and now i present you a method that allows you to export a DataGridView to an Excel Workbook: DataGridViewToExcel.zip.


Thank you very much, I have been searching for a way to implement this using other methods, but this one really does the trick.
thank you very much, my extension isn’t supports color so this the best support for me
Thanks a lot a wonderful application…. many and many hours saved (not to speak of headache)
Tim great work.
This will come in very handy!
Just a quick one, from your example code what line needs modifying to apply a different style to column headers? I’ve been trying to make this work for few hours now and I know its something simple.
Any help appreciated.
also does anyone know how to set the page orientation to landscape?
Thanks
can I get this code in vb.net
Sir,
i have a one question..
if I have 2 datagridView in 1 form, whether it can convert both datagrid into 1 file?
Thanks
I suffer with it for two days
great work……..
hey,great code. Can i please get it in vb.net?