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);//垂直居中