My mother-in-law, no I'm not joking, had a ColdFusion server app reading Excel spreadsheet data of 64 parishes' info on kids (57 fields each). They moved their site and only have the spreadsheet data now and the format they want it displayed in. My question to my brethren is how difficult is this project of writing an app to display info by parish. I am, as you know, a neophyte. I have read that Win32::OLE will help me interpret this but I have next to know experience with reading flat file data into perl. In the relative scheme of things, how hard is this task? I realize this may be far too little data for you to advise me but any response will be appreciated!
TIA
jg
_____________________________________________________
If it gets a little bit out of hand sometimes, don't let it fool you into thinkin' you don't care.TvZ

In reply to Using Win32::OLE to gather data from M$ Excel Spreadsheets for Mother-In_Law by jerrygarciuh

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.