java xssfdataformat_用Java格式文本创建Excel

当我下载Excel时,我会得到带有格式号的单元格,我需要在所有单元格中设置文本格式。

try {

XSSFSheet sheet = workbook.createSheet(eyelash);

XSSFFont font = workbook.createFont();

font.setColor(HSSFColor.WHITE.index);

XSSFCellStyle style = workbook.createCellStyle();

style.setFont(font);

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

style.setFillForegroundColor(HSSFColor.RED.index);

String[] header = { "name","surname"};

XSSFRow rowhead = sheet.createRow((short) 0);

XSSFCell cell;

int cellnum = 0;

for (int i = 0; i < header.length; i++) {

cell = rowhead.createCell(cellnum);

cell.setCellValue(header[i]);

cell.setCellStyle(style);

cell.setCellType(XSSFCell.CELL_TYPE_STRING);

cellnum++;

}

if (data) {

int myRowDa