Basic-Excel-R-Toolkit icon indicating copy to clipboard operation
Basic-Excel-R-Toolkit copied to clipboard

Use object in R

Open naiiiiii opened this issue 7 years ago • 0 comments

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 !

naiiiiii avatar Jun 07 '18 15:06 naiiiiii