[R] Error on reading an excel file

butter jp at joepking.com
Tue Nov 17 04:25:11 CET 2009


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.




More information about the R-help mailing list