R help - Dec 2010 - WriteXLS error:Error in get(x, envir = envir) : variable names are limited to 256 bytes

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

WriteXLS(alldata,'test.xls')

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

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')

-- 
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 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.
David Winsemius, MD
West Hartford, CT