NYCPHP Meetup

[Mark Withington]

Steve,

You were correct, setColumn() needs to be called to size the cells before
any data is written to the worksheet.  Now the $M question....anyone know
what the units are in setColumn?  Definitely not pixels.  Maybe a conversion
ratio?

--------------------------
Mark L. Withington
PLMresearch
v: 508-746-2383
m: 508-801-0181
Calendar: http://www.plmresearch.com/calendar.php




> -----Original Message-----
> From: talk-bounces at lists.nyphp.org 
> [mailto:talk-bounces at lists.nyphp.org] On Behalf Of Steve Manes
> Sent: Tuesday, August 09, 2005 7:45 PM
> To: NYPHP Talk
> Subject: Re: [nycphp-talk] Spreadsheet/Excel/Writer.php
> 
> 
> Mark Withington wrote:
> > Any Spreadsheet/Excel/Writer.php experts out there?  I'm trying to 
> > paste bitmaps into spreadsheet cells via insertBitmap.  The images 
> > appear without a hitch, I'm just not able to adjust the size of the 
> > cell (either via the insertBitmap parameters or setColumn/setRow).
> > 
> > If anyone can point me to [better] documentation [than 
> PEAR's], or has 
> > some words of wisdom they can share....
> 
> Documentation for Spreadsheet::Excel is sparse, I'm afraid, and the 
> library is quirky enough that I wrote an API wrapper for it so I 
> wouldn't have to remember all the gyrations I needed to use 
> to generate 
> a boilerplate report.  Unfortunately I can't share it because 
> my client 
> considers it a trade secret.
> 
> IIRC, setColumn() needs to be called to size the cells before 
> any data 
> is written to the worksheet, if that's any help.  I've only 
> used images 
> to brand spreadsheets with client logos, always at 0,0.  But 
> I seem to 
> remember that bitmaps tend to float over the spreadsheet 
> anyway.  That 
> is, they're not bound by cells. 
> _______________________________________________
> New York PHP Talk Mailing List
> AMP Technology
> Supporting Apache, MySQL and PHP 
> http://lists.nyphp.org/mailman/listinfo/talk
> http://www.nyphp.org
>