Re: [R] readxl issue

2020-02-05 Thread Abby Spurdle
> I'm using readxl and dplyr to extract a specific cell from all worksheets in > a directory. > All of these worksheets have the same physical layout. I don't have access to Excel, so can't test this. I have a suspicion that the problem is not readxl. But rather the "as.data.frame" step. Try re

Re: [R] readxl issue

2020-02-05 Thread Thomas Subia
e read_csv applies here. Thanks for your help! Thomas Subia -Original Message- From: Jeff Newmiller Sent: Wednesday, February 05, 2020 11:42 AM To: r-help@r-project.org; Thomas Subia ; r-help@r-project.org Subject: Re: [R] readxl issue Pay attention to whether the read_csv call is conf

Re: [R] readxl issue

2020-02-05 Thread Jeff Newmiller
Pay attention to whether the read_csv call is configured to expect first line as header. On February 5, 2020 11:09:01 AM PST, Thomas Subia wrote: >Colleagues, > >I'm using readxl and dplyr to extract a specific cell from all >worksheets in a directory. >All of these worksheets have the same phy

[R] readxl issue

2020-02-05 Thread Thomas Subia
Colleagues, I'm using readxl and dplyr to extract a specific cell from all worksheets in a directory. All of these worksheets have the same physical layout. Issue 1: Minus sign replaced by an X after data extraction. library(plyr) library(readxl) files <- list.files(pattern="*.xls", full.names