Nothing
tests/testthat/test.extractSheetName.R
In XLConnect: Excel Connector for R
test_that("extractSheetName extracts sheet names from formulas", {
formulas <- c("MySheet!$A$1", "'My Sheet'!$A$1", "'My!Sheet'!$A$1", "MySheet")
expected <- c("MySheet", "My Sheet", "My!Sheet", "")
expect_equal(extractSheetName(formulas), expected)
})
Try the XLConnect package in your browser
Any scripts or data that you put into this service are public.
XLConnect documentation built on Feb. 24, 2026, 9:06 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
test_that("extractSheetName extracts sheet names from formulas", {
formulas <- c("MySheet!$A$1", "'My Sheet'!$A$1", "'My!Sheet'!$A$1", "MySheet")
expected <- c("MySheet", "My Sheet", "My!Sheet", "")
expect_equal(extractSheetName(formulas), expected)
})
Try the XLConnect package in your browser
Any scripts or data that you put into this service are public.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.