//create a new workbook Workbook workbook = new Workbook(); Workbook workbookWithShape = new Workbook(); IWorksheet worksheet = workbookWithShape.getWorksheets().get(0); // Add a shape in worksheet IShape shape = worksheet.getShapes().addShape(AutoShapeType.Parallelogram, 1, 1, 200, 100); shape.getLine().setDashStyle(LineDashStyle.Dash); shape.getLine().setStyle(LineStyle.Single); shape.getLine().setWeight(2); shape.getLine().getColor().setObjectThemeColor(ThemeColor.Accent6); shape.getLine().setTransparency(0.3); // jsongString contains shapes String jsonString = workbookWithShape.toJson(); // GcExcel can load json strig contains shapes now workbook.fromJson(jsonString); //save to an excel file workbook.save("LoadAndSaveJsonWithShapes.xlsx");
//create a new workbook var workbook = Workbook() val workbookWithShape = Workbook() val worksheet = workbookWithShape.worksheets.get(0) // Add a shape in worksheet val shape = worksheet.shapes.addShape(AutoShapeType.Parallelogram, 1.0, 1.0, 200.0, 100.0) shape.line.dashStyle = LineDashStyle.Dash shape.line.style = LineStyle.Single shape.line.weight = 2.0 shape.line.color.objectThemeColor = ThemeColor.Accent6 shape.line.transparency = 0.3 // jsongString contains shapes val jsonString = workbookWithShape.toJson() // GcExcel can load json strig contains shapes now workbook.fromJson(jsonString) //save to an excel file workbook.save("LoadAndSaveJsonWithShapes.xlsx")