I have 198 worksheets all in Excel (xls format) and need to pass them to .csv format so that I can work with them in R. These worksheets are saved inside a folder on my computer all in .xls format
After converting them to .csv I need to unite all of them in order to obtain a similarity table, containing in the lines my study areas and in columns my plant species, filling with data of abundance of species for each area sampled. In addition to similarity, I need to calculate parameters that are structuring my plant communities, such as frequency, density, and dominance.
So, at the beginning, I would like to have a command in R where it can automatically transform my .xls tables into .csv so that I can start my journey, since it will take me a long time to save one by one ...
Can anyone answer me how do I do this using R?
Thank you !!!