Hi I have tried the same example given by u. I was using POI 3.8 before. I changed my jar from 3.8 to 3.9. Still same issue.
Please help me...its urgent Attached my .xlsx file also. Test6.xlsx <http://apache-poi.1045710.n5.nabble.com/file/n5714654/Test6.xlsx> try { File fis = new File(filePathName); InputStream in = new FileInputStream(fis); XSSFWorkbook workbook = new XSSFWorkbook(in); XSSFSheet sheet = workbook.getSheetAt(0); XSSFRow row = sheet.getRow(0); XSSFCell cell = row.getCell(0); XSSFRichTextString value = cell.getRichStringCellValue(); // value is not null //Hello World is bold and italic System.out.println(value.getString()); // Hello, World! System.out.println(value.getString().charAt(0)); // H System.out.println(value.getFontAtIndex(0).getBold()); // throwing null pointer exception } -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Unable-to-read-the-fully-formatted-text-from-XSSF-tp5714625p5714654.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
