Re: exporting to excel and styles
Re: exporting to excel and styles
- Subject: Re: exporting to excel and styles
- From: Anjo Krank <email@hidden>
- Date: Fri, 15 Apr 2011 16:06:11 +0200
IIRC, a color number. One to 16 (64?)? Check the docs for POI.
Cheers, Anjo
Am 15.04.2011 um 15:57 schrieb Theodore Petrosky:
> I keep hunting for documentation on the styles available in exporting to excel. for instance I see a fillBackgroundColor and this comment:
>
> Styles:
> id="foo"
> font="someFontID"
> alignment="ALIGN_GENERAL|ALIGN_LEFT|ALIGN_CENTER|ALIGN_RIGHT"
> verticalAlignment="VERTICAL_TOP|VERTICAL_CENTER|VERTICAL_BOTTOM|VERTICAL_JUSTIFY"
> borderLeft_borderRight_borderTop_borderBottom=
> "BORDER_NONE|BORDER_THIN|BORDER_MEDIUM|BORDER_DASHED|BORDER_HAIR|BORDER_DOUBLE|BORDER_DOTTED|
> BORDER_MEDIUM_DASHED|BORDER_DASH_DOT|BORDER_MEDIUM_DASH_DOT|BORDER_DASH_DOT_DOT|
> BORDER_MEDIUM_DASH_DOT_DOT|BORDER_SLANTED_DASH_DOT"
> leftBorderColor_rightBorderColor_topBorderColor_bottomBorderColor="0-xx"
> fillPattern="NO_FILL|SOLID_FOREGROUND|FINE_DOTS|ALT_BARS|SPARSE_DOTS|THICK_HORZ_BANDS|THICK_VERT_BANDS|THICK_BACKWARD_DIAG|
> THICK_FORWARD_DIAG|BIG_SPOTS|BRICKS|THIN_HORZ_BANDS|THIN_VERT_BANDS|THIN_BACKWARD_DIAG|THIN_FORWARD_DIAG|SQUARES|DIAMONDS"
> hidden="true"
> locked="true"
> wrapText="true"
> indention="0"
> rotation="-90...90"
> fillBackgroundColor="0-xx"
> format="some format string"
> */
>
> What is "0-xx"?
>
> Ted
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden