search for: xlsm

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 en .Call("ReadXls", file, colNames...

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(&quo...

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

...files in additional formats other than Excel 2007. I can read three Excel 2007 files one at a time with the following example code using R 2.10.0 on a computer running Windows (XP, I think): library(RODBC) channel <- odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb); DBQ=U:\\test folder\\testA.xlsx; ReadOnly=False") sqlTables(channel) my.data.A <- sqlFetch(channel, "Sheet1") odbcClose(channel) channel <- odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb); DBQ=U:\\test folder\\testB.xlsx;...

..." > list.files() [1] "~$ R OG SBCD 1205 MH1.docx" "~WRL2121.tmp" [3] "01 R OG SBCD 1205 MH1 BU1.docx" "01 R OG SBCD 1205 MH1.docx" [5] "01 R OG SBCD 1205v01 BU2" "Dta1.txt" [7] "Gas Dly YTD1204 v01 BU.xlsm" "Gas Dly YTD1204 v01.xlsm" [9] "Oil Dly YTD1204 v01 BU.xlsm" "Oil Dly YTD1204 v01.xlsm" [11] "Oil Dly YTD1204 v01.xlsx" "R OG SBCD 1205v01 sCt.lnk" [13] "R setwd to C Prog R sCt OtDt.lnk" So apparently "...

...t negative. What could be causing those forecasted values to be negative? Could this be a bug of the auto.arima function? Is there any other function (apart from auto.arima) that I could use for automatic model fitting to forecast? http://r.789695.n4.nabble.com/file/n4638683/TestAutoArimaFunction.xlsm TestAutoArimaFunction.xlsm Any help will be greatly appreciated, Regards, Paul -- View this message in context: http://r.789695.n4.nabble.com/Odd-Results-when-using-R-s-auto-arima-function-tp4638683.html Sent from the R help mailing list archive at Nabble.com.

...iles "Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx)" MS Access Database "Microsoft Access Driver (*.mdb, *.accdb)" Excel file "Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)" * results* "Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)" and tried again but it doesn't work: > channel <- odbcDriverConnect() Warning messages: 1: In odbcDriverConnect() : [RODBC] ERROR: state IM014,...

...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") > sqlClear(xlsx,"newsheet2",errors=TRUE) [1] "[RODBC] ERROR: Could not SQLExecDirect" [2] "HY000?Þêÿÿ\003 -5410 [Microsoft][ODBC Excel Driver] Deleting data in a linked table is not s...

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

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

...following questions: - How do I perform model runs ? - How accurate is the solution of the Hantush equation implemented in R compared to the a reference model (e.g. U.S. Geological Survey EXCEL spreadsheet solution, http://pubs.usgs.gov/sir/2010/5102/support/Hantush_USGS_SIR_2010-5102-1110.xlsm) ? I hope it proves to be useful and community feedback is therefore very welcome! Best Regards, Michael Rustler -------------------------------------------- Dipl.-Geo?k. Michael Rustler KompetenzZentrum Wasser Berlin gGmbH Cicerostr. 24 D-10709 Berlin Tel. +49 (0)30 53653 825 Fax +49 (0)30 536...

...following questions: - How do I perform model runs ? - How accurate is the solution of the Hantush equation implemented in R compared to the a reference model (e.g. U.S. Geological Survey EXCEL spreadsheet solution, http://pubs.usgs.gov/sir/2010/5102/support/Hantush_USGS_SIR_2010-5102-1110.xlsm) ? I hope it proves to be useful and community feedback is therefore very welcome! Best Regards, Michael Rustler -------------------------------------------- Dipl.-Geo?k. Michael Rustler KompetenzZentrum Wasser Berlin gGmbH Cicerostr. 24 D-10709 Berlin Tel. +49 (0)30 53653 825 Fax +49 (0)30 536...

...opez97 en yahoo.com ------------ próxima parte ------------ Se ha borrado un adjunto en formato HTML... URL: <https://stat.ethz.ch/pipermail/r-help-es/attachments/20130719/12236979/attachment-0001.html> ------------ próxima parte ------------ A non-text attachment was scrubbed... Name: PARA-R.xlsm Type: application/octet-stream Size: 99788 bytes Desc: no disponible URL: <https://stat.ethz.ch/pipermail/r-help-es/attachments/20130719/12236979/attachment-0001.obj>

...------------------------------------------------ 1772 2882 DENY_NONE 0x100081 RDONLY NONE /d/OfficeDrive/u/shared Finance etc Mon Jun 23 11:59:29 2014 1772 2882 DENY_WRITE 0x2019f RDWR NONE /d/OfficeDrive/u/shared Finance etc/POS.xlsm Mon Jun 23 11:59:56 2014 1772 2882 DENY_NONE 0x100081 RDONLY NONE /d/OfficeDrive/u/shared . Mon Jun 23 12:00:11 2014 The user opens an excel file and gets the message that the file is read only, and that he needs to click 'enable editing'. Editing is...

hello everyone, Any idea how can i export a resultset from a database to a CSV or XLS file from the application ? would like the user to have the option to export selected data to a CSV/XLS file. Any plugins or libraries avaiable to accomplish this ? Thanks for your time, VASU. -- Posted via http://www.ruby-forum.com/.