Tahks for the reply,

What i intended to do was to get a file in zip format off thw web, unzip it, then get its contents in a table format so i can build up some graphs of my own.

Is there a way unzip the file in perl, then save the zipped file as .xls or whatever excel files are saved as. Im not interested in opening the file getting the data into a table format.

I tried to work around having the file open and writing to a spredsheet using Spreadsheet:WriteExcel but it seems a longa away around. Any ideas???

MonkPaul. Sorry about the change of node.. im not quite sure how to work this stuff yet. :(. With regards to the Unzipping of files.. The Archive::Zip::MemberRead method looks to be useful for searching through the file without actually unzipping the damn thing. Have i interpretated it correctly or am i way off.

In reply to Converting a txt file to excel file by MonkPaul

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.