This is a test version of Biostars. For the public version, visit https://www.biostars.org.
How to merge large number of excel files into single files?

Hi I have 2000 excel files, I want to merge in a single file can anyone share R or PERL codes all files have 3 attributes Thank you

r

cat unix command can do this trick if you have .csv files

If you got xls files you can do the following in a loop over your 2000 files

ssconvert file.xlsx newfile.csv

Then apply the cat command

Hello mathavanbioinfo!

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

Pure programming, not primarily bioinformatics, try at StackOverflow

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 answers

No answers yet.

Log in to answer this question.