arunks, Corion gave you some good advice in the chatterbox, recorded here for posterity: "Maybe How do I make password prompts not echo back the user?? Or simply read it from STDIN".

If I were to be solving the problem, especially after the advice already given in the thread, I would go to the documentation for Spreadsheet::ParseXLSX, which then directs you to the details in Spreadsheet::ParseExcel, which shows the syntax for giving options to the ->new(%opt) call. I would then code up the simplistic read-from-STDIN prompt (a single print and a single read from STDIN), and pass the result from that read into the the appropriate portion of Spreadsheet::ParseXLSX->new(%opt). Including using the modules, everything from using modules to instantiating the parser per the linked documentation took 6 lines -- and that's because I read into a variable instead of combining the read with the ->new(...), and counted the two lines for using strict and warnings.

After you've made an honest attempt at writing those 6 lines for yourself, you might want to look at Tutorials, especially Getting Started with Perl and Basic debugging checklist. If you're still having trouble moving forward, post your code, along with what errors you are getting, and ask specific questions.

In reply to Re^4: protect excel file in perl script by pryrt
in thread protect excel file in perl script by arunks

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.