in reply to Using Perl and OWC to render Excel-Style Graphs

Quite an admirable effort, knowing how messy OLE can get.

How do you print a graph as binary directly to stdout?

Last time I checked, a MS Office OLE could easily eat up MBs of RAM. That's why it wasn't usable for website with even moderate load. How'd OWC do in that regard?

(When clients asked for Word or Excel doc from the Web, we normally simply produced html or some text files, since MS Office could read those formats seamlessly. The clients didn't really know the difference.)
  • Comment on Re: Using Perl and OWC to render Excel-Style Graphs

Replies are listed 'Best First'.
Re: Re: Using Perl and OWC to render Excel-Style Graphs
by emarsee (Acolyte) on Jul 02, 2003 at 08:17 UTC

    I take the lazy approach of dropping the gif into a predefined file on the server, then using an <img src='xxx.gif'> tag. There is no way of doing it inline. If you're generating many of these images, it is usual to generate a name automatically using a random number combined with a date/time element, then use each run of the script to clear up images from previous runs of the same script, such as clearing any image older than ten minutes old.

    I haven't checked the memory usage, but I'm using this on an internal server, and it doesn't seem to leak memory, as the COM object should(?) drop all of its' memory at the end of the script.