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: Fri, 15 Apr 2011 22:12:09 -0700 (PDT)
I didn't even think that the width of the table would control the excel width.
Thanks, it now looks like my excel export will look nearly perfect and not need any tweaking by the users.
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