Exporting data from a DataTable in format other than XML

[Guest]

Is there a simple way to export the data from a DataTable (or even better a
DataView) in a format other than XML? In particular, how about a simple way
to export and save data directly to a new .xls file. I guess that if I needed
to I could write a line at a time to a .txt file and create a tab delimited
file, but I'm lookin' for some method() or pre-written code snippet that will
export directly to an .xls file.

 

[Guest]

Hi michael,

If it's web application, you can use bind dataview with a datagrid, then
export datagrid to excel:

http://www.c-sharpcorner.com/Code/2003/Sept/ExportASPNetDataGridToExcel.asp

HTH

 

[Val Mazur \(MVP\)]

Hi,

I believe there is a lot of different articles about it on a Web. Google
gives pretty good results if you query "How to export DataTable into Excel".
I solved this issue creating component

 

[Guest]

Thanks Val. Went to xPort and will try the application. Seems priced fine for
the amount of work that it would save me. How does the licensing work?. Does
it make entry into licenses.licx(which I find problematic when versions of
libraries change). Is source code available? Was it compiled for .NET 2.0?

Michael

 

[Val Mazur \(MVP\)]

Michael,

I could help you online to answer questions, but if you are interested in a
component, then send me an e-mail and I will answer all your questions
offline.