0

How can one load an Excel file to R with all its tab names? I am using the readxl package currently for reading Excel but can't figure out how to save its tab names? E.g., 

abc = read_excel("Saudi Diapers.xlsx", 1, col_names = T)

Here I have specified sheet no. 1 to be read by R, but how to retrieve its name also?

Sam Firke
  • 21,571
  • 9
  • 87
  • 105
Ankit Bhatia
  • 99
  • 1
  • 1
  • 8
  • Also similar to http://stackoverflow.com/questions/12945687/how-to-read-all-worksheets-in-an-excel-workbook-into-an-r-list-with-data-frame-e. I don't think `readxl` supports getting the sheet name, but it looks like `XLConnect` does. – Sam Firke Mar 11 '16 at 20:11
  • 2
    it does support it: ´excel_sheets("Saudi Diapers.xlsx")´ – Buggy Mar 11 '16 at 21:33
  • thank you, that's exactly what I wanted – Ankit Bhatia Mar 12 '16 at 06:54

0 Answers0