i have used excel almost exclusively to import data files and CSV is fine. why dont you just go to the bottom of the excel sheet after you convert to CSV and clean out the last rows, delete the end rows. also maybe try another spread sheet program like open office, openoffice.org.
cls59 wrote: > > > > Gabor Grothendieck wrote: >> >> That doesn't necessarily follow since the various methods don't use >> Excel itself to create the csv file. >> > > I was trying to point out cases where I have seen this behavior and R > wasn't involved. Now that I think about it, I have observed to blank > cells in a Google Docs spreadsheets that were created from .xls files. > > My point is that Excel, not R, may be the common denominator in this > problem. > > -Charlie > -- View this message in context: http://old.nabble.com/Error-on-reading-an-excel-file-tp26371750p26383821.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ 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.