"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 | [reply]
[d/l] |
What have you done so far? Have you used the word Excel in the search box? Have you used a Google search for Excel?
You seem to have done no research on your own, but there are many, many pages on this website dealing with Excel. Just search them, read them and use the code.
| [reply] |