I have an excel workbook which contains few sheets within which we have some tables in different forms. I am interested in saving individual table as individual dataframe. I am trying to use getTables(). This is my first experience with it and I am not sure what I am doing wrong. But the result is character (empty). I was hoping to extract tables within the sheet. Can you please help? Here is what I am doing:
path <- "Data/USA.xlsx" USA <- createWorkbook(path) vision <- getTables(USA, sheet = "Vision")
Thanks for your help!