When running read_xlsx() in my normal .R script, I'm able to read in the data. But when running the .R script with source() in R Markdown, it suddenly takes a long time (> 20+++ mins I always te...

currently I am preparing an R-lesson for a customer. We want to read in data from a password protected xlsx file. Thus, I am trying to read this password protected xlsx file into R (unprotecting th...

I ran a Rshiny app and it works as expected but in console I get the following message: New names: * `` -> `..18` what does it mean? It occurs when I try to do this > data1<-read_exce...

is there a way to read an open excel file into R? When an excel file is open in Excel, Excel puts a lock on the file, such as the reading method in R cannot access the file. Can you circumvent this...

I am using R with readxl package. I try to import an Excel file with the following command: library(readxl) city_codes <- read_excel("./data/file.xlsx", sheet = "city_codes") It says it is a ...

I have multiple .xls (~100MB) files from which I would like to load multiple sheets (from each) into R as a dataframe. I have tried various functions, such as xlsx::xlsx2 and XLConnect::readWorkshe...

Consider a file on the internet (like this one (note the s in https) https://evs.nci.nih.gov/ftp1/CDISC/SDTM/SDTM%20Terminology.xls How can the sheet 2 of the file be read into R? The following c...

I have a excel file like this: I try to read it in read.xlsx or read_excel by skipping the second row: library(xlsx) df <- read.xlsx('./data.xls', 'Sheet1') library(readxl) df <- read_excel...

I am trying to link up my excel data set to R for statistical analysis. I am running on OSX Sierra (10.12.6) with R studio (1.0.153) and Java 8 (update 144). The function "read_excel" was able to...

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...

How can I import data from a .xlsx file into R so that numbers are represented as numbers, when their original decimal separator is comma not a dot? The only package I know of, when dealing with e...

I'm getting really slow read times using read_excel on a particular machine with a particular xlsm file. Reading the same xlsm file across 2 different machines I get read times of 72 seconds versus...

When I read any of the sheets from the file Posti-Letto-Istat.xls with read_excel from the readxl package I have no problems: library(readxl) pl_istat1 <- read_excel(path = "data/Posti-Letto-Is...

I have been reading up on how to read and combine multiple xlsx files into one R data frame and have come across some very good suggestions like, How to read multiple xlsx file in R using loop with...

My questions are: What is the fastest way to read large(ish) .xlsx Excel files into R? 10 to 200 MB xlsx files, with multiple sheets. Can some kind of parallel processing be used, e.g. each core ...

I have been given an excel spreadsheet: column names are in the first row, garbage text is in the second row, and the actual data begins in the third row. I want to use the readxl package to read t...

What I'm trying to do is exactly like what NSaunder's blog has done: Change a coloured cell in Excell into a category. However, I am using the readxl package whereas NSaunder's post uses the xlsx p...

I have a 26 mb excel workbook to which I am trying to add a 42 kb worksheet. Using the openxlsx package, I have the following code: wb_object <- loadWorkbook(to_name2) addWorksheet(wb_object, "...

I'm importing xlsx 2007 tables into R 3.2.1patched using package readxl 0.1.0 under Windows 7 64. The tables' size is on the order of 25,000 rows by 200 columns. Function read_excel() works a trea...

I have date in Excel as follows, first col1 as char and from col2 to col5 is in date format (mm/dd/yyyy) id 1/1/2016 2/1/2016 3/1/2016 4/1/2016 5/1/2016 1 23 545 33 55 66 2 454 536 66 80 11 3 83 5...