hssfrow 单元格样式_poi导出excel单元格中画斜线_AnyReport报表

下面是输出excel斜线完整的示例代码，使用的poi类库为：poi-3.8.jar

import java.awt.Color;

import java.io.FileOutputStream;

import org.apache.poi.hssf.usermodel.EscherGraphics;

import org.apache.poi.hssf.usermodel.EscherGraphics2d;

import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.hssf.usermodel.HSSFCellStyle;

import org.apache.poi.hssf.usermodel.HSSFClientAnchor;

import org.apache.poi.hssf.usermodel.HSSFPalette;

import org.apache.poi.hssf.usermodel.HSSFPatriarch;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFShapeGroup;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class TestExcel {

public static final int PERCENT_WIDTH = 50;

public static final int PERCENT_HEIGHT = 20;

public static final float PXTOPT = 0.75f;

public static void main(String[] args) throws Exception {

FileOutputStream fos = new FileOutputStream("D:/line.xls");

HSSFWorkbook wb = new HSSFWorkbook();

HSSFSheet sheet = wb.createSheet("line");

HSSFRow row = sheet.createRow(0);

row.setHeightInPoints(77 * PXTOPT);

final String text = " AB\n\n\n CD";

HSSFCell cell = row.createCell(0);

HSSFCellStyle cellStyle = getCellFormat(wb);

int x1 = 61, y1 = 77;

int x2 = 132, y2 = 76;

int x3 = 144, y3 = 31;

int[] xys = { x1, y1, x2, y2, x3, y3 };

drawLine(sheet, row, 0, 0, 144, 77, xys);

cell.setCellValue(text);

cellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_TOP);

cell.setCellStyle(cellStyle);

cell = row.createCell(1);

cell.setCellStyle(cellStyle);

cell = row.createCell(2);

cell.setCellStyle(cellStyle);

cell = row.createCell(3);

cell.setCellStyle(cellStyle);

row = sheet.createRow(1);

row.setHeightInPoints(83 * PXTOPT);

cell = row.createCell(0);

cell.setCellStyle(cellStyle);

cell = row.createCell(1);

cell.setCellStyle(cellStyle);

cell = row.createCell(2);

cell.setCellStyle(cellStyle);

cell = row.createCell(3);

cell.setCellStyle(cellStyle);

int[] xys1 = { 112, 83 };

drawLine(sheet, row, 1, 3, 110, 83, xys1);

wb.write(fos);

}

// draw cell line

private static void drawLine(HSSFSheet sheet, HSSFRow row, int i, int j, int width, int height,

int[] xys) {

int cellWidth = (int) (PERCENT_WIDTH * PXTOPT * width);

short cellHeight = (short) (PERCENT_HEIGHT * PXTOPT * height);

sheet.setColumnWidth(j, cellWidth);

row.setHeight(cellHeight);

HSSFPatriarch patriarch = sheet.createDrawingPatriarch();

HSSFClientAnchor a = new HSSFClientAnchor(0, 0, 1023, 255, (short) j, i, (short) (j), i);

HSSFShapeGroup group = patriarch.createGroup(a);

float verticalPointsPerPixel = a.getAnchorHeightInPoints(sheet);

EscherGraphics g = new EscherGraphics(group, sheet.getWorkbook(), Color.black,

verticalPointsPerPixel);

EscherGraphics2d g2d = new EscherGraphics2d(g);

for (int l = 0; l < xys.length; l += 2) {

int x = (int) ((PERCENT_WIDTH * 0.75 * xys[l] / cellWidth) * 1023);

int y = (int) ((PERCENT_HEIGHT * 0.75 * xys[l + 1] / cellHeight) * 255);

g2d.drawLine(0, 0, x, y);

}

}

public static HSSFCellStyle getCellFormat(HSSFWorkbook wb) {

HSSFCellStyle cellStyle = wb.createCellStyle();

if (cellStyle.getBorderBottom() != HSSFCellStyle.BORDER_THIN) {

cellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);

}

if (cellStyle.getBorderLeft() != HSSFCellStyle.BORDER_THIN) {

cellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);

}

if (cellStyle.getBorderTop() != HSSFCellStyle.BORDER_THIN) {

cellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);

}

if (cellStyle.getBorderRight() != HSSFCellStyle.BORDER_THIN) {

cellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);

}

cellStyle.setBottomBorderColor(createPette(wb));

cellStyle.setLeftBorderColor(createPette(wb));

cellStyle.setRightBorderColor(createPette(wb));

cellStyle.setTopBorderColor(createPette(wb));

return cellStyle;

}

public static short createPette(HSSFWorkbook wb) {

short petteIndex = 0;

Color rgb = new Color(0x00, 0x00, 0x00);

HSSFPalette palette = wb.getCustomPalette();

palette.setColorAtIndex(petteIndex, (byte) rgb.getRed(), (byte) rgb.getGreen(), (byte) rgb

.getBlue());

return petteIndex;

}

}