Search code examples
javaapache-poixssf

How to create sheet with right-to-left alignment using Apache POI XSSF

I'm trying to create a sheet in the Excel file using Apache POI.

Since it's Excel 2007, I'm using XSSF and I'm looking a for way to make a sheet right-to-left aligned.

In HSSF there is a method org.apache.poi.hssf.usermodel.HSSFSheet.setRightToLeft(boolean), but I cannot find it in org.apache.poi.xssf.usermodel.XSSFSheet.

I'm using Apache POI 3.7

Solution

  • The workaround:

     XSSFSheet sheet = workbook.createSheet();
 sheet.getCTWorksheet().getSheetViews().getSheetViewArray(0).setRightToLeft(true);

    Source: http://thread.gmane.org/gmane.comp.jakarta.poi.user/17099/focus=17110