- 博客(0)
- 资源 (2)
- 收藏
- 关注
导入excell2007
.net 把數據導入excell2007
ExportToExcel2007.clsCreateWorkbook xlPkg = new ExportToExcel2007.clsCreateWorkbook();
xlPkg.ColsNum = dt.Columns.Count;
ArrayList orderData = new ArrayList();
//Add the column headers to the array list
ArrayList Header = new ArrayList();
for (int j = 0; j < dt.Columns.Count; j++)
{
Header.Add(dt.Columns[j].Caption.ToString());
}
orderData.Add(Header);
//Loop the order details data and add the data
//to the array list
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
orderData.Add(dt.Rows[i]);
}
//Set the orderDetails property to the
//array list containing the order details data
xlPkg.orderDetails = orderData;
//Retrieve the contents of the temporary Excel
//workbook and read it into a byte array
System.IO.Stream myStream = xlPkg.CreateWorkbook();
Byte[] b = new byte[(int)myStream.Length];
myStream.Read(b, 0, (int)myStream.Length);
myStream.Close();
//Delete the temp workbook
System.IO.File.Delete(xlPkg.fullName);
//Stream the new workbook back to the client
Response.ContentType =
"application/vnd.openxmlformats-officedocument." +
"spreadsheetml.sheet";
Response.AddHeader("Content-Disposition",
"attachment;filename=" + GetCodeFromDateMilliSecond() + ".xlsx");
Response.BinaryWrite(b);
Response.End();
2011-10-20
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人