pardon me it was my function which is just a call to "readWorksheetFromFile"
Jim Holtman
Data Munger Guru
What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.
On Fri, Mar 27, 2015 at 3:52 PM, Benjamin Baker wrote:
> Jim,
>
> I’m not seeing
Jim,
I’m not seeing the command f.readXLSheet in the documentation, nor is it
executing in my code.
—
Sent from Mailbox
On Thursday, Mar 26, 2015 at 5:15 AM, jim holtman , wrote:
My suggestion is to use XLConnect to read the file:
> x <-
> "C:\\Users\\jh52822\\AppData\\Local\\
Jim,
Thanks, XLConnect with proper syntax works great for both types of files.
—
Sent from Mailbox
On Thu, Mar 26, 2015 at 5:15 AM, jim holtman wrote:
> My suggestion is to use XLConnect to read the file:
>> x <-
> "C:\\Users\\jh52822\\AppData\\Local\\Temp\\Rtmp6nVgFC\\file385c632aba3.xls"
Anthony,
XLSX won’t read an XLS file. Additionally, the legacy Java that is required for
the xlsx package really effs up my computer. Have to reinstall my OS to fix it.
—
Sent from Mailbox
On Wed, Mar 25, 2015 at 3:51 PM, Anthony Damico
wrote:
> maybe
> library(xlsx)
> tf <- tempfile()
My suggestion is to use XLConnect to read the file:
> x <-
"C:\\Users\\jh52822\\AppData\\Local\\Temp\\Rtmp6nVgFC\\file385c632aba3.xls"
> require(XLConnect)
Loading required package: XLConnect
Loading required package: XLConnectJars
XLConnect 0.2-10 by Mirai Solutions GmbH [aut],
Martin Studer [
maybe
library(xlsx)
tf <- tempfile()
ami <- "
http://www.ferc.gov/industries/electric/indus-act/demand-response/2008/survey/ami_survey_responses.xls
"
download.file( ami , tf , mode = 'wb' )
ami.data2008 <- read.xlsx( tf , sheetIndex = 1 )
On Wed, Mar 25, 2015 at 5:01 PM, Benjamin Baker wrot
Trying to read and clean up the FERC data on Advanced Metering infrastructure.
Of course it is in XLS for the first two survey years and then converts to XLSX
for the final two. Bad enough that it is all in excel, they had to change the
survey design and data format as well. Still, I’m sorting t
7 matches
Mail list logo
