// Create a new workbook Workbook workbook = new Workbook(); IWorksheet sheet1 = workbook.getWorksheets().get(0); sheet1.setName("VALUETOTEXT"); Object[][] data = new Object[][]{ {"Movie", "Year", "Rank", "Sales"}, {"Fargo", 1996.0, 5.0, 61.0}, {"L.A. Confidential", 1997.0, 4.0, 126.0}, {"The Sixth Sense", 1999.0, 1.0, 673.0}, {"Toy Story", 1995.0, 2.0, 362.0}, {"Unforgiven", 1992.0, 3.0, 159.0} }; sheet1.getRange("B3:E8").setValue(data); ITable sheet1Table = sheet1.getTables().add(sheet1.getRange("B3:E8"), true); sheet1Table.convertToRange(); sheet1.getRange("G2:O2").merge(); sheet1.getRange("G2").setValue("Formula(format=0, Default concise format, returned text will be presented in Excel universal format.)"); sheet1.getRange("G4").setValue("Results"); sheet1.getRange("G12:S12").merge(); sheet1.getRange("G12").setValue("Formula(format = 1, Strict format with escape characters. When the source data is of text type, the returned string will be enclosed in quotation marks.)"); sheet1.getRange("G14").setValue("Results"); sheet1.getRange("G2, G4, G12, G14").getFont().setBold(true); sheet1.getRange("G5").setFormula2("=VALUETOTEXT(B3:E8)"); sheet1.getRange("G3").setFormula("=FORMULATEXT(G5)"); sheet1.getRange("G15").setFormula2("=VALUETOTEXT(B3:E8,1)"); sheet1.getRange("G13").setFormula("=FORMULATEXT(G15)"); sheet1.getColumns().get(1).autoFit(); sheet1.getColumns().get(6).autoFit(); sheet1.getColumns().get(11).autoFit(); workbook.calculate(); // Save to an excel file workbook.save("ValueToTextFunction.xlsx");