Ok, this is a new automation program, I would like to practice on but need some ideas on how to attack it.

let's see, I have a spread sheet with names, age, birthdays, addresses and phone number and relative people, if known.

Also, I have written a program that computes, the age of someone in if given the birthdate and hour born. takes into account leap year and eastern and pacific time difference

I would like to write up a program to create a GUI then ask user for inputs to get some information out from another spread sheet file and use the calculator if they opted to do

automation, is to get spreadsheet and extract info to use with another program to calculate age then to add a notice alarm to my calendar

first, I will use Tkx because I can't seem to get Tk loaded in netbeans. so that's a limitation. I could use other program to build GUI, if you think it is available for nebeans or an entirely different GUI program if it is easy to do while using perl( I can't find support on netbeands anywhere...sad coz I think netbeans is a nice IDE

Can I open a MS spread sheet using perl? haven't tried it yet coz I wouldn't know how

don't know how to add an event into MS calendar used in my PC for cases where I want to add bdate notice

read up on some automation but it all seems to be done using modules...I want to use the existing spreadsheet and calculator and use a separate program to add event into calendar

any advice will be greatly appreciated

In reply to need advise on how to tackle an automation program using perl. by perlynewby

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.