How to copy and paste each column of a datatable to excel in asp.net

check out this link it may help u

http://www.excel-spreadsheet-authors.com/how-to-convert-a-data-table-to-a-range.html/[^]

References and namespaces:
using Microsoft.Office.Interop.Excel;
using Microsoft.Office.Interop.InfoPath.Xml;
using System.Xml.Xsl;
using System.Xml;



<pre lang="c#">XmlDataDocument xmlDoc = new System.Xml.XmlDataDocument(CSVDtls);
XslCompiledTransform xslTran = new System.Xml.Xsl.XslCompiledTransform();

//Create XmlTextWriter for the FileSteam
//FileStream fs = new System.IO.FileStream("test.xls",FileMode.OpenOrCreate);
FileStream fs = new System.IO.FileStream(@"C:\EXPORT_Files\test.xls", FileMode.OpenOrCreate);

XmlTextWriter xtw = new System.Xml.XmlTextWriter(fs, System.Text.Encoding.Unicode);

//Add processing instructions to the beginning of the XML file,X
// one of which indicates a style sheet.
xtw.WriteProcessingInstruction("xml", "version='1.0'");
string strXSLFilename;
strXSLFilename = "test.xsl";
xtw.WriteProcessingInstruction("xml-stylesheet", "type='text/xls' href='" + strXSLFilename + "'");

//Write the XML from the dataset to the file
CSVDtls.WriteXml(xtw);
xtw.Close(); </pre>