may be it is a bug: if a excel file is not containing headlines the first data row will not be imported Knut
Rcmdr Bug?
5 messages · Knut Krueger, Pascal Oettli, John Fox
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20130517/97f82384/attachment.pl>
Ein eingebundener Text mit undefiniertem Zeichensatz wurde abgetrennt. Name: nicht verf?gbar URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20130517/4bf7a898/attachment.pl>
Dear Knut, This is really more a limitation than a bug. Like most of the dialogs in the Rcmdr, the dialog to read Excel files uses existing facilities in R and R packages. I'll see whether it's possible to add an option to read a data set without variable names. The obvious workaround is to add a row of variable names to the spreadsheet. Best, John ------------------------------------------------ John Fox Sen. William McMaster Prof. of Social Statistics Department of Sociology McMaster University Hamilton, Ontario, Canada http://socserv.mcmaster.ca/jfox/ On Fri, 17 May 2013 07:40:51 +0200
Knut Krueger <rh at knut-krueger.de> wrote:
may be it is a bug: if a excel file is not containing headlines the first data row will not be imported Knut
______________________________________________ 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.
Am 17.05.2013 13:36, schrieb John Fox:
Dear Knut, This is really more a limitation than a bug. Like most of the dialogs in the Rcmdr, the dialog to read Excel files uses existing facilities in R and R packages. I'll see whether it's possible to add an option to read a data set without variable names. The obvious workaround is to add a row of variable names to the spreadsheet.
dear John, indeed I would never use an excel sheet without variable names ... but students do and then the statistics are wrong .... As I mentioned in the other answer it would be fine to add a hint that the first row is used as variable name ... for the students ;-) Knut