This is a test version of Biostars. For the public version, visit https://www.biostars.org.
Perl code to read excel file and rearrange the columns and print it in another excel

Hello....

hope you doing well.

I'm looking for a perl program to read an .xls file and wanted to re order a columns and print it in a new excel sheet.

I'm new to the programming so looking for the help.

Thank you,

xls rearrange-columns perl excel
• 1,627 views • link
updated by Ram Ram • written by Arpitha Hebbar Arpitha Hebbar

not related to bioinformatics: Your question will be deleted. Ask stackoverflow.com please.

• 0 views • link
updated by Ram Ram • written by Pierre Lindenbaum Pierre Lindenbaum

Hello Arpitha Hebbar!

We believe that this post is does not fit the main topic of this site.

No sufficient relation to bioinformatics. Off-topic, because excel is not a bioinformatics tool ;)

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!

• 0 views • link
updated by Ram Ram • written by Michael Dondrup Michael Dondrup

1 answer

Here is the perl module that you can use to format an excel document.

http://search.cpan.org/~jmcnamara/Excel-Writer-XLSX/lib/Excel/Writer/XLSX.pm

• 0 views • link
updated by Ram Ram • written by Ashutosh Pandey Ashutosh Pandey

Or export your excel document as a .csv file and use the linux cut tool.

• 0 views • link
updated by Ram Ram • written by Daniel Daniel

Log in to answer this question.

More posts like this