Stack Overflow
Stack Overflow

Questions tagged [readxl]

an R package that can be used to import Excel (.xls and .xlsx) files into R

The readxl package can be used to import Excel (.xls and .xlsx) files into R. It has no external dependencies (the libxls C library is embedded) and works on Windows, Mac, and Linux.

Resources

257 questions
0
votes
2 answers

How to import multi-file .xlsx data into single R dataframe without levels?

I'm trying to extract each company's data from some free NASDAQ 100 Twitter data sets available here. The ultimate goal, once constructed and curated, is to run some modeling experiments with the dataframe. The basic dataframe form I'm aiming for…
xq1515426
  • 79
  • 7
0
votes
0 answers

Can't import .xlsx into R using readxl

Here's my code: library(readxl) datasets <- system.file("C:/Users/tyeg/Documents/Gamma Counter Processing/Inflammation/Study Compilation Sheet2.xlsx", package = "readxl") read_excel(datasets) Here's the error I get: '' does not exist in current…
G.T.
  • 642
  • 1
  • 5
  • 22
0
votes
1 answer

Detect a row that contain names

I need to detect if my first row of observations is a row of names. Always when I import the data are imported as character columns from the spreasheet (readxl package). By the structure of the data, a non-name row, always contain at least 8 numeric…
Cristóbal Alcázar
  • 971
  • 10
  • 23
0
votes
1 answer

read_excel recode number as na value

While importing data from an excel file using the read_excel function in the readxl package, I have tried specifying a number for the na argument but it does not recode the missing values. The data was entered with a numeric value as the missing…
Andrew Jackson
  • 733
  • 9
  • 21
0
votes
2 answers

Removing all columns with a name on the fly

I'm using read_excel for speed and simplicity to import an Excel file. Unfortunately, there's as yet no capability of excluding selected columns which won't be needed from the data set; to save effort, I am naming such columns "x" with the col_names…
MichaelChirico
  • 31,197
  • 13
  • 98
  • 169
0
votes
1 answer

Import tabbed spreadsheet into list in R

My data exists as a tabbed spreadsheet, and I'm trying to write a script to import it. library(readxl) oput <- 0 tabnames <- excel_sheets("dataset.xlsx") for(x in seq_along(tabnames)){ assign(tabnames[x], read_excel("dataset.xlsx", sheet =…
Trent
  • 55
  • 1
  • 8
0
votes
0 answers

how to read Excel sheet's tab names in R?

How can one load an Excel file to R with all its tab names? I am using the readxl package currently for reading Excel but can't figure out how to save its tab names? E.g., abc = read_excel("Saudi Diapers.xlsx", 1, col_names = T) Here I have…
Ankit Bhatia
  • 99
  • 1
  • 1
  • 5
0
votes
0 answers

R readxl read_excel() and 1/1/1900 0:00

Using read_excel() from the readxl package to read in a spreadsheet that has a column of dates I see upon inspection numerous "1899-12-31 00:00:00 UTC". These correspond to the "1/1/1900 0:00" which I see from inside Excel. Should I be concerned…
Kerry
  • 371
  • 3
  • 12
-1
votes
2 answers

How do I import data via code in R (Instead of using the import in the menu bar) from code typed into an R notebook?

Every time I type in the file name in this case "labelled edited.xlsx" (perfectly - it was copied from the import box when using the import function from the menu into an R notebook), then try to run it, it says 'Error: path does not exist'. However…
codingnewbie
  • 23
  • 5
-1
votes
1 answer

Back to line in a doc.DXL?

I am using IBM Domino Designer 9.0 and i have a problem with the DXL . How to return to line in a doc.DXL (that I created)? I tried with \ n and <\ br> but it does not work . So plz some help . Code Button : Sub Click(Source As Button) Dim…
NAFES
  • 1
  • 2
-1
votes
1 answer

Self-defined function doesn't output data to environment?

I'm trying to create a small function to help read data from an excel spreadsheet hosted online. read2014 <- function(urlhere, filename){ url <- urlhere destfile <- filename curl::curl_download(url, destfile) filename <-…
user126082
  • 310
  • 2
  • 9
-1
votes
1 answer

How do I enforce a global column-type using excel_sheet?

I am importing several datasets that needs to be bind_rows() afterwards. For this reason, I would like set a global column type for every column of the tbl_df that results from running excel_sheet() function. The reason is that different column…
Dambo
  • 2,845
  • 3
  • 24
  • 57
-2
votes
2 answers

Extract data from specific cells in multiple excel files - R

I need to extract data (date, time) from two cells (E6:E7) from multiple excel files and then store that data into a data frame (with separate columns for date and time). See below for the code I've tried. setwd("C:/Users/tsamuels/Desktop/PDRA -…
Toby Samuels
  • 1
  • 1
-2
votes
1 answer

using Rstudio, how to import xlsx file larger than 100MB?

How to work with excel file larger than 100 MB, I already imported but it doesn't running the shiny app?
David Adams
  • 115
  • 7
-2
votes
1 answer

can't extract module's Version DXL IBM DOORS

I'm working on a DXL program in Doors which supposed to output to a csv file all of source module, target, linkset and version of each (source/target) modules. I've succeed to output "source module, target, linkset but I couldn't extract the version…
loubna bammou
  • 1
1 2 3
…
17
18