djwaddel has asked for the wisdom of the Perl Monks concerning the following question:

Nevermind, I missed the part where my $worksheet->insert_bitmap() was crapping out because I'm not using a true color 24bit bmp file...

Hmm this should be a fun one to figure out!!



Hey Wise ones, quick question about do() ...

I am using do() to run some dynamically created code to make a gnuplot chart. Prior to running that external code though I insert some data into a spreadsheet using WriteExcel, and if I close the workbook after the do(), the excel file is empty. If I close the workbook before the do() the workbook is fine.

This kinda sucks because I want to insert the chart that my external code is creating into my excel file...

Is there some gotcha not mentioned in perldoc or the man page about using do(), where stuff done before the do() is forgotten after, or something along those lines?

Thanks in advance!! I appreciate it!

  • Comment on quick question about do - Nevermind, solved

Replies are listed 'Best First'.
Re: quick question about do
by davidrw (Prior) on Aug 21, 2005 at 14:54 UTC
    can you supply code? Does the do() code do anything to the workbook variable? What is the dynamically created code? there may be a different (better?) way than the current do() approach.
      Hey Dave, Sorry it was user error :p

      My $worksheet->insert_bitmap() was failing because the bmp that imagemagick creates apparently isn't 24 bit true color. Hmmm

      Thanks for your help though!