Home ยป excel

excel

java r excel

Error in .jcall(“RJavaTools”…) when importing large xlsx files in R

  • by

Recently I had to read in a folder full of large Excel (.xlsx) files. I did as I usually did and use the xlsx library. However, reading in the largest files produced an error: “Error in .jcall(“RJavaTools”, “Ljava/lang/Object;”, “invokeMethod”, cl, : java.lang.OutOfMemoryError: Java heap space” I don’t know what cause… Read More »Error in .jcall(“RJavaTools”…) when importing large xlsx files in R

date conversion excel r

Date conversion from Excel to R

  • by

It happened too many times before I write this blog post. Oftentimes, when I read Excel (xls or xlsx) files into R, I encounter this strange phenomenon where dates are converted to a 5 number integer. Here is how to fix it. For example, 02/01/2017 (dd/MM/yyyy) would be converted to… Read More »Date conversion from Excel to R