ashz wrote on 08/23/2011 03:25:57 AM:
> 
> Hi,
> 
> I am using this script to read a xlsx file to a data frame:
> library(xlsx) 
> File <- file.path("d:", "car ", "car95-99.xlsx")
> B_car <- read.xlsx(File, "raw_data")
> Car2x <- data.frame(month = B_car$Date,Ch = B_car$Ch.des,
> lat=B_car$Latitude)
> 
> The last row in the data.frame is always NA, how can I remove it?
> 
> Thx.
> 

Sometimes there is an invisible something in a row of data in Excel ... a 
blank space, a formatting something, i don't know ... that causes this to 
happen.  Open the file in Excel, select the entire row (by clicking on the 
row number), right click for a menu, select "Delete", then save the file 
and try your R script again.  It might work.

Jean
	[[alternative HTML version deleted]]

