in reply to Excel generation

Thankyou very much for your time and advise. This seems to work nicely. Using the code you provided, do i simply just use a series of 'print' commands to generate output rather than using Win::OLE code such as

$worksheet->Cells(5,1)->{Value} = "Dunedin 9001";

This embeeds excel into my application (great), but how can i allow my client to print the page contents? I know good old Ctrl + P works fine, but is not really feasible. Can i also embeed the Main menu of excel into my page? Thankyou again for your help. I would be lost without you guys. Digger

Also when i run this script from a button on a previous page, it pops up a dialog box asking to open or save. Can i avoid this unwanted step

Replies are listed 'Best First'.
Re^2: Excel generation
by dragonchild (Archbishop) on Sep 11, 2004 at 02:39 UTC
    We're going to need a little more about how you have your webserver set up, what you're really trying to do, and how you expect your users to do it.

    When I output an Excel version of reports that users run on my webapp, I just print it out to the browser with the appropriate Content-Type header and the browser does the right thing. At that point, the user is welcome to look at it, save it, or print it ... as they see fit.

    ------
    We are the carpenters and bricklayers of the Information Age.

    Then there are Damian modules.... *sigh* ... that's not about being less-lazy -- that's about being on some really good drugs -- you know, there is no spoon. - flyingmoose

    I shouldn't have to say this, but any code, unless otherwise stated, is untested

[reply]

In Section Seekers of Perl Wisdom