[R] Importing an Excel file

Adaikalavan Ramasamy ramasamy at cancer.org.uk
Wed Jul 7 20:47:46 CEST 2004

Are all you data numerical or does it contain characters as well ?

Check for the common culprits - the hash (#) which is the comment
character in R, unbalanced single and double quotes and other suspicious
characters around line 16 and in general.

If that does not work, open in Excel and just delete all the unwanted
columns (and rows) even if they appear empty. Then save as csv and try

read.delim() will not work properly in your case because it recognises
tab as separator.

On Wed, 2004-07-07 at 19:21, Park, Kyong H Mr. RDECOM wrote:
> Hello, R users,
> I am  a very beginner of R and tried read.csv to import an excel file after
> saving an excel file as csv. But it added alternating rows of fictitious NA
> values after row number 16. When I applied read.delim, there were trailing
> several commas at the end of each row after row number 16 instead of NA
> values. Appreciate your help. 
> Kyong
> 	[[alternative HTML version deleted]]
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

More information about the R-help mailing list