Excel column filer using Perl
Hi, I'm new to perl and working on a small task using excel. I've a excel data like two columns 1)STATUS and 2) ID as follows
STATUS ID
Pending 123
Completed 456
Expired 789
Completed 987
Open 654
Closed 321
Completed 159
Rejected 753
I want the 'STATUS' column to filter for 'Completed' and then get the ID's associated to 'completed' only. The fetched ID's should be moved to new variable.
Let say a new variable 'Var' should contain 456,987 and 159. Please help me on this using perl script
0 answers
No answers yet.
Log in to answer this question.
How is this related to bioinformatics?
So basically you want to manipulate excel file (
.xlsx) in Perl?If yes there are very nice sample codes given on metacpan.
xlsx xls
and as zx8754 said how is it related to Bioinformatics?
Hello dev!
We believe that this post does not fit the main topic of this site.
Not a bioinformatics question
For this reason we have closed your question. This allows us to keep the site focused on the topics that the community can help with.
If you disagree please tell us why in a reply below, we'll be happy to talk about it.
Cheers!