How should I deal with:

Error in .jcall(Rintf, "[S", "readColStrings", .jcast(sheet, "org/apache/poi/ss/usermodel/Sheet"), :
java.lang.OutOfMemoryError: GC overhead limit exceeded

after using xlsx.readFile on a relatively small .xlsx file (7099 rows x 32 columns)?

Thanks.

Hi, I don't know if anyone can help. I have installed the package xlsx and I'm trying to read an Excel file but I get this error and I don't know how to solve it:
Error in loadWorkbook(file, password = password) : Cannot find JF420368

Note: JF420368 is the name of the file

Yes, you can easily format table in html and pdf via Rmarkdown using the R packages kable and kable extra.

Hi, this is super helpful. I am wondering, is i possible to do this type of formatting in an output via word, pdf, web? i am just beginning this investigation, so any input would help.
I am somewhat familiar with rmarkdown, etc. but i am struggling to figure out how to get tables formatted and colored correctly, as you have done in this blog post.

Thanks,
Alex

Hi! I'm using your amazing package r2excel, but I think I found a bug: when you create multiple sheets in the same workbook and try to add a plot in two or more different sheets, it adds the same first plot to all the other sheets.

How can I deal with that?

Thanks!

Hi,

You can install the package as follow:

1. First install devtools package:




2. Install r2excel:



(I removed the extra-space in your code)

If your network is blocked, let me know, I will send you the source code and the R code to install the package from the source.

e-mail: alboukadel.kassambara@gmail.com

Good luck!

Hi good afternoon

I find it an excellent material, I wonder how can I can download the library? because I have blocked the network.
I stood at this point: devtools :: install_github ("Kassambara / r2excel")

It is very good material to produce reports that can be generated with a specific format in Excel.

I hope you can help me