Re: exporting to excel and styles
Re: exporting to excel and styles
- Subject: Re: exporting to excel and styles
- From: Theodore Petrosky <email@hidden>
- Date: Sat, 16 Apr 2011 06:46:16 -0700 (PDT)
Is there a way to control the RGB values in a fillForegroundColor statement? I understand that I am able to access the color pallet through the index number, but it would be nice if I could control the colors.
Ted
--- On Fri, 4/15/11, Amiel Montecillo <email@hidden> wrote:
From: Amiel Montecillo <email@hidden>
Subject: Re: exporting to excel and styles
To: "Theodore Petrosky" <email@hidden>
Cc: email@hidden
Date: Friday, April 15, 2011, 10:10 PM
Do you have a "width" attribute on the cell?
<td class = "header" cellType = "CELL_TYPE_STRING" width = "40">Government</th>
Amiel
On Sat, Apr 16, 2011 at 9:07 AM, Theodore Petrosky <email@hidden> wrote:
Amiel,
thanks, your hint really did the trick. I am using the exportExcel example from the ERComponentTour. this example puts the font and style info in a plist.
from your example, I added the key for fillPattern and this fixed my issue.
Do you know if there is a way to control column width?
Ted
--- On Fri, 4/15/11, Amiel Montecillo <email@hidden> wrote:
From: Amiel Montecillo <email@hidden>
Subject: Re: exporting to excel and styles
To: "Theodore Petrosky" <email@hidden>
Cc: email@hidden
Date: Friday, April 15, 2011, 8:24 PM
Try using fillForegoundColor instead of fillBackgroundColor. Something like:
header = {
font = headerFont;
fillForegroundColor = 22;
fillPattern = "SOLID_FOREGROUND";
wrapText = true;
alignment = "ALIGN_CENTER";
verticalAlignment = "VERTICAL_CENTER";
};
Amiel
On Sat, Apr 16, 2011 at 1:58 AM, Theodore Petrosky <email@hidden> wrote:
>
> Message: 7
> Date: Fri, 15 Apr 2011 16:06:11 +0200
> From: Anjo Krank <email@hidden>
> Subject: Re: exporting to excel and styles
> To: "email@hidden
> Dev Apple"
> <email@hidden>
> Message-ID: <email@hidden>
> Content-Type: text/plain; charset=us-ascii
>
> IIRC, a color number. One to 16 (64?)? Check the docs for
> POI.
That's what I thought so I tried all the numbers from 1 to 16 and nada. I stuck an NSLog in to see if my addition was happening and I see it is.
Styles = {default = {alignment = "ALIGN_RIGHT"; font = "default"; }; header = {fillBackgroundColor = "5"; alignment = "ALIGN_CENTER"; font = "bold"; }; bold = {alignment = "ALIGN_LEFT"; font = "bold"; }; normal = {alignment = "ALIGN_LEFT"; width = "250"; font = "default"; }; }; Fonts = {default = {name = "Arial"; fontHeightInPoints = "10"; }; bold = {name = "Arial Black"; }; };
I have a style header that aligns center and bolds the face. these attributes show just fine. the background fill doesn't.
I will keep hacking. I wish I saw a columnWidth setting!!!
Ted
>
> 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