Stack Overflow
Stack Overflow

Questions tagged [xlconnect]

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). Moreover, it does not require any installation of Microsoft Excel or any other special drivers to be able to read & write Excel files.

XLConnect: Excel Connector for R

XLConnect is a comprehensive and cross-platform 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). Moreover, it does not require any installation of Microsoft Excel or any other special drivers to be able to read and write Excel files. The only requirement is a recent version of a Java Runtime Environment (JRE).

The package can easily be installed from CRAN via install.packages("XLConnect") (or install.packages("XLConnect", type="source") on Mac OS X).

Alternatively, the package can be installed directly from github using the devtools package:

require(devtools)
# Installs the master branch of XLConnect (current development version)
install_github("xlconnect", username = "miraisolutions", ref = "master")

Resources:

226 questions
5
votes
1 answer

R write data into xlsm

I have a data.table: e.g. > aDT <- data.table(colA = "apple", colB = "banana", colC = "4") > aDT colA colB colC 1: apple banana 4 I need to write this table into a worksheet in a xlsm (it has macros). Have tried several ways to connect to…
LeGeniusII
  • 900
  • 1
  • 10
  • 28
4
votes
1 answer

Dealing with xlsm with R

I am trying to deal with an official .xlsm file provided officially by a earthquake research center. You can download the file from theXLSM. What I am trying to do is to code R that change specific parts of the xlsm and then re-evaluate the .xlsm…
olk
  • 61
  • 1
  • 5
4
votes
2 answers

openxlsx not able to read from .xlsx file in R

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 share an example to better explain the…
joel.wilson
  • 8,243
  • 5
  • 28
  • 48
4
votes
3 answers

Proprietary software produces ugly excel tables...can I get them into R?

We collect bat calls and analyze them and the outputs are a nightmare. I would like to streamline our process, but I'm stumped. How do I take dozens of files from excel, that look like this: And get the import to add the rows,…
NoobR
  • 311
  • 2
  • 10
4
votes
1 answer

How to save an R data frame to Excel file with certain cells in bold?

I often write papers with correlation matrices. I would like to be able to export the correlation matrix to Excel in xls or xlsx format. I would also like to format in bold correlations that meet a threshold (e.g., > .2). I was thinking maybe…
Jeromy Anglim
  • 33,939
  • 30
  • 115
  • 173
4
votes
3 answers

R Save a excel workbook with password protection

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 files need a password protection. Currently my script…
Rick
  • 521
  • 5
  • 18
4
votes
1 answer

R. Exporting a list to a single sheet in Excel

I'd like to export a list of different-sized objects to a single Excel sheet. In other words, I'd like one matrix to show up, then below it, the next matrix. Here's a simple example using…
burchw78
  • 99
  • 9
4
votes
1 answer

R - Cannot install xlsxjars, 64-bit Windows but trying to load i386

I have been at this problem for far too long now, any help welcomed. I finally got rJava installed and loaded, and as part of it I installed the 64-bit JRE and JDK. R version 3.2.2, 64-bit, running on 64-bit Windows 7.Trying to install xlsxjars (for…
Watanake
  • 263
  • 3
  • 9
4
votes
2 answers

Using XLConnect to write data to excel template gives empty cell error

I am using the R package XLConnect to write data frames to an existing excel worksheet in an existing workbook. The excel workbook has a worksheet for the raw data, which I populate using writeWorksheet() in R, and another worksheet for the…
Archimeow
  • 240
  • 6
  • 14
4
votes
3 answers

editing particular cells of an Excel sheet

I have an Excel workbook of which I want to edit/fill some particular cells using R, without changing any of the formatting. So far I've tried XLConnect package and it seems it could do what I'm looking for, I just didn't find a way to do it. My…
runr
  • 1,142
  • 1
  • 9
  • 25
4
votes
1 answer

Getting numbers computed with formulas with XLConnect

I'd like to read the numbers in an Excel spreadsheet using the XLConnect package. My impression is that it fails to read the numbers which are computed inside Excel using a formula with a dollar sign. Is there a solution to this problem ?
PAC
  • 5,178
  • 8
  • 38
  • 62
3
votes
2 answers

How to efficiently import multiple excel tables located in one sheet into an R list?

Task I am trying to import tables situated in a single excel sheet into an R object as efficiently as possible (list will be fine, as I can take the rest of the calculations from there). Nuance The tables are actually excel ranges not excel tables,…
Vitali Avagyan
  • 1,193
  • 1
  • 7
  • 17
3
votes
4 answers

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 this work. The code I have been using is the following: library(XLConnect) # Read Excel Sheet excel <-…
Daniel Rawlings
  • 183
  • 1
  • 1
  • 8
3
votes
0 answers

Warnings in rJava installation on Ubuntu 16.04 32 bit, probably linked to XLConnectJars installation fail

When installing rJava, the install completes successfully, but there are loads and loads of warnings in the process. This is the first one: jri_glue.c: In function ‘PushToREXP’: jri_glue.c:24:15: warning: cast from pointer to integer of different…
geeeero
  • 31
  • 3
3
votes
3 answers

How can I stop a package from loading on startup in Rstudio

I have an Rstudio project that I've been working on. Since I last updated Rstudio to 1.0.143 - Mac OS X 10.6+ (64-bit) the project fails to start up. I think it might be linked to a package that was automatically loading on start-up and for whatever…
user2465805
  • 53
  • 1
  • 7
1
2
3
…
15 16