// 創(chuàng)建excel工作簿
        SXSSFWorkbook wb = new SXSSFWorkbook(getXSSFWorkbook(examPath), 1000);
        //獲取樣式
        CellStyle style = wb.createCellStyle();

 
                //1、先設(shè)置單元格對(duì)齊方式
                //水平對(duì)齊，一般對(duì)齊方式。文本數(shù)據(jù)左對(duì)齊。數(shù)字、日期和時(shí)間是正確對(duì)齊的。布爾類(lèi)型居中。
                style.setAlignment(HorizontalAlignment.GENERAL);
                //靠左
                style.setAlignment(HorizontalAlignment.LEFT);
//                靠右
                style.setAlignment(HorizontalAlignment.RIGHT);
//                居中
                style.setAlignment(HorizontalAlignment.CENTER);
//               填充單元格的值,跨越單元格的整個(gè)寬度
                style.setAlignment(HorizontalAlignment.FILL);
//                水平對(duì)齊對(duì)齊(左右齊平)。對(duì)于每行文本，將單元格中換行文本的每行左右對(duì)齊
                style.setAlignment(HorizontalAlignment.JUSTIFY);
//                水平對(duì)齊在多個(gè)單元格中居中
                style.setAlignment(HorizontalAlignment.CENTER_SELECTION);
                //平鋪。表示單元格中每行文本中的text均勻分布.跨越單元格的寬度，左右外邊距齊平。
                style.setAlignment(HorizontalAlignment.DISTRIBUTED);

//2.此枚舉值指示單元格的垂直對(duì)齊類(lèi)型，即:
                //垂直居中對(duì)齊
                style.setVerticalAlignment(VerticalAlignment.CENTER);
                //頂部對(duì)齊
                style.setVerticalAlignment(VerticalAlignment.TOP);
                //底部對(duì)齊
                style.setVerticalAlignment(VerticalAlignment.BOTTOM);
                //對(duì)齊。
                style.setVerticalAlignment(VerticalAlignment.JUSTIFY);
                //分布。
                style.setVerticalAlignment(VerticalAlignment.DISTRIBUTED);
 

 
         //3.設(shè)置背景色
         style.setFillForegroundColor(IndexedColors.PALE_BLUE.getIndex());
          //必須設(shè)置 否則背景色不生效
         style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

 //4.設(shè)置字體樣式
                Font titleFont = wb.createFont();
//                設(shè)置字體的名稱(chēng)(例如Arial)
                titleFont.setFontName("宋體");
//                以1/20點(diǎn)為單位設(shè)置字體高度。
                titleFont.setFontHeight((short) 10);
//                設(shè)置是否使用斜體
                titleFont.setItalic(true);
//                設(shè)置是否在文本中使用刪除線(xiàn)橫線(xiàn)
                titleFont.setStrikeout(true);
                //顏色設(shè)置
                titleFont.setColor((short) 111);
//                設(shè)置普通、上標(biāo)或下標(biāo)。
                titleFont.setTypeOffset((short) 5);
                //下劃線(xiàn)
                titleFont.setUnderline((byte) 0000);
//                是否加粗
                titleFont.setBold(true);
//                設(shè)置字體高度
                titleFont.setFontHeightInPoints((short) 12);
                style.setFont(titleFont);

//5.邊框設(shè)置
                style.setBorderBottom(BorderStyle.THIN);
                style.setBorderLeft(BorderStyle.THIN);
                style.setBorderTop(BorderStyle.THIN);
                style.setBorderRight(BorderStyle.THIN);

 // 6.合并單元格
 SXSSFSheet sheet = wb.createSheet("測(cè)試sheet");
 sheet.addMergedRegion(new CellRangeAddress(X, Y, a, b));
//設(shè)置單元格寬度 ，X代表第幾列
 sheet.setColumnWidth(X, 20 * 260);

public CellRangeAddress(int firstRow, int lastRow, int firstCol, int lastCol) {
		super(firstRow, lastRow, firstCol, lastCol);
		
		if (lastRow < firstRow || lastCol < firstCol) {
			throw new IllegalArgumentException("Invalid cell range, having lastRow < firstRow || lastCol < firstCol, " +
					"had rows " + lastRow + " >= " + firstRow + " or cells " + lastCol + " >= " + firstCol);
		}
	}