Export data into a excel file.

Posted by Rajendra Prasad Panchati on Friday, February 19, 2010

string outputFile1 = "C:\\abc.xls";

FileInfo outputFileInfo1 = new FileInfo(outputFile1);
FileStream outfs1 = null;
if(outputFileInfo1.Exists)
outfs1 = outputFileInfo1.Open(FileMode.Open);
else
outfs1 = outputFileInfo1.Open(FileMode.CreateNew);
TextWriter tw1 = new StreamWriter(outfs1);