python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - r-xlsx

i can't read an excel that i could already read in R, i'm using the tool read.xlsx2

I'm using R and i need to open an excel file, while i'm working with it it appears the next message: Error in .jcall("RJavaTools", "Z", "hasField", .jcast(x, "java/l...
test-img

Fernando Marcelo Figueroa Carp

java

r

onedrive

r-xlsx

Votes: 0

Answers: 0

Getting Error while trying to read .csv in R Studio

I'm trying to import a dataset with .csv format but I keep getting errors. If I use the built-in import feature of R Studio I get this error: embedded nul in the string: 'C\0a\0m\0p\0a\0g\0n\0e\0_\0N...
test-img

Andrea

r

read.csv

r-xlsx

Votes: 0

Answers: 0

Is there a R function to add data from a df and append it to a sheet in excel

I have a R code that uses joins from various tables and finally have an output dataframe. I need this to be appended to a new worksheet in excel file that already has three sheets in it. I am on a mac...
test-img

moikoi

r

export-to-excel

r-xlsx

Votes: 0

Answers: 0

How can use variables for the row and columns in setCellFormula in the xlsx package in R?

I am trying to create a formula in a cell of an existing Excel document. I can easily do it this way: #Load workbook wb<-loadWorkbook('test.xlsx') #Let this be any xlsx document with borders on c...
test-img

P.A

r

r-xlsx

Votes: 0

Answers: 1

Latest Answer

You should parse the text before evaluating it: eval(parse(text=paste0("cells$'",r,".",c,"'$setCellFormula('A1')")))
test-img

Waldi

Posts

Questions

Blogs

Jobs