POI导出excel,XSSFTextBox 内部文字怎么才能水平居中,看了文档也没发现有这个方法,只有个垂直居中的属性。
XSSFDrawing patriarch = sheet.createDrawingPatriarch();
XSSFClientAnchor anchor = new XSSFClientAnchor(0,20,500, 100, (short)1, 1,(short)(colFields.length+2), 3);
XSSFTextBox rec = patriarch.createTextbox(anchor);
rec.setShapeType(ShapeTypes.RECT);
XSSFRichTextString string = new XSSFRichTextString(titleStr);
XSSFFont font18Bold = getFont18Bold(workbook);// 18号粗体
string.applyFont(font18Bold);
rec.setText(string);
rec.setVerticalAlignment(VerticalAlignment.CENTER);//垂直居中
spire.xls.jar的设置方法可作参考
textBox1.setHAlignment(CommentHAlignType.Center);//水平居中
textBox1.setVAlignment(CommentVAlignType.Center);//垂直居中
为什么那个没有TextBox水平居中
HSSFCellStyle cellStyle = workbook.createCellStyle();
cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 居中
用单元格样式来做