// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getActiveSheet(); // Create a temp style IStyle style = workbook.getStyles().add("test"); // FromJson style.fromJson("{\"backColor\":\"#4472c4\",\"foreColor\":\"#ffffff\",\"hAlign\":3,\"vAlign\":0,\"font\":\"italic 11pt Calibri\",\"borderLeft\":{\"color\":\"Accent 2\",\"style\":5},\"borderTop\":{\"color\":\"Accent 2\",\"style\":5},\"borderRight\":{\"color\":\"Accent 2\",\"style\":5},\"borderBottom\":{\"color\":\"Accent 2\",\"style\":5},\"locked\":true,\"textIndent\":null,\"cellButtons\":[]}"); worksheet.getRange("D4").setValue("Document"); worksheet.getRange("D4").setStyle(style); // Save to an excel file workbook.save("NamedStyleFromJson.xlsx");