468,536 Members | 1,540 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,536 developers. It's quick & easy.

Sorting Excel Data


I am new to perl.
I want to know how to sort the datas in excel through perl

Feb 23 '07 #1
2 2340
Hi Shanmugam,
Use the ParseExcel module to parse through the excel sheet and get information in text.
Sort in the information in perl as usual and write it back to the excel using WriteExcel.
Downloading these modules gives you lots of examples on how to use them.
You can also use an application known as xls2txt if you do not want to write back to excel.
Feb 23 '07 #2
1,089 Expert 1GB
Thank you Natti, that's exactly how he should do it. Here are a couple links to the CPAN modules that Natti was referring.

cpan Spreadsheet::ParseExcel
cpan Spreadsheet::WriteExcel
Feb 23 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Chuck M | last post: by
3 posts views Thread by Robert | last post: by
2 posts views Thread by joe_d_builder | last post: by
1 post views Thread by Dwight | last post: by
3 posts views Thread by Don | last post: by
3 posts views Thread by leonliev | last post: by
3 posts views Thread by =?Utf-8?B?U2NvdHQ=?= | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.