in reply to Re: Excel to PDF convertor
in thread Excel to PDF convertor

Thanks for the input Corion

But I want to convert excel file output to PDF form through perl module itself. I cant use OpenOffice for this. :-(

Is there any other way..

Replies are listed 'Best First'.
Re^3: Excel to PDF convertor
by Corion (Patriarch) on Aug 27, 2010 at 16:08 UTC

    What problem did you find with the modules I linked to? How did they fail to accomplish what you want?

      I have used the same module ParseExcel/WriteExcel which is mentioned by you to generate runtime excel file through perl on unix system. But I want something which will either save the excel output in PDF format or convert the existing excel file to PDF file.

        "I want this" is seldom a good strategy.

        A xls file is only a container for data and some formatting information so it cannot be converted into a pdf file that is a visual document format.

        You can render a xls file into a pdf file, using a tool that has to do operations much more complex that a simple data conversion; it is obviously possible write a perl module to do the same thing, but it would not be simple, nor particularly useful, because such a tool exists, is open source software, and is OpenOffice.

        If you can't use it (and I can't imagine why) you can use one of several PDF modules to generate the pdf file from your data, but then you'll need to code all the formatting manually, and that is not so easy...

        Rule One: "Do not act incautiously when confronting a little bald wrinkly smiling man."

        Then the advice provided by corion is absolutely correct. Use PDF::API2 to convert your data to PDF.