[R] read.xls - ampersand different in XLS and XLSX

Hi All, I'm using read.xls from GDATA and it seems to be treating ampersands differently depending on whether the source file is an XLS or the more current XLSX. Ampersands from an XLSX become amp;. As a test I have a csv: write.csv(data.frame(a=c(JERRY, DICK LINDA)), ampersand.csv,

Re: [R] read.xls - ampersand different in XLS and XLSX

is an XML entity Excel 2007 onwards are XML aware. If your worksheet does not exceed 65536 rows by 256 columns, the easiest solution is to open the XLSX file and save it in XLS format. __ R-help@r-project.org mailing list