getCellFormula-methods {XLConnect} | R Documentation |
Retrieves a cell formula from a workbook
.
## S4 method for signature 'workbook,character' getCellFormula(object,sheet,row,col) ## S4 method for signature 'workbook,numeric' getCellFormula(object,sheet,row,col)
object |
The |
sheet |
The name or index of the worksheet containing the cell |
row |
The one-based row index of the cell to query |
col |
The one-based column index of the cell to query |
Retrieves the formula of the specified cell as a character, without the initial
=
character displayed in Excel. Raises an error if the specified cell
is not a formula cell.
Thomas Themel
Mirai Solutions GmbH http://www.mirai-solutions.com
# Load workbook (create if not existing) wb <- loadWorkbook("cellFormula.xlsx", create = TRUE) createSheet(wb, "Formula") # Assign a formula to A1 setCellFormula(wb, "Formula", 1, 1, "SUM($B$1:$B$29)") # Returns the formula for Sheet1!A1 getCellFormula(wb, "Formula", 1, 1) # The same with a numeric sheet index getCellFormula(wb, 1, 1, 1)