in reply to Re: Color highlighting in Excel
in thread Color highlighting in Excel

The file gets terminated at the second line, since its unable to find Spreadsheet::WriteExcelXML or evern Spreadsheet::WriteExcel. Do I need to add WriteExcel into the repository.

Replies are listed 'Best First'.
Re^3: Color highlighting in Excel
by jmcnamara (Monsignor) on Sep 19, 2005 at 09:06 UTC

    That error means that the module hasn't been installed.

    There are installation instructions for Spreadsheet::WriteExcel here. The first two methods also apply to Spreadsheet::WriteExcelXML.

    With ActivePerl you can also install the modules via ppm from the ActiveState repositories.

    See also Writing, Installing, and Using Perl Modules.

    --
    John.

      I had tried installing it from the links you mentioned but do these work on Win XP machines since these are tar.gz files?

        You can unzip and untar those files with winzip. However, if you are on Windows (and I assume using ActivePerl) then you can install the modules using the ppm command:
        C:\Temp>ppm ppm> search Spreadsheet::WriteExcel Searching in Active Repositories 1. Spreadsheet-WriteEx~ [2.14] Write to a cross platform Excel bina +ry file ... ppm> install 1

        Repeat for Spreadsheet::WriteExcelXML (it will be in the same list above) and choose the number for version 0.09.

        If you are unfamilar with installing modules then you really should have a look at the first two tutorials in the section linked to above.

        --
        John.