Importing a cell value in R

tidyverse
1

Hi! how can I import the value of one excel cell like in Visual Basic?

Sub test()
  fx = Cells("C", 7).Select
End Sub

When I used readxl, I obtained a tbl. I just require a some values from an Excel file to used as variables in my R code.
Please, any help or comment will be highly appreciate.
Regards.

1 Like
2

with readxl package you can read a "range" of a single cell

library(readxl)

value <- read_excel("file.xlsx", range = "C7:C7", col_names = FALSE)[[1]]
3 Likes
3

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.