Dear community, I have now taken my R-file from lectures and intend to use it at home, but have a problem reading the Data from the file. I have installed and loaded the Package xlsReadWrite so far. I have also "Changed directory". This is what I have entered daten=read.xls("Daten A2") This is my Error-Message in its German original: Fehler in .Call("ReadXls", file, colNames, sheet, type, from, rowNames, : Falsche Anzahl von Argumenten (11), erwarte 10 f?r ReadXls This is my Error-Message in its english translation: Error in .Call("ReadXls", file, colNames, sheet, type, from, rowNames, : Wrong Number of Arguments (11), expect 10 for ReadXls Please help me in solving this problem. Without being able to read data, the programme renders pointless for me :-( Chers, Toby -- View this message in context: http://r.789695.n4.nabble.com/ReadWrite-xls-problem-tp3078348p3078348.html Sent from the R help mailing list archive at Nabble.com.
Hello tkdweber. I'm also annoyed at same problem. I installed xlsReadWriter today and entered x <- read.xls("data.xls",sheet=1) But I got Error Message: ?????? .Call("ReadXls", file, colNames, sheet, type, from, rowNames, : ?????(11)??????10 ?? ReadXls ????????? (It's Japanese.Its English translation is the same as yours) -- View this message in context: http://r.789695.n4.nabble.com/ReadWrite-xls-problem-tp3078348p3081459.html Sent from the R help mailing list archive at Nabble.com.
On Dec 8, 2010, at 15:52 , tkdweber wrote:> > Dear community, > > I have now taken my R-file from lectures and intend to use it at home, but > have a problem > reading the Data from the file. I have installed and loaded the Package > xlsReadWrite so far.xlsReadWrite is a contributed package with a complicated installation procedure. It has a maintainer and a website. Offhand I would guess that you haven't downloaded the proprietary DLL that goes with it, and maybe that the placeholder DLL has not been updated when the number of arguments was changed. Is there any good reason not to just use the save/load mechanism?> I have also "Changed directory". > > This is what I have entered > daten=read.xls("Daten A2") > > This is my Error-Message in its German original: > Fehler in .Call("ReadXls", file, colNames, sheet, type, from, rowNames, : > Falsche Anzahl von Argumenten (11), erwarte 10 f?r ReadXls > > This is my Error-Message in its english translation: > Error in .Call("ReadXls", file, colNames, sheet, type, from, rowNames, : > Wrong Number of Arguments (11), expect 10 for ReadXls > > Please help me in solving this problem. Without being able to read data, the > programme renders pointless for me :-( > > Chers, > Toby > -- > View this message in context: http://r.789695.n4.nabble.com/ReadWrite-xls-problem-tp3078348p3078348.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.-- Peter Dalgaard Center for Statistics, Copenhagen Business School Solbjerg Plads 3, 2000 Frederiksberg, Denmark Phone: (+45)38153501 Email: pd.mes at cbs.dk Priv: PDalgd at gmail.com
Toby, haruo0409, 2010/12/8 tkdweber <tkd.weber at gmail.com>:> This is my Error-Message in its German original: > Fehler in .Call("ReadXls", file, colNames, sheet, type, from, rowNames, ?: > ?Falsche Anzahl von Argumenten (11), erwarte 10 f?r ReadXlsThere was a wrong DLL for a short while in the old 1.5.2 version (I fixed a R2.12.0 related issue and unfortunately introduced this error). If you delete the old xlsReadWrite package and re-install the package (either from CRAN or see www.swissr.org/download) it really should work. 2010/12/10 haruo0409 <eixcxisx at bca.bai.ne.jp>:> I'm also annoyed at same problem. > I installed xlsReadWriter today and entered > x <- read.xls("data.xls",sheet=1) > But I got Error Message: > ?????? .Call("ReadXls", file, colNames, sheet, type, from, rowNames, : > ?????(11)??????10 ?? ReadXls ????????? > (It's Japanese.Its English translation is the same as yours)What's the 'library(xlsReadWrite)' startup message? For the current version it should be: 'xlsReadWrite version 1.5.3 (0b78c1)'. Could you please give more details about 'I installed xlsReadWriter today' (which CRAN mirror, 'R.version' and '.Platform' output, is there only one 'xlsReadWrite.dll' file on your system). It is supposed to work and I am unable to find any problem. Thanks a lot! 2010/12/8 tkdweber <tkd.weber at gmail.com>:>Without being able to read data, the > programme renders pointless for me :-(There are many ways to read/write data in R: * Other than load/save you could use read.table/write.table (see R Data Import/Export). * Using Excel files is not the recommended way. However when you want/need it, there are several options (see http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows) Cheers, Hans-Peter PS. not that I mind to discuss things here, but as these are package specific problems I'd suggest to switch to the xlsReadWrite forum (http://dev.swissr.org/projects/xlsreadwrite/boards). You also can create an issue (http://dev.swissr.org/projects/xlsreadwrite/issues/new) or just send an email to 'support' at 'swissr.org').