On Dec 10, 2010, at 5:02 PM, David Winsemius wrote:


On Dec 10, 2010, at 4:39 PM, Patrick McKann wrote:

Hello all,
I don't understand why this won't work.  I have entered:

WriteXLS(alldata,'test.xls')

I have gotten tripped up by the argument syntax in WriteXLS myself, many times. Please check the help page for argument names and use them, especially paying attention to the fact that the first argument needs to be a character _vector_ (and I suspect that passing it a list may not qualify) and I always use the name for the Excel file argument. I suspect that this may work:

WriteXLS('alldata','test.xls')

OOOPs. I wrote that before I noted that you said you were using a list, and I forgot to go back and fix it, so that would NOT work.

--
David.


and I get this error message:

Error in get(x, envir = envir) : variable names are limited to 256 bytes.

My variable names are not very long, and are accepted by write.csv.

alldata is a list containing 4 dataframes, with each dataframe having the
the same variable names, which are:

names(avg8302)
[1] "ID"            "cluster"       "rec.unit"      "int.hib"
"yr.hib"        "yr0309.hib"    "int.hib.se"    "yr.hib.se"     "
yr0309.hib.se" "int.cl"
[11] "yr.cl" "yr0309.cl" "int.cl.se" "yr.cl.se" " yr0309.cl.se" "int.ru" "yr.ru" "yr0309.ru" "int.ru.se"
"yr.ru.se"
[21] "yr0309.ru.se" "int.sp" "yr.sp" "yr0309.sp" "
int.sp.se"     "yr.sp.se"      "yr0309.sp.se"


Does anybody know how I can fix this? Or another way to write a multi-sheet
xls?

Thank you.

        [[alternative HTML version deleted]]

______________________________________________
R-help@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.

David Winsemius, MD
West Hartford, CT

______________________________________________
R-help@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.

David Winsemius, MD
West Hartford, CT

______________________________________________
R-help@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.

Reply via email to