文档详情

MVC3 导出Excel.docx

发布:2017-12-18约9.01千字共11页下载文档
文本预览下载声明
MVC3 导出Excel 所用环境信息:VS2010 MVC3 LINQNPOIHelper 帮助类public class NPOIHelper{/// summary/// DataTable导出到Excel文件/// /summary/// param name=dtSource源DataTable/param/// param name=strHeaderText表头文本/param/// param name=strFileName保存位置/parampublic static void Export(DataTable dtSource, string strHeaderText, string strFileName, string[] columnNames){using (MemoryStream ms = Export(dtSource, strHeaderText, columnNames)){using (FileStream fs = new FileStream(strFileName, FileMode.Create, FileAccess.Write)){byte[] data = ms.ToArray();fs.Write(data, 0, data.Length);fs.Flush();}}}/// summary/// DataTable导出到Excel的MemoryStream/// /summary/// param name=dtSource源DataTable/param/// param name=strHeaderText表头文本/param/// param name=columnNames列名/parampublic static MemoryStream Export(DataTable dtSource, string strHeaderText, string[] columnNames){if (columnNames != null columnNames.Length != dtSource.Columns.Count){throw new ArgumentException(参数不正确:columnNames,数组元素的个数需要和数据源列的数量相同!);}HSSFWorkbook workbook = new HSSFWorkbook();Sheet sheet = workbook.CreateSheet();#region 右击文件 属性信息{DocumentSummaryInformation dsi = PropertySetFactory.CreateDocumentSummaryInformation();dsi.Company = 上海驰亚防伪科技有限公司;workbook.DocumentSummaryInformation = dsi;SummaryInformation si = PropertySetFactory.CreateSummaryInformation();si.Author = 技术部;si.Title = strHeaderText;si.CreateDateTime = DateTime.Now;workbook.SummaryInformation = si;}#endregionCellStyle dateStyle = workbook.CreateCellStyle();DataFormat format = workbook.CreateDataFormat();dateStyle.DataFormat = format.GetFormat(yyyy-mm-dd);//取得列宽int[] arrColWidth = new int[dtSource.Columns.Count];foreach (DataColumn item in dtSource.Columns){arrColWidth[item.Ordinal] = Encoding.GetEncoding(936).GetBytes(item.ColumnName.ToString()).Length;}for (int i = 0; i dtSource.Rows.Count; i++){for (int j = 0; j dtSource.Columns.Count; j++){int intTemp = Encoding.GetEncoding(936).GetBytes(dtSource.Rows[i][j].ToString()).Length;if (intTemp arrColWidth[j]){arrColWidth[j] =
显示全部
相似文档