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 protected]>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 protected]> wrote: > > From: Amiel Montecillo <[email protected]> > Subject: Re: exporting to excel and styles > To: "Theodore Petrosky" <[email protected]> > Cc: [email protected] > 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 protected]> > wrote: > > > > > > > > > > > Message: 7 > > > Date: Fri, 15 Apr 2011 16:06:11 +0200 > > > From: Anjo Krank <[email protected]> > > > Subject: Re: exporting to excel and styles > > > To: "[email protected] > > > Dev Apple" > > > <[email protected]> > > > Message-ID: <[email protected]> > > > 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 protected]) > > Help/Unsubscribe/Update your Subscription: > > http://lists.apple.com/mailman/options/webobjects-dev/bosyotech%40gmail.com > > > > > > This email sent to [email protected] > > > > >
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
