export dataset to excel file
-
i want to export dataset at runtime to an excel file. i had tried but in vain. Pleaae help me with some link to work out. Thnks in advance.
-
i want to export dataset at runtime to an excel file. i had tried but in vain. Pleaae help me with some link to work out. Thnks in advance.
Hi Bhavna, The requirement is fissible via Gridview control or XmlDocument but I think your requirement is without gridview, We need to do the requirement as below
DataSet DS = somevalueDataSet();
XmlDataDocument xdd = new XmlDataDocument(DS);
XslTransform xt = new XslTransform();
string workingdir = AppDomain.CurrentDomain.BaseDirectory + "/" + "xslSheet.xsl";
xt.Load(workingdir);
string dirPath = AppDomain.CurrentDomain.BaseDirectory + "/" + "GeneratedFR";
string filePath = AppDomain.CurrentDomain.BaseDirectory + "/" + "GeneratedFR" + "/" + "Test1.xls";
if (!Directory.Exists(dirPath))
{
Directory.CreateDirectory(dirPath);
}
File.Delete(filePath);
FileStream fs = new FileStream(filePath, FileMode.Create);
using(fs)
{
xt.Transform(xdd,null,fs);
fs.Close();
}