"Can this one be done"

Yes.

"Can anyone help me on this"

Sure, first read How do I post a question effectively? and the PerlMonks FAQ. Since you have not told us what operating system you are using, if Excel is available to you on this system and if you are trying to edit an existing Excel file or not. Why would the answers to these questions help us to help you? Put simply there are various ways to achieve this goal, depending on the circumstances (OS etc as I have mentioned previously) and tools available to you.

For example, if you are on a Windows system editing an existing Excel file you may want to look at using Win32::OLE to drive Excel. If you are creating a new Excel file and wish to populate it with x number of worksheets containing your column headers, SperadSheet::WriteExcel may be the way you want to go.

On the other hand, if you are not using Windows, SpreadhSheet::WriteExcel is the way to go if you if you do not have an existing workbook, otherwise a combination using SperadSheet::ParseExcel to read the file and SpreadSheet::WriteExcel to updated it (see this post for a link to an article explaining this) can be used to achieve your goal.

As Corion has pointed out research/searching is always a good idea, remember Super Search is your friend.

Martin

In reply to Re: Writing to the whole excel work book in perl by marto
in thread Writing to the whole excel work book in perl by anand_perl

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.