On Mon, Nov 15, 2010 at 1:54 PM, Uri Guttman <[email protected]> wrote:
> >>>>> "sw" == shawn wilson <[email protected]> writes: > > sw> my $worksheetout = $workbookout->add_worksheet( '$year' ); > > why are you quoting $year? that doesn't do what you think it does. in > fact it is a bug. you aren't checking if you get results out of that > call which is another problem. > yeah, i noticed that when Spreadsheet::WriteExcel came back and said it couldn't recreate the same worksheet :) though, even posting this is sorta annoying to me since the solution was right in front of me and had just scrolled off the screen - i didn't even think to open up the doc to see what it had since i was just seeing errors :( it's all working fine now. i'm pretty much just playing around with slices of arrays now to get only what i want: while (my $sqldata = $sth->fetchrow_arrayref([ 1 .. -1 ]) ) { doesn't work. nor does this: $worksheetout->write_row( $count++, 0, \...@{ $sqldata }[1 .. $#{ $sqldata } ] ); i'm sure there's a learnable moment in here, but i'm about to just forget about it, label my first row as 'sql uid' and let them just hide it and call it a day. > uri > > -- > Uri Guttman ------ [email protected] -------- http://www.sysarch.com-- > ----- Perl Code Review , Architecture, Development, Training, Support > ------ > --------- Gourmet Hot Cocoa Mix ---- http://bestfriendscocoa.com--------- >
