Thank u
Can u plz help me in reading this file. I want to get the font at all the
indexes.
Test3.xlsx
<http://apache-poi.1045710.n5.nabble.com/file/n5714662/Test3.xlsx>
The example given by u is for set the cell type. I want to read from .xlsx
file.
A1 is having : img0 where "i" is bold, "m" is bold and underline, "g" is
bold and italic, "0" is bold and italic.
I am trying like this:
CellReference b1 = new CellReference("A1");
XSSFRow b1Row = sheet.getRow(b1.getRow());
XSSFCell b1Cell = b1Row.getCell(b1.getCol());
XSSFRichTextString value = b1Cell.getRichStringCellValue();
XSSFFont b1Font = value.getFontAtIndex(1); // return true
System.out.println(b1Font.getBold());
XSSFFont b1Font1 = value.getFontAtIndex(0);// throwing null pointer
exception Test3.xlsx
<http://apache-poi.1045710.n5.nabble.com/file/n5714662/Test3.xlsx>
System.out.println(b1Font1.getBold());
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Unable-to-read-the-fully-formatted-text-from-XSSF-tp5714625p5714662.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]
