Sorry if my question isn't for a specific R issue. I have multiple excel files with sheets that i would like to merge into one. Is it possible to do this in R? If so, which package would anyone recommend?
- You can use the package
readxland the function
read_excelto read the files in.
- Then, you can merge them in R using functions in the tidyverse. I don't know your data structure and this step might just be concatenating if you are putting things together by stacking them or it could be joining them by merging using some ID. I can't tell from your question.
- Finally, save as an Excel file using
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.
Thanks very much for answering my question.
I will take a look at the package you have mentioned. I will update the question with my experience.
Thanks for your help.