Top "Xlconnect" questions

XLConnect is a comprehensive and platform-independent R package for manipulating Microsoft Excel files from within R. XLConnect differs from other related R packages in that it is completely cross-platform and as such runs under Windows, Unix/Linux and Mac (32- and 64-bit).

Read all worksheets in an Excel workbook into an R list with data.frames

I understand that XLConnect can be used to read an Excel worksheet into R. For example, this would read the …

r excel xlconnect
How to fix OutOfMemoryError (Java): GC overhead limit exceeded in r?

I have to read a file in a list of folders and save data in R. I use following code …

r excel xlsx xlconnect
How to extract sheet names from Excel file in R

I have loaded a workbook into R and read in the worksheets using xlConnect, but I was wondering if there …

r excel xlconnect
Import excel workbook with multiple sheets

I am looking to import an excel workbook into R with multiple sheets. However, I can't seem to quite make …

r excel xlconnect readxl
Error in XLConnect

I am trying to import an excel sheet into r. I used the following code: x <- loadWorkbook("x.…

r xlconnect
Package for connecting R and Excel without the Java Virtual Machine

A couple of months ago I found on the Internet information about an R package to connect R with Excel …

r excel xlsx xlconnect
Extract the number of sheets from an Excel workbook in R (without XLConnect)

I'm relatively new to R (and programming). I have an Excel workbook with 36 sheets, but suppose that I don't know …

r excel xlconnect
Importing .xlsx file with special characters

I am using the function readWorksheet from the package XLConnect to import Excel sheets in R. These sheets contain special …

r xlconnect
How to download an .xlsx file in R and load the data into a dataframe?

I'm trying to download an .xlsx file from the eia and getting the following error. The error is: "Error: ZipException (…

r import-from-excel xlconnect
XLConnect loadWorkbook error - POIXMLException (Java)

I'm trying to load a hefty Excel workbook (.xlsm format, ~30 mb) that has a large number of array calcs. > …

r excel apache-poi xlconnect