in reply to Excel to XML issue with Spreadsheet::ParseExcel

The error warning is mentioned in perldiag. Does the Excel file contain Unicode characters?
  • Comment on Re: Excel to XML issue with Spreadsheet::ParseExcel

Replies are listed 'Best First'.
Re^2: Excel to XML issue with Spreadsheet::ParseExcel
by stonecolddevin (Parson) on Jan 17, 2007 at 22:59 UTC

    I'd assume so eff_i_g. Without delving into the docs, is there a way to get rid of it if it's not fatal?

    meh.
      A Google search brings up a few results dealing with this very module. One from October suggests:
      # If the next tests give warnings like # Character in 'C' format wrapped in pack at # /usr/local/perl/5.8.8/lib/site_perl/5.8.8/Spreadsheet/ParseExcel/ +FmtDefault.pm line 68 # Change C* to U* in line 68

        Fantastic, thanks for the research eff_i_g.

        meh.
        That warning is from my Spreadsheet::Read, which not only issues a warning, but also generates a patch to correct it. As said, the recent Spreadsheet::ParseExcel updates have fixed it already. BUT ...

        The new version 0.28 has several problems:
        * It is expecting Jcode and Unicode::Map to be installed as prerequisites unconditionally. Just for supporting Japanese.
        * It requires IO::Scalar for opening streams, which is not needed for all perl versions that have PerlIO.

        I have sent a patch to Gabor to fix both issues, but have no reply yet.
        Until then, I would suggest to install Spreadsheet::Read and apply the generated patch.