// Create a new workbook Workbook workbook = new Workbook(); // Open an excel file InputStream fileStream = this.getResourceStream("xlsx/Manufacturing output chart.xlsx"); workbook.open(fileStream); IWorksheet worksheet = workbook.getWorksheets().get(0); IShape shape = worksheet.getShapes().get(0); IAxis category_axis = shape.getChart().getAxes().item(AxisType.Category); //config tick label's angle category_axis.getTickLabels().setOrientation(-45); // Save to an excel file workbook.save("ConfigTickMarkLabelAngle.xlsx");
// Create a new workbook var workbook = Workbook() // Open an excel file val fileStream = this.getResourceStream("xlsx/Manufacturing output chart.xlsx") workbook.open(fileStream!!) val worksheet = workbook.worksheets.get(0) val shape = worksheet.shapes[0] val category_axis = shape.chart.axes.item(AxisType.Category) //config tick label's angle category_axis.tickLabels.orientation = -45 // Save to an excel file workbook.save("ConfigTickMarkLabelAngle.xlsx")