If you're doing this on Windows and can have Excel open, there's Spreadsheet::TieExcel. I haven't tried it. It looks a bit tricky compared to the Spreadsheet::(Parse|Write)Excel modules, which don't require you to be on Windows or to even own a copy of Excel.

There are several DBD backends to DBI that can deal with Excel or with CSV files. They will let you query and insert. However, unless your data fits the SQL idea pretty well that's an awkward way to solve it. DBD::Excel is the most obvious, and I've used it. It's not bad. It works directly on XLS files. DBD::CSV, DBD::AnyData, and DBD::RAM can all handle CSV files.

As moritz says, using Spreadsheet::ParseExcel and Spreadsheet::WriteExcel both should be neither difficult nor any major source of slowdown in your program.

In a more general theme, if you want to know what else is available to work with Excel files, you can always go to http://search.cpan.org and search for 'Excel'. It'll give you these results.

In reply to Re: Parsing spreadsheet and generating spreadsheet report by mr_mischief
in thread Parsing spreadsheet and generating spreadsheet report by Satish@Stag

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.