public void ToExcel(DataTable dt, string target)
{
//string target = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "Results.xls");
//open file
try
{
StreamWriter wr = new StreamWriter(target);
for (int i = 0; i < dt.Columns.Count; i++)
{
wr.Write(dt.Columns[i].ToString().ToUpper() + "\t");
}
wr.WriteLine();
//write rows to excel file
for (int i = 0; i < (dt.Rows.Count); i++)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
if (dt.Rows[i][j] != null)
{
wr.Write(Convert.ToString(dt.Rows[i][j]) + "\t");
}
else
{
wr.Write("\t");
}
}
//go to next line
wr.WriteLine();
}
//close file
wr.Close();
Mo.ExportNotificationManager(0);
}
catch
{
Mo.ExportNotificationManager(1);
}
}
