// Create a new workbook Workbook workbook = new Workbook(); // Open an excel file InputStream fileStream = this.getResourceStream("xlsx/WebsiteFlowChart[Template].xlsx"); workbook.open(fileStream); IWorksheet worksheet = workbook.getWorksheets().get(0); for (IShape shape : worksheet.getShapes()) { //Centers text vertically. shape.getTextFrame().setVerticalAnchor(VerticalAnchor.AnchorMiddle); //Centers text horizontally. shape.getTextFrame().setHorizontalAnchor(HorizontalAnchor.Center); } // Save to a pdf file workbook.save("ShapeWithTextAlignment.pdf");