文件名称：导入excell2007
文件大小：16KB
文件格式：DLL
更新时间：2014-11-09 13:23:55
導入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();