I have an excel workbook where there are 70 sheets inside. I want to merge them all together. I have used the code below for this. But it throws up an error regarding class of the variable.
How can I solve it?
your_path<-"C:/Users/NITHIN PRADEEP/Downloads/School_wise_assessment_sheet.xlsx" sheets<-excel_sheets(your_path) map_dfr(.x = sheets, .f = ~read_excel(your_path, sheet = .x) %>% mutate(sheet = .x)) %>% writexl::write_xlsx("Merged_master.xlsx") Error: Can't combine `..1$dise_code` <character> and `..35$dise_code` <double>. Run `rlang::last_error()` to see where the error occurred