Hi, It seems the POI interface does not provide this currently, can you create two very simple files that are very similar, only one without this and one with this formatting and then compare the XML-files inside the .XLSX? .xlsx-files are just ZIPs, so you can unpack them and compare the files in there.
When you know which data needs to be set, it is usually possible to use a lower level API to set these flags in POI until a full API becomes available. Thanks... Dominik. On Thu, Jul 23, 2015 at 1:14 PM, <[email protected]> wrote: > Hi list, > > I know how to get the bottom, top, left and right: > CellStyle style = cell.getCellStyle(); > CellReference cellRef = new CellReference(row.getRowNum(), > cell.getColumnIndex()); > System.out.println(cellRef + " Bottom: " + style.getBorderBottom()); > System.out.println(cellRef + " Top: " + style.getBorderTop()); > System.out.println(cellRef + " Left: " + style.getBorderLeft()); > System.out.println(cellRef + " Right: " + style.getBorderRight()); > > But how do I get the diagonal down and diagonal up? > > Thanks for your help! > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
