手机网站app生成,网站设计一般会遇到哪些问题,wordpress底部修改视频教程,做代理去哪个网站找前些日子做了一个简单的winform程序#xff0c;需要导出的功能#xff0c;刚开始省事直接使用微软的组件#xff0c;但是导出之后发现效率极其低下#xff0c;绝对像web那样使用npoi组件#xff0c;因此简单的进行了整理#xff0c;包括直接根据DataTable导出excel及Data…前些日子做了一个简单的winform程序需要导出的功能刚开始省事直接使用微软的组件但是导出之后发现效率极其低下绝对像web那样使用npoi组件因此简单的进行了整理包括直接根据DataTable导出excel及DataGridview导出excel版本是1.2.4下面贴下主要代码两种方式1、NPOI导出excel、 2、普通的导出excel 下面贴下主要代码NPOI导出 /// summary/// DataTable导出到Excel文件/// /summary/// param namedtSource源DataTable/param/// param namestrHeaderText表头文本/param/// param namestrFileName保存位置/parampublic static void DataTableToExcel(DataTable dtSource, string strHeaderText, string strFileName){using (MemoryStream ms DataTableToExcel(dtSource, strHeaderText)){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 namedtSource源DataTable/param/// param namestrHeaderText表头文本/parampublic static MemoryStream DataTableToExcel(DataTable dtSource, string strHeaderText){HSSFWorkbook workbook new HSSFWorkbook();HSSFSheet sheet (HSSFSheet)workbook.CreateSheet();#region 右击文件 属性信息{DocumentSummaryInformation dsi PropertySetFactory.CreateDocumentSummaryInformation();dsi.Company NPOI;workbook.DocumentSummaryInformation dsi;SummaryInformation si PropertySetFactory.CreateSummaryInformation();si.Author 文件作者信息; //填加xls文件作者信息si.ApplicationName 创建程序信息; //填加xls文件创建程序信息si.LastAuthor 最后保存者信息; //填加xls文件最后保存者信息si.Comments 作者信息; //填加xls文件作者信息si.Title 标题信息; //填加xls文件标题信息si.Subject 主题信息;//填加文件主题信息si.CreateDateTime System.DateTime.Now;workbook.SummaryInformation si;}#endregionHSSFCellStyle dateStyle (HSSFCellStyle)workbook.CreateCellStyle();HSSFDataFormat format (HSSFDataFormat)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] intTemp;}}} int rowIndex 0; foreach (DataRow row in dtSource.Rows){#region 新建表填充表头填充列头样式if (rowIndex 65535 || rowIndex 0){if (rowIndex ! 0){sheet (HSSFSheet)workbook.CreateSheet();}#region 表头及样式{HSSFRow headerRow (HSSFRow)sheet.CreateRow(0);headerRow.HeightInPoints 25;headerRow.CreateCell(0).SetCellValue(strHeaderText);HSSFCellStyle headStyle (HSSFCellStyle)workbook.CreateCellStyle();// headStyle.Alignment CellHorizontalAlignment.CENTER;HSSFFont font (HSSFFont)workbook.CreateFont();font.FontHeightInPoints 20;font.Boldweight 700;headStyle.SetFont(font);headerRow.GetCell(0).CellStyle headStyle;// sheet.AddMergedRegion(new Region(0, 0, 0, dtSource.Columns.Count - 1));//headerRow.Dispose();}#endregion#region 列头及样式{HSSFRow headerRow (HSSFRow)sheet.CreateRow(1); HSSFCellStyle headStyle (HSSFCellStyle)workbook.CreateCellStyle();//headStyle.Alignment CellHorizontalAlignment.CENTER;HSSFFont font (HSSFFont)workbook.CreateFont();font.FontHeightInPoints 10;font.Boldweight 700;headStyle.SetFont(font); foreach (DataColumn column in dtSource.Columns){headerRow.CreateCell(column.Ordinal).SetCellValue(column.ColumnName);headerRow.GetCell(column.Ordinal).CellStyle headStyle;//设置列宽sheet.SetColumnWidth(column.Ordinal, (arrColWidth[column.Ordinal] 1) * 256); }// headerRow.Dispose();}#endregionrowIndex 2;}#endregion#region 填充内容HSSFRow dataRow (HSSFRow)sheet.CreateRow(rowIndex);foreach (DataColumn column in dtSource.Columns){HSSFCell newCell (HSSFCell) dataRow.CreateCell(column.Ordinal);string drValue row[column].ToString();switch (column.DataType.ToString()){case System.String://字符串类型newCell.SetCellValue(drValue);break;case System.DateTime://日期类型System.DateTime dateV;System.DateTime.TryParse(drValue, out dateV);newCell.SetCellValue(dateV);newCell.CellStyle dateStyle;//格式化显示break;case System.Boolean://布尔型bool boolV false;bool.TryParse(drValue, out boolV);newCell.SetCellValue(boolV);break;case System.Int16://整型case System.Int32:case System.Int64:case System.Byte:int intV 0;int.TryParse(drValue, out intV);newCell.SetCellValue(intV);break;case System.Decimal://浮点型case System.Double:double doubV 0;double.TryParse(drValue, out doubV);newCell.SetCellValue(doubV);break;case System.DBNull://空值处理newCell.SetCellValue();break;default:newCell.SetCellValue();break;}}#endregionrowIndex;} using (MemoryStream ms new MemoryStream()){workbook.Write(ms);ms.Flush();ms.Position 0;sheet.Dispose();//workbook.Dispose();//一般只用写这一个就OK了他会遍历并释放所有资源但当前版本有问题所以只释放sheetreturn ms;} } 普通excel导出 #region 导出excelpublic static void ExportExcel(string fileName, DataGridView myDGV,bool isShowDialog){string saveFileName ;if (isShowDialog){//bool fileSaved false;SaveFileDialog saveDialog new SaveFileDialog();saveDialog.DefaultExt xls;saveDialog.Filter Excel文件|*.xls;saveDialog.FileName fileName;saveDialog.ShowDialog();saveFileName saveDialog.FileName;if (saveFileName.IndexOf(:) 0) return; //被点了取消 }else{// saveFileName Application.StartupPath \导出记录\ fileName .xls;saveFileName fileName;}Microsoft.Office.Interop.Excel.Application xlApp new Microsoft.Office.Interop.Excel.Application();if (xlApp null){MessageBox.Show(无法创建Excel对象可能您的机子未安装Excel);return;}Microsoft.Office.Interop.Excel.Workbooks workbooks xlApp.Workbooks;Microsoft.Office.Interop.Excel.Workbook workbook workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);Microsoft.Office.Interop.Excel.Worksheet worksheet (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];//取得sheet1 //写入标题for (int i 0; i myDGV.ColumnCount; i){worksheet.Cells[1, i 1] myDGV.Columns[i].HeaderText;}//写入数值for (int r 0; r myDGV.Rows.Count; r){for (int i 0; i myDGV.ColumnCount; i){if (myDGV[i, r].ValueType typeof(string)|| myDGV[i, r].ValueType typeof(DateTime))//这里就是验证DataGridView单元格中的类型,如果是string或是DataTime类型,则在放入缓 存时在该内容前加入 ;{worksheet.Cells[r 2, i 1] myDGV.Rows[r].Cells[i].Value;}else{worksheet.Cells[r 2, i 1] myDGV.Rows[r].Cells[i].Value;}}System.Windows.Forms.Application.DoEvents();}worksheet.Columns.EntireColumn.AutoFit();//列宽自适应//if (Microsoft.Office.Interop.cmbxType.Text ! Notification)//{// Excel.Range rg worksheet.get_Range(worksheet.Cells[2, 2], worksheet.Cells[ds.Tables[0].Rows.Count 1, 2]);// rg.NumberFormat 00000000;//}if (saveFileName ! ){try{workbook.Saved true;workbook.SaveCopyAs(saveFileName);//fileSaved true;}catch (Exception ex){//fileSaved false;MessageBox.Show(导出文件时出错,文件可能正被打开\n ex.Message);}}//else//{// fileSaved false;//}xlApp.Quit();GC.Collect();//强行销毁 // if (fileSaved System.IO.File.Exists(saveFileName)) System.Diagnostics.Process.Start(saveFileName); //打开EXCELMessageBox.Show(fileName 保存成功, 提示, MessageBoxButtons.OK);}#endregion 5万条数据性能测试 下面附上源码里面有NPOI和普通导出excel的性能比较。 下载源码 如果您觉的文章不错请点击推荐转载于:https://www.cnblogs.com/amylis_chen/p/8462215.html
