这篇文章主要介绍了asp.net导出excel的简单方法实例,需要的朋友可以参考下
excel的操作，最常用的就是导出和导入，废话不多说上代码。 本例使用NPOI实现的，不喜勿喷哈。。。。 代码如下:/// <summary> /// 导出Excel /// </summary> /// <param name="stime"></param> /// <param name="etime"></param> /// <returns></returns> public ActionResult Export(FormCollection frm) { DataTable dts = new DataTable(); dts = _shopMemeber.ExportMemberData(frm); IWorkbook workbook = new XSSFWorkbook(); ISheet sheet = workbook.CreateSheet(); IRow headerRow = sheet.CreateRow(0); foreach (DataColumn column in dts.Columns) headerRow.CreateCell(column.Ordinal).SetCellValue(column.Caption); int rowIndex = 1; foreach (DataRow row in dts.Rows) { IRow dataRow = sheet.CreateRow(rowIndex); foreach (DataColumn column in dts.Columns) { dataRow.CreateCell(column.Ordinal).SetCellValue(row[column].ToString()); } rowIndex++; } string filepath = Server.MapPath("/") + @"用户列表.xlsx"; FileStream file = new FileStream(filepath, FileMode.Create); workbook.Write(file); ExcelHelper.DownLoad(@"/用户列表.xlsx"); #region 不启用 #endregion return SuccessMsg("AdminMemberMemberIndex"); }//这个是下载到桌面的方法，没实现自选路径public static void DownLoad(string FileName) { FileInfo fileInfo = new FileInfo(HttpContext.Current.Server.MapPath(FileName)); //以字符流的形式下载文件 FileStream fs = new FileStream(HttpContext.Current.Server.MapPath(FileName), FileMode.Open); byte[] bytes = new byte[(int)fs.Length]; fs.Read(bytes, 0, bytes.Length); fs.Close(); HttpContext.Current.Response.ContentType = "application/octet-stream"; //通知新闻热点
疑难解答
