// 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 an excel file workbook.save("SetShapeTextAlignment.xlsx");
// Create a new workbook var workbook = Workbook() // Open an excel file val fileStream = this.getResourceStream("xlsx/WebsiteFlowChart[Template].xlsx") workbook.open(fileStream) val worksheet = workbook.getWorksheets().get(0) for (shape in worksheet.getShapes()) { //Centers text vertically. shape.getTextFrame().setVerticalAnchor(VerticalAnchor.AnchorMiddle) //Centers text horizontally. shape.getTextFrame().setHorizontalAnchor(HorizontalAnchor.Center) } // Save to an excel file workbook.save("SetShapeTextAlignment.xlsx")