Hi,
I have created the Boolean function below to evaluate if a given cell in an
Excel file contains a formula. I have to process hundreds of excel files and I
want to filter out any
cells that contain formulae.
Now I want to use the isXlsFormula function below when I loop through all the
cells of a sheet, and all sheets of an excel file. For this, it would be very
convenient if I could use the alternative R1C1 excel reference style, instead
of the alphabetic style, as shown below. Is this possible?
library(rcom)
isXlsFormula <- function(cellref="A1") {
excel <- comGetObject("Excel.Application")
sheet <- comGetProperty(excel, "ActiveSheet")
cell <- comGetProperty(sheet, "Range", cellref, cellref)
isformula <- comGetProperty(cell, "hasFormula")
return(isformula)
}
isXlsFormula() # returns TRUE if cell A1 (R1C1) contains a formula, FALSE
otherwise.
Thank you in advance.
Cheers!!
Albert-Jan
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
All right, but apart from the sanitation, the medicine, education, wine, public
order, irrigation, roads, a fresh water system, and public health, what have
the Romans ever done for us?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
[[alternative HTML version deleted]]
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
