I got it to work as follows:
* private boolean isCrossedOut(Sheet theSheet, int theRow, int theCol) {*
* Row row = theSheet.getRow(theRow - 1);*
* Cell cell = row.getCell(theCol - 1);*
* XSSFCellStyle style = (XSSFCellStyle) (cell.getCellStyle());*
* CTXf cxf = style.getCoreXf();*
* long borderIndex = cxf.getBorderId();*
* CTBorder ctBorder = mStylesTable.getBorderAt((int)
borderIndex).getCTBorder();*
* boolean up = ctBorder.getDiagonalUp();*
* boolean down = ctBorder.getDiagonalDown();*
* if (up && down) {*
* return true;*
* } else {*
* return false;*
* }*
* }*
The mStylesTable is initialized at program startup as follows:
* mStylesTable = null;*
* for (POIXMLDocumentPart part : ((XSSFWorkbook)
mExcelReader.getWorkbook()).getRelations()) {*
* if (part instanceof StylesTable) {*
* mStylesTable = (StylesTable) part;*
* break;*
* }*
* }*
* if (mStylesTable == null) {*
* throw new RuntimeException("Could not find styles table");*
* }*
Thanks for your help,
/Bengt
2015-09-28 9:32 GMT+02:00 Bengt Rodehav <[email protected]>:
> Thank you Mark and Dominik. I will try to get this information from the
> cell style.
>
> /Bengt
>
> 2015-09-25 18:22 GMT+02:00 Dominik Stadler <[email protected]>:
>
>> Hi,
>>
>> There was a discussion about how to set diagonal border styling a few
>> weeks ago, see
>> http://mail-archives.apache.org/mod_mbox/poi-user/201508.mbox/browser,
>> it describes how to set a diagonal border, maybe you can use some of
>> this for reading the information in your case.
>>
>> Dominik.
>>
>> On Fri, Sep 25, 2015 at 4:21 PM, Mark Beardsley
>> <[email protected]> wrote:
>> > The border is part of the style applied to the cell from POIs point of
>> view.
>> > What you will need to do is recover the style from the cell - call the
>> > getCellStyle() method on the object - and then interrogate that to find
>> out
>> > what type of border has been applied. If you look at the CellStyle
>> class,
>> > you should see that manifest constants have been created that identify
>> the
>> > various attributes and they include THICK_BACKWARD_DIAG and
>> > THIN_FORWARD_DIAG. A simple switch clause should allow you to filter
>> out the
>> > cells that are marked with diagonal borders; it is maybe wise to include
>> > tests for all of the diagonal options unless you are confident in your
>> user
>> > body.
>> >
>> >
>> >
>> > --
>> > View this message in context:
>> http://apache-poi.1045710.n5.nabble.com/Diagonal-border-tp5720338p5720341.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]
>> >
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [email protected]
>> For additional commands, e-mail: [email protected]
>>
>>
>
