Basic-Excel-R-Toolkit
Basic-Excel-R-Toolkit copied to clipboard
Use object in R
Hello !
I have the following function :
import <- function(path) { df <- read.csv(path) }
and the following maccro :
Sub import() Dim Path as Variant Dim v as Variant Sheets.Add.Name = "NouvelleFeuille" Path = IntPutBox("Path please?","Path") v = Application.Run("BERT.Call", "import", Path) ActiveSheet.Range("A1:I130000").Value = v End sub
And I put a button on excel.
But when I did that I don't import my df on R, could I do it ? (because I want use df in other function ! )
If yes how ? thank for you help !