NPOI
liangyaomu
这个作者很懒,什么都没留下…
展开
-
NPOI EXCEL创建
HSSFWorkbook hssfworkbook = new HSSFWorkbook(); ISheet sheet = hssfworkbook.CreateSheet("Sheet1"); hssfworkbook.CreateSheet("Sheet2"); hssfworkbook.CreateSheet("Sheet3"); //Title IRow row = sh原创 2016-09-09 17:32:53 · 218 阅读 · 0 评论 -
NPOI 创建EXPCE 合并
using NPOI.SS.UserModel; using NPOI.HSSF.UserModel; HSSFWorkbook hssfworkbook = new HSSFWorkbook(); ISheet sheet = hssfworkbook.CreateSheet("Sheet1"); hssfworkbook.CreateSheet("Sheet2"); hssf原创 2016-09-09 17:26:21 · 499 阅读 · 0 评论 -
NPOI单元格样式
ICellStyle style4 = workbook.CreateCellStyle();style4.BorderRight = BorderStyle.Thin;style4.BorderLeft = BorderStyle.Thin;style4.BorderTop = BorderStyle.Thin;style4.BorderBottom = BorderStyle.Thin;原创 2016-12-02 08:42:02 · 1098 阅读 · 0 评论 -
NPOI 单元格套用公式
HSSFWorkbook hssfworkbook = new HSSFWorkbook(); ISheet sheet = hssfworkbook.CreateSheet("Sheet1"); hssfworkbook.CreateSheet("Sheet2"); hssfworkbook.CreateSheet("Sheet3"); //Title IRow row = sh原创 2016-09-09 17:38:47 · 5905 阅读 · 0 评论 -
NPOI设置格式文本、小数、百分比、货币、日期、科学计数法和中文大写
HSSFWorkbook demoWorkBook = new HSSFWorkbook(); HSSFSheet demoSheet = demoWorkBook.createSheet("The World's 500 Enterprises"); HSSFCell cell = demoSheet.createRow(0).creat原创 2016-10-20 14:00:24 · 9122 阅读 · 1 评论 -
NPOI 日期类型读取
if (HSSFDateUtil.IsCellDateFormatted(cell))//日期类型 { dataRow[i] = cell.DateCellValue; }原创 2017-03-30 18:06:25 · 9302 阅读 · 1 评论 -
从EXCEL模板中插入新行
using NPOI.SS.UserModel;using NPOI.HSSF.UserModel;public void Export(){HSSFWorkbook workbook;string modelExlPath = Server.MapPath("../") + "\\" + Text.xls; //读入模板 using (Fil原创 2016-10-14 10:42:10 · 1472 阅读 · 0 评论 -
NPOI 字体
//font style1: underlined, italic, red color, fontsize=20 Font font1 = hssfworkbook.CreateFont(); font1.Color = HSSFColor.RED.index; font1.IsItalic = true;原创 2016-12-01 19:14:30 · 1751 阅读 · 0 评论 -
NPOI选择框
ICellStyle style1 = workbook.CreateCellStyle(); style1.BorderRight = NPOI.SS.UserModel.BorderStyle.Thin; style1.BorderLeft = NPOI.SS.UserModel.BorderStyle.Thin; styl原创 2016-11-04 16:25:05 · 1742 阅读 · 0 评论 -
单元格高度宽度几种设置
//高度设置sheet1.CreateRow(0).Height = 200*20;//高度200//列宽设置1 int columnWidth = paymentSheet.GetColumnWidth(columnindx) / 256; ICell currentCell = currentRow.GetCell(columnindx); int length = Encoding.De原创 2016-10-28 08:40:03 · 2442 阅读 · 1 评论 -
NPOI EXCEL读取
void ConvertToDataTable() { Sheet sheet = hssfworkbook.GetSheetAt(0); System.Collections.IEnumerator rows = sheet.GetRowEnumerator(); DataTable dt = new DataTa...原创 2018-03-02 17:35:31 · 350 阅读 · 0 评论