ASP.NET DataTable To Excel
- Get link
- Other Apps
EXPORT DATA FROM DATATABLE TO EXCEL IN ASP.NET
|
VB - Code
Public Sub ExportExcel(ByVal Datadt As DataTable)
Dim dt as new datatable
dt = Datadt
Dim attachment As String = "attachment; filename=" & System.DateTime.Now.[Date].ToShortDateString() & "_SalesReport.xls"
Response.ClearContent()
Response.AddHeader("content-disposition", attachment)
Response.ContentType = "application/vnd.ms-excel"
Dim tab As String = ""
For Each dc As DataColumn In dt.Columns
Response.Write(tab + dc.ColumnName)
tab = vbTab
Next
Response.Write(vbLf)
Dim i As Integer
For Each dr As DataRow In dt.Rows
tab = ""
For i = 0 To dt.Columns.Count - 1
Response.Write(tab & dr(i).ToString())
tab = vbTab
Next
Response.Write(vbLf)
Next
Response.[End]()
End Sub
public void ExportExcel(DataTable Datadt)
{
DataTable dt = new DataTable();
dt = Datadt;
string attachment = "attachment; filename="+System.DateTime.Now.Date.ToShortDateString()+"_SalesReport.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/vnd.ms-excel";
string tab = "";
foreach (DataColumn dc in dt.Columns)
{
Response.Write(tab + dc.ColumnName);
tab = "\t";
}
Response.Write("\n");
int i;
foreach (DataRow dr in dt.Rows)
{
tab = "";
for (i = 0; i < dt.Columns.Count; i++)
{
Response.Write(tab + dr[i].ToString());
tab = "\t";
}
Response.Write("\n");
}
Response.End();
}
|
- Get link
- Other Apps
Great job for publishing such a nice article. Your article isn’t only useful but it is additionally really informative. Read more info about Philippines Import Customs Data. Thank you because you have been willing to share information with us.
ReplyDelete