http://qs321.pair.com?node_id=855617


in reply to OLE Excel.Application Vs Spreadsheet::WriteExcel

I've successfully used Spreadsheet::WriteExcel in production for years. I swear by it in fact. It's a simple install from CPAN so give it a whirl.

Replies are listed 'Best First'.
Re^2: OLE Excel.Application Vs Spreadsheet::WriteExcel
by nocool (Novice) on Aug 17, 2010 at 21:27 UTC
    Vek, Thanks for the reply.

    My requirement is to generate the excel files with calculated data and graph on Unix based system. Also I have to call Crystal Reports from the same Perl code.
    Can we use OLE Microsoft Excel in this scenario ?
    Please sugest...
      I don't have any experience of OLE Microsoft Excel to be honest. I'm confused though, isn't Crystal Reports a Windows based reporting tool? Are you going to run your excel generator on a Windows box or a Unix box?
        Hi Vek,
        Crystal report is windows and unix compatible reporting tool. And I want to run my excel generator on unix box + I want to run/execute crystal reports in the same box.

        Can you put some more light on this?