similar to: Odd Results when using R's auto.arima function

Dear all, I cannot reading a .xlsm file using read.xls. I executed: read.xls("resultados.xlsm", colNames = TRUE, sheet = 1, type = "data.frame", from = 1, rowNames = NA, colClasses = "character", checkNames = TRUE, dateTime = "numeric", naStrings = NA, stringsAsFactors = F) Error: Call("ReadXls", file, colNames, sheet, type, from, rowNames, :

I have spent hours on R in Windows 7. Just installed 2 days ago so the R package should be current. Currently I am using the RGui (64-bit) for Windows. I can not read an Excel file into R from my computer. Have hours on this. Completely crazy!! I have the XLConnect package loaded. I think it is loaded because when I enter: > loadedNamespaces() [1] "base"

I have several hundred Excel 2007 data files in a folder. I would like to read every file in a single given folder using a loop. I have searched the FAQ, the forum archives here, other or older R boards and the R Import / Export documentation, and have asked some very knowledgeable R users without learning of a solution. I hope someone here can help. I understand that the most common

Buenas tardes usuarios de R. Estoy tratando de leer un archivo excel con read.xls usando la siguiente sentencia: read.xls("resultados.xlsm", colNames = TRUE, sheet = 1, type = "data.frame", from = 1, rowNames = NA, colClasses = "character", checkNames = TRUE, dateTime = "numeric", naStrings = NA, stringsAsFactors = F) Pero me da el siguiente error: Error

Hi to all. I have a problem to connect to an Excel database using RODBC. Namely, I am using 64-bit R 2.14.0, under Windows 7 and I tried following: library(RODBC) > channel <- odbcConnectExcel("results.xlsx") Error in odbcConnectExcel("results.xlsx") : odbcConnectExcel is only usable with 32-bit Windows # ok this is clear why it doesn't work > channel

Hi! I'm manipulating XLSX data using RODBC, however a limitation which appears to be driver based is that you can't clear or drop sheets from the XLSX files, as per the following example: > library(RODBC) > xlsx<-odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);DBQ=c:\\documents and settings\\desktop\\testxlsx.xlsx; ReadOnly=False") >

Dear R users, I hope you all are doing great. Is there a way to automatically upgrade my R 2.15.0 to the new R 2.15.2 release instead of having to reinstall the new release? Any information regarding this would be greatly appreciated. Best regards, Paul -- View this message in context: http://r.789695.n4.nabble.com/Updating-R-2-15-0-to-2-15-2-tp4647542.html Sent from the R help mailing

Hi, I would like to ask you how to read an arrary from an *.xlsm file? I have tried different packages such as xlsReadWrite and RODBC. Everything is performed on the final versions of addons and R. Additionally, when I tried the RODBC received the following error: > library(RODBC) > con = odbcConnectExcel("C:\\Temp.xlsm") Warning messages: 1: In odbcDriverConnect(con,

Hi Greetings to all Is my first post in this forum sorry for my english Many compliment to all developers for great work in Wine Profili2 is the most famous Windows software for designe airfoil profile for RC airplane models. Some times ago I have installed it in ubuntu 10.10 by Wine(1.3.5) with success This software use an mdb file First I have installed Profili download in this web site

sample report data that i want to forecast quarter quarter_index Revenue 2007 Q1 1 $3,856,799 2007 Q2 2 $4,243,328 2007 Q3 3 $4,930,369 2007 Q4 4 $5,443,579 2008 Q1 5 $5,164,830 2008 Q2 6 $5,104,413 2008 Q3 7

Hey Seniors, Really new to R, please has anyone imported a dataset from MS office excel 2007 into R yet? It seem to be giving me hard times which I did not expect as it use to go well with the previous versions. Thanks in advance. arnoldo --------------------------------- [[alternative HTML version deleted]]

sample report data that i want to forecast quarter quarter_index Revenue 2007 Q1 1 $3,856,799 2007 Q2 2 $4,243,328 2007 Q3 3 $4,930,369 2007 Q4 4 $5,443,579 2008 Q1 5 $5,164,830 2008 Q2 6 $5,104,413 2008 Q3 7

Hi, This is regarding the ARIMA model. I am having time series data of stock of 2000 values. Using the ARIMA model in R, I want the forcasted values for next 36 time points. However when I run this model in R, I am getting same value for all 36 time points. I have tried to fit the data with ARIMA model by changing the parameters p,d,q after looking at the errors and other criteria for

hi all , has anyone tried to predict a univariate time series by a neural networks packages ? please help me in this problem . I am new in R and I did not found any document that explains this problem. thanks in advance David [[alternative HTML version deleted]]

Dear R users, It is a pleasure for me to announce the availability of the new package kwb.hantush (0.2.1)? on CRAN. Its objective is the calculation of groundwater mounding beneath an (stormwater) infiltration basin by solving the Hantush (1967) equation. For checking the correct implementation of the algorithm the R modelling results were cross-checked against alternative models assessed in

Dear R users, It is a pleasure for me to announce the availability of the new package kwb.hantush (0.2.1)? on CRAN. Its objective is the calculation of groundwater mounding beneath an (stormwater) infiltration basin by solving the Hantush (1967) equation. For checking the correct implementation of the algorithm the R modelling results were cross-checked against alternative models assessed in

Hello R users, Hope everyone is doing great. I have a dataset that is in .csv format and consists of two columns: one named Period (which contains dates in the format yyyy_mm) and goes from 1995_10 to 2007_09 and the second column named pcumsdry which is a volumetric measure and has been formatted as numeric without any commas or decimals. I imported the dataset as pauldataset and made use of

Hola a todos.... cordial saludo... Como se podran dar cuenta en contados segundos, soy completamente novato en R.. .asi que mis excusas por adelantado debido a lo simple del requerimiento... Tengo un archivo con datos, el cual adjunto.... la idea es ordenar los mismos por columna, una junto a la otra, estacion por estacion... esto es, los datos estan ordenados una estacion debajo de la otra,

Hello everyone I moved my samba (3.6.9-168.el6_5) setup to new hardware and since the move a user can not write to the shared folders. When the file is opened by the user "smbstatus" shows: Locked files: Pid Uid DenyMode Access R/W Oplock SharePath Name Time

Dear R-users, I am facing a trivial problem when trying to parameterise the start date of a time series object. I am working with monthly data (104) performing n-steps-ahead (6) forecasts and using a fixed window size (36). At the end of calculations I have a list that contains 69 forecasts. I have no problems in fixing the window size by parametrization, e.g. k<- control variable in a for