// Create a new workbook Workbook workbook = new Workbook(); // Prepare data IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.setName("Data"); worksheet.getRange("A1:C13").setValue(new Object[][]{ {null, "Blue Series", "Orange Series"}, {"Jan", 0, 59.1883603948205}, {"Feb", 44.6420211591501, 52.2280901938606}, {"Mar", 45.2174930051225, 49.8093056416248}, {"Apr", 62, 37.3065749226828}, {"May", 53, 34.4312192530766}, {"Jun", 31.8933622049831, 69.7834561753736}, {"Jul", 41.7930895085093, 63.9418103906982}, {"Aug", 73, 57.4049534494926}, {"Sep", 49.8773891668518, 33}, {"Oct", 50, 74}, {"Nov", 54.7658428630216, 22.9587876597096}, {"Dec", 32, 54}, }); // Create a chart sheet and add an area chart IWorksheet chartSheet = workbook.getWorksheets().add(SheetType.Chart); chartSheet.activate(); chartSheet.setName("Chart"); IShape shape = chartSheet.getShapes().addChart(ChartType.Area, 0, 0, 360, 230); shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:C13"), RowCol.Columns); shape.getChart().getChartTitle().setText("Area Chart"); // Set the chart sheet to fit selection chartSheet.getSheetView().setFitSelection(true); // Save to an excel file workbook.save("FitSelection.xlsx");
// Create a new workbook var workbook = Workbook() // Prepare data val worksheet = workbook.getWorksheets().get(0) worksheet.setName("Data") worksheet.getRange("A1:C13").setValue( arrayOf( arrayOf(null, "Blue Series", "Orange Series"), arrayOf("Jan", 0, 59.1883603948205), arrayOf("Feb", 44.6420211591501, 52.2280901938606), arrayOf("Mar", 45.2174930051225, 49.8093056416248), arrayOf("Apr", 62, 37.3065749226828), arrayOf("May", 53, 34.4312192530766), arrayOf("Jun", 31.8933622049831, 69.7834561753736), arrayOf("Jul", 41.7930895085093, 63.9418103906982), arrayOf("Aug", 73, 57.4049534494926), arrayOf("Sep", 49.8773891668518, 33), arrayOf("Oct", 50, 74), arrayOf("Nov", 54.7658428630216, 22.9587876597096), arrayOf("Dec", 32, 54) ) ) // Create a chart sheet and add an area chart val chartSheet = workbook.getWorksheets().add(SheetType.Chart) chartSheet.activate() chartSheet.setName("Chart") val shape = chartSheet.getShapes().addChart(ChartType.Area, 0.0, 0.0, 360.0, 230.0) shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:C13"), RowCol.Columns) shape.getChart().getChartTitle().setText("Area Chart") // Set the chart sheet to fit selection chartSheet.getSheetView().setFitSelection(true) // Save to an excel file workbook.save("FitSelection.xlsx")