I also did not look at the image file.

That being said, I have to wonder how much manipulation is needed here. If the idea is to go from .xlxs to the standard(old).xls format, why not just open it in something like LibreOffice and do a "Save As", and choose the version that you need? Last I looked there was some rather large selection of Excel formats, and I seem to recall they include the format you want. Once that is done, use Excel or LibreOffice to manipulate it as you see fit, then save.

I could understand doing this programmaticaly if there were a large number of files that you needed to do it for, but you indicated "an irregular file", so I am assuming a single file.

I find it hard to believe that you are going to get functionality out of Perl that you would not get out of the application(Excel) and its built in scripting without a lot more effort than is really required.

I recognize that there may be other circumstances, but based on what you have written, I would be inclined to ask myself why I want to write a program...

Note that I no longer use Excel, other than to receive the files and open them in an opensource application, and if I have to, save them back to the original format and return them to the sender, so the Excel side of my advice is suspect... .

Good luck with your project!

...the majority is always wrong, and always the last to know about it...
Insanity: Doing the same thing over and over again and expecting different results.

In reply to Re: Xlxs Parsing Issue by wjw
in thread Xlxs Parsing Issue by rahul_lfo

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.