Count or list sheet names in Excel spreadsheet files.
Count or list sheet names in Excel spreadsheet files.
sheetCount(xls, verbose = FALSE, perl = "perl") sheetNames(xls, verbose = FALSE, perl = "perl")
xls |
File path to spreadsheet. Supports "http://", "https://", and "ftp://" URLS. |
verbose |
If |
perl |
Path to perl interpreter. |
sheetCount returns the number of sheets in the spreadsheet.
sheetNames returns the names of sheets in the spreadsheet.
xlsfile <- system.file("xls", "iris.xls", package = "gdata")
xlsfile
sheetCount(xlsfile)
exampleFile <- file.path(path.package('gdata'),'xls',
'ExampleExcelFile.xls')
exampleFile2007 <- file.path(path.package('gdata'),'xls',
'ExampleExcelFile.xlsx')
sheetCount(exampleFile)
if( 'XLSX' %in% xlsFormats() ) # if XLSX is supported..
sheetNames(exampleFile2007)Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.