string filename = "";
//----------------- File Name ----------
string Day = DateTime.Now.Day.ToString();
string Month = DateTime.Now.ToString("MMM");
string Year = DateTime.Now.Year.ToString();
string Hour = DateTime.Now.Hour.ToString();
string Minute = DateTime.Now.Minute.ToString();
string Second = DateTime.Now.Second.ToString();
string strName = Day + "_" + Month + "_" + Year + "__" + Hour + "_" + Minute + "_" + Second + ".xls";
filename = Server.MapPath("~/XLSFiles/" + strName);
Session["AttachedFileName"] = filename;
//--------------------------------------
try
{
string sTableStart = @"<HTML><BODY><TABLE Border=1>";
string sTableEnd = @"</TABLE></BODY></HTML>";
StringBuilder sTableData = new StringBuilder();
//----XLS Column Headings---------
string sTHead = "<TR>";
sTHead += @"<TH>S.No</TH>";
sTHead += @"<TH>Name</TH>";
sTHead += @"<TH>DOB</TH>";
sTHead += @"<TH>App.Date</TH>";
sTHead += @"<TH>Type</TH>";
sTHead += @"<TH>Status</TH>";
sTHead += @"</TR>";
//------------- XLS Row asign ---------
int SNOCounter = 1;
string[] outerArray = hiddenIGAppointmentValuePair.Value.Split(':');
for (int j = 0; j < gridAppointments.Rows.Count; j++)
{
string[] innerArray = outerArray[j].Split(';');
if (innerArray[1].ToString() == "1")
{
sTableData.Append(@"<TR>");
sTableData.Append(@"<TD>" + SNOCounter.ToString() + @"</TD>"); // SNo
sTableData.Append(@"<TD>" + gridAppointments.Rows[j].Items[3].Text + @"</TD>"); // Name
sTableData.Append(@"<TD>" + gridAppointments.Rows[j].Items[4].Text + @"</TD>"); // DOB
sTableData.Append(@"<TD>" + gridAppointments.Rows[j].Items[5].Text + @"</TD>"); // AppDate
sTableData.Append(@"<TD>" + gridAppointments.Rows[j].Items[6].Text + @"</TD>"); // Type
sTableData.Append(@"<TD>" + gridAppointments.Rows[j].Items[7].Text + @"</TD>"); // Status
sTableData.Append(@"</TR>");
SNOCounter += 1;
}
}
//-------------------------------------
string sTable = sTableStart + sTHead + sTableData.ToString() + sTableEnd;
System.IO.StreamWriter oExcelWriter = System.IO.File.CreateText(filename);
oExcelWriter.WriteLine(sTable);
oExcelWriter.Close();
}
catch
{
}
//----------------- File Name ----------
string Day = DateTime.Now.Day.ToString();
string Month = DateTime.Now.ToString("MMM");
string Year = DateTime.Now.Year.ToString();
string Hour = DateTime.Now.Hour.ToString();
string Minute = DateTime.Now.Minute.ToString();
string Second = DateTime.Now.Second.ToString();
string strName = Day + "_" + Month + "_" + Year + "__" + Hour + "_" + Minute + "_" + Second + ".xls";
filename = Server.MapPath("~/XLSFiles/" + strName);
Session["AttachedFileName"] = filename;
//--------------------------------------
try
{
string sTableStart = @"<HTML><BODY><TABLE Border=1>";
string sTableEnd = @"</TABLE></BODY></HTML>";
StringBuilder sTableData = new StringBuilder();
//----XLS Column Headings---------
string sTHead = "<TR>";
sTHead += @"<TH>S.No</TH>";
sTHead += @"<TH>Name</TH>";
sTHead += @"<TH>DOB</TH>";
sTHead += @"<TH>App.Date</TH>";
sTHead += @"<TH>Type</TH>";
sTHead += @"<TH>Status</TH>";
sTHead += @"</TR>";
//------------- XLS Row asign ---------
int SNOCounter = 1;
string[] outerArray = hiddenIGAppointmentValuePair.Value.Split(':');
for (int j = 0; j < gridAppointments.Rows.Count; j++)
{
string[] innerArray = outerArray[j].Split(';');
if (innerArray[1].ToString() == "1")
{
sTableData.Append(@"<TR>");
sTableData.Append(@"<TD>" + SNOCounter.ToString() + @"</TD>"); // SNo
sTableData.Append(@"<TD>" + gridAppointments.Rows[j].Items[3].Text + @"</TD>"); // Name
sTableData.Append(@"<TD>" + gridAppointments.Rows[j].Items[4].Text + @"</TD>"); // DOB
sTableData.Append(@"<TD>" + gridAppointments.Rows[j].Items[5].Text + @"</TD>"); // AppDate
sTableData.Append(@"<TD>" + gridAppointments.Rows[j].Items[6].Text + @"</TD>"); // Type
sTableData.Append(@"<TD>" + gridAppointments.Rows[j].Items[7].Text + @"</TD>"); // Status
sTableData.Append(@"</TR>");
SNOCounter += 1;
}
}
//-------------------------------------
string sTable = sTableStart + sTHead + sTableData.ToString() + sTableEnd;
System.IO.StreamWriter oExcelWriter = System.IO.File.CreateText(filename);
oExcelWriter.WriteLine(sTable);
oExcelWriter.Close();
}
catch
{
}
No comments:
Post a Comment