سلام دوست عزیز
یه نمونه کد برات میزارم امید وارم به کارت بیاد
btnExporttoExcel.Enabled = false;
DataTable dtReport = new DataTable();
dtReport = (DataTable)Session["tblFirstInve"];
DataTable tblExcel = new DataTable("tblExcel");
if (dtReport.Rows.Count>0)
{
tblExcel.Columns.Add(new DataColumn("سریال", typeof(string)));
tblExcel.Columns.Add(new DataColumn("مارک", typeof(string)));
tblExcel.Columns.Add(new DataColumn("شرح کالا", typeof(string)));
tblExcel.Columns.Add(new DataColumn("تعداد", typeof(string)));
tblExcel.Columns.Add(new DataColumn("ارزش قطعه", typeof(string)));
}
foreach (DataRow item in dtReport.Rows)
{
DataRow Row = tblExcel.NewRow();
Row["سریال"] = ConvertSafe.ToString(item.Field<string>("PartNumbe r"));
Row["مارک"] = ConvertSafe.ToString(item.Field<string>("Mark"));
Row["شرح کالا"] = ConvertSafe.ToString(item.Field<string>("PartFarsi Des"));
Row["تعداد"] = ConvertSafe.ToString(item.Field<string>("QTY"));
Row["ارزش قطعه"] = ConvertSafe.ToString(item.Field<string>("Price"));
tblExcel.Rows.Add(Row);
}
ColumnMetadata[] columnMetadatas = new ColumnMetadata[]
{
new ColumnMetadata(false),
new ColumnMetadata(false),
new ColumnMetadata(false),
new ColumnMetadata(false),
new ColumnMetadata(false),
};
DataTableMetadata dataTableMetadata = new DataTableMetadata(columnMetadatas, 300);
CultureInfo currentCulture = System.Threading.Thread.CurrentThread.CurrentCultu re;
System.Threading.Thread.CurrentThread.CurrentCultu re = new CultureInfo("en-US");
try
{
Response.Clear();
Response.Buffer = false;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment;filename=FirstInv.xls");
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.Charset = "";
SmartXlsWrapper.WriteExcel(Response.OutputStream, tblExcel, dataTableMetadata);
Response.Close();
btnExporttoExcel.Enabled = true;
}
catch (Exception ex) { }
finally
{
System.Threading.Thread.CurrentThread.CurrentCultu re = currentCulture;
btnExporttoExcel.Enabled = true;
}