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 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, 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 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]
