NPOI Excel Style settings, npoiexcel Style

NPOI Excel Style settings, npoiexcel Style
1. Create an Excel file

// Create a workbook XSSFWorkbook workbook = new XSSFWorkbook (); // create a page ISheet sheet = workbook. createSheet ("sheet1"); // create an IRow row = sheet. createRow (0); // create an ICell cell = row column. createCell (0 );

 

2. Set the font

ICellStyle style = workbook. createCellStyle (); // create a style object IFont font = workbook. createFont (); // create a font style object. fontName = "正 "; // font corresponding to the font in the excel file. color = new HSSFColor. PINK (). getIndex (); // color reference NPOI color table (replace PINK () font. isItalic = true; // italic font. fontHeightInPoints = 16; // font size. boldweight = short. maxValue; // Bold style in the font. setFont (font); // assign the font style to the style object
Cell. CellStyle = style; // assign the style to the cell.

3. Set cell 1 and cell foreground color

ICellStyle style = workbook. CreateCellStyle (); style. FillForegroundColor = 14; // you can see the NPOI Color comparison table style. FillPattern = FillPatternType. SOLID_FOREGROUND;

2. cell width and height

Row Height: row. Height = 30*20; // The row Height is 30.

Column width: sheet. SetColumnWidth (3, 13*256) // The column width of the 4th column is 13

3. Merge Cells

After cells are merged, the style is subject to the cells in the upper left corner.

// The four parameters of CellRangeAddress are: Start row, end row, start column, and end column.

Sheet. AddMergedRegion (new CellRangeAddress (0, 0, 0, 10 ));

4. horizontal center

Style. Alignment = HorizontalAlignment. CENTER;

5. Set the formula

No need to write "="

Cell. CellFormula = "formula ";

6. Border

// Upper, lower, and left

StyleFont. BorderTop = NPOI. SS. UserModel. BorderStyle. THIN;
StyleFont. BorderBottom = NPOI. SS. UserModel. BorderStyle. THIN;
StyleFont. BorderLeft = NPOI. SS. UserModel. BorderStyle. THIN;
StyleFont. BorderRight = NPOI. SS. UserModel. BorderStyle. THICK;

 

Color Table:

Color	Test	Class Name	Short
	Test color	Black	8
	Test color	Brown	60
	Test color	Olive_Green	59
	Test color	Dark_Green	58
	Test color	Dark_Teal	56
	Test color	Dark_Blue	18
	Test color	Indigo	62
	Test color	Grey_80_PERCENT	63
	Test color	Dark_Red	16
	Test color	Orange	53
	Test color	DARK_YELLOW	19
	Test color	Green	17
	Test color	Teal	21
	Test color	Blue	12
	Test color	Blue_Grey	54
	Test color	Grey_50_PERCENT	23
	Test color	Red	10
	Test color	LIGHT_ORANGE	52
	Test color	LIME	50
	Test color	SEA_GREEN	57
	Test color	AQUA	49
	Test color	LIGHT_BLUE	48
	Test color	Viotlet	20
	Test color	GREY_40_PERCENT	55
	Test color	Pink	14
	Test color	Gold	51
	Test color	Yellow	13
	Test color	BRIGHT_GREEN	11
	Test color	TURQUOISE	15
	Test color	SKY_BLUE	40
	Test color	Plum	61
	Test color	GREY_25_PERCENT	22
	Test color	Rose	45
	Test color	Tan	47
	Test color	LIGHT_YELLOW	43
	Test color	LIGHT_GREEN	42
	Test color	LIGHT_TURQUOISE	41
	Test color	PALE_BLUE	44
	Test color	LAVENDER	46
	Test color	White	9
	Test color	CORNFLOWER_BLUE	24
	Test color	LEMON_CHIFFON	26
	Test color	MAROON	25
	Test color	ORCHID	28
	Test color	CORAL	29
	Test color	ROYAL_BLUE	30
	Test color	LIGHT_CORNFLOWER_BLUE	31
	Test color	AUTOMATIC	64