You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Michael Elman <ta...@gmail.com> on 2011/07/28 09:17:55 UTC
How to create sheet with right-to-left alignment using Apache POI XSSF
Hi,
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
Thanks,
Michael
Re: How to create sheet with right-to-left alignment using Apache
POI XSSF
Posted by igor <ig...@mailpoalim.co.il>.
Hello Yegor,
thank you for help!
is there a way to set this property in HSSF API?
thanks!
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/How-to-create-sheet-with-right-to-left-alignment-using-Apache-POI-XSSF-tp4641523p4743461.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: How to create sheet with right-to-left alignment using Apache POI XSSF
Posted by Michael Elman <ta...@gmail.com>.
Cool! Thank you!
On Thu, Jul 28, 2011 at 2:46 PM, Yegor Kozlov <ye...@dinom.ru> wrote:
> We don't have a usermodel API for setting this property. The following
> low-level trick should work though:
>
> XSSFSheet sheet = workbook.createSheet();
>
> sheet.getCTWorksheet().getSheetViews().getSheetViewArray(0).setRightToLeft(true);
>
> Yegor
>
> On Thu, Jul 28, 2011 at 11:17 AM, Michael Elman <ta...@gmail.com> wrote:
> > Hi,
> >
> > 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
> >
> > Thanks,
> > Michael
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
Re: How to create sheet with right-to-left alignment using Apache
POI XSSF
Posted by igor <ig...@mailpoalim.co.il>.
thank you,
is there way to do this in HSSF API?
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/How-to-create-sheet-with-right-to-left-alignment-using-Apache-POI-XSSF-tp4641523p4766872.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: How to create sheet with right-to-left alignment using Apache POI XSSF
Posted by Yegor Kozlov <ye...@dinom.ru>.
We don't have a usermodel API for setting this property. The following
low-level trick should work though:
XSSFSheet sheet = workbook.createSheet();
sheet.getCTWorksheet().getSheetViews().getSheetViewArray(0).setRightToLeft(true);
Yegor
On Thu, Jul 28, 2011 at 11:17 AM, Michael Elman <ta...@gmail.com> wrote:
> Hi,
>
> 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
>
> Thanks,
> Michael
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org