Odtnhj

I want to import some excel files to R using read_excel(measured values by an instrument, with some parameters calculated using other measured values, so it has lots of formulas in some of the cells), I want to import all the files once, but when I import the files, I find the cells with formula are 0, they are not evaluated.

the basic code are:

library(readxl)
readxl_6800 <- function(path, name_rows = 42, data_rows = 43)
 data_name <- read_excel(path, range= cell_rows(name_rows))
 df <- read_excel(path, skip = data_rows, col_names = FALSE)
 colnames(df) <- colnames((data_name))
 return (df) 
 
df

the results are:

# A tibble: 360 x 10
obs time elapsed date TIME E A Ca Ci Pci
 <dbl> <dbl> <dbl> <chr> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
1 1 1500971222. 0 20170725 16:27~ 1.50e9 0 0 0 0 0
3 3 1500971224. 2 20170725 16:27~ 1.50e9 0 0 0 0 0
4 4 1500971224. 3 20170725 16:27~ 1.50e9 0 0 0 0 0
5 5 1500971226. 4 20170725 16:27~ 1.50e9 0 0 0 0 0

where the zero values should be values larger than zero.

the sample excel can be download from:

example file

how can I import the excel in this form with the formula evaluated? any suggestions?

I do not want to rewrite these formulas in R, as it will add lots of codes in R, it is the last choice.