I have loaded a workbook into R and read in the worksheets using xlConnect, but I was wondering if there was a way of extracting the names of the sheets perhaps in a vector? So far my code is: da...

I understand that XLConnect can be used to read an Excel worksheet into R. For example, this would read the first worksheet in a workbook called test.xls into R. library(XLConnect) readWorksheetFr...

I'm installing XLConnect library in R studio but, unable to do so. I know that this package has java dependency and my R software and java both are 64 bit. Also, both have configured correctly. I h...

Since I updated RStudio last day I cannot get Rstudio to drop it's hold on my excelfiles. I've tried the following to no avail: unlink(fileName, recursive = TRUE) file.info(fileName) file.remove...

Is there any way to read out the color-index of cells from excel files with R? While I can set the cell color with packages like XLConnect or XLSX, I have found no way to extract the color-informa...

I'm trying to download an .xlsx file from the eia and getting the following error. The error is: "Error: ZipException (Java): invalid entry size (expected 2385 but got 2390 bytes)" I have tried ...

I am trying to write a R data frame to Excel and want to add additional cells/columns that have Excel formulas and/or data validation values (e.g. using the Data/Validation menu in Excel to provide...

I'm a bit impressed because I couldn't find an answer so far. I have a small R script that is loading data from one source and writing a few dozens Excel files from it. The problem now is: those f...

I am trying to read value from a .xlsx file using openxlsx package in R. In simple words, I need to write a row of data, which then populates some output cell that has to be read back in R. I will ...

I am trying to import an excel sheet into r. I used the following code: x <- loadWorkbook("x.xlsx") b <- readWorksheet(x, sheet="b") The first line works fine, however, running the second ...

Part 1: I am trying to rename worksheets in a list of workbooks using lapply and XLConnect (I need to rename them for the next part of the code to run properly, more on this in part 2): library(X...

I'm relatively new to R (and programming). I have an Excel workbook with 36 sheets, but suppose that I don't know how many sheets there are and I want my code to find that out for me. I have tried ...

I am using the function readWorksheet from the package XLConnect to import Excel sheets in R. These sheets contain special characters (e.g., ø, õ, ú) which R does not handle very well. As far as I ...

I am trying to use XLConnect library in R. If I execute library(XLConnect) I get the following error message: JAVA_HOME cannot be determined from the Registry To resolve this problem I set fi...

A couple of months ago I found on the Internet information about an R package to connect R with Excel and the other way around (doing basically what xlsx and XLConnect do). However, the main diffe...

I have to read a file in a list of folders and save data in R. I use following code for my test data and it works. When I use the code for the actual data then I get this error Error: OutOfM...

Has anyone tried using the download handler in R Shiny to download a freshly created Excel file with XLConnect? In the ui.R there is the unremarkable line: downloadButton('downloadData', 'Downloa...

I have a collection of excel files which I am importing into R. The files contain hidden data which I would like to disregard -- eg, simply not importing it, or importing it with a flag indicatin...

XLConnect is, as the manual describes it, "a package that allows for reading, writing and manipulation of Microsoft Excel files from within R". Installation on Windows and Linux is straightforward...

I'm running into a problem with JVM memory using XLConnect (Mirai Solutions) in R. Data loads into R just fine using loadWorkbook or readWorksheetFromFile, but larger data (data frames about 3MB)...