//create a new workbook Workbook workbook = new Workbook(); IWorksheet sheet = workbook.getWorksheets().get(0); //set style. sheet.getRange("A1").setValue("Sheet1"); sheet.getRange("A1").getFont().setName("Wide Latin"); sheet.getRange("A1").getFont().setColor(Color.GetRed()); sheet.getRange("A1").getInterior().setColor(Color.GetGreen()); //specify font path. Workbook.FontsFolderPath = "/var/usr/public/Fonts"; ////get the used fonts list in workbook, the list are:"Wide Latin", "Calibri" List fonts = workbook.getUsedFonts(); //change the path to real export path when save. sheet.save("dest.pdf", SaveFileFormat.Pdf);
//create a new workbook var workbook = Workbook() val sheet = workbook.worksheets.get(0) //set style. sheet.getRange("A1").value = "Sheet1" sheet.getRange("A1").font.name = "Wide Latin" sheet.getRange("A1").font.color = Color.GetRed() sheet.getRange("A1").interior.color = Color.GetGreen() //specify font path. Workbook.FontsFolderPath = "/var/usr/public/Fonts" ////get the used fonts list in workbook, the list are:"Wide Latin", "Calibri" val fonts = workbook.usedFonts //change the path to real export path when save. sheet.save("dest.pdf", SaveFileFormat.Pdf)