// 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("Arial"); sheet.getRange("A1").getFont().setColor(Color.GetRed()); sheet.getRange("A1").getInterior().setColor(Color.GetGreen()); //specify font provider. Workbook.FontProvider = new IFontProvider() { @Override public List getFontFilePaths() { return new ArrayList<>(Arrays.asList( "fonts\\arial.ttf", "fonts\\arialbd.ttf", "fonts\\ariali.ttf" )); } @Override public InputStream getFont(String fontFilePath) { return getClass().getClassLoader().getResourceAsStream(fontFilePath); } }; //change the path to real export path when save. workbook.save("dest.pdf", SaveFileFormat.Pdf);
// Create a new workbook var workbook = Workbook() val sheet = workbook.worksheets[0] //set style. sheet.getRange("A1").value = "Sheet1" sheet.getRange("A1").font.name = "Arial" sheet.getRange("A1").font.color = Color.GetRed() sheet.getRange("A1").interior.color = Color.GetGreen() //specify font provider. Workbook.FontProvider = object : IFontProvider { override fun getFontFilePaths(): List { return ArrayList(mutableListOf( "fonts\\arial.ttf", "fonts\\arialbd.ttf", "fonts\\ariali.ttf" )) } override fun getFont(fontFilePath: String?): InputStream { return javaClass.getClassLoader().getResourceAsStream(fontFilePath) } } //change the path to real export path when save. workbook.save("dest.pdf", SaveFileFormat.Pdf)