Importing Excel files into R, xlsx or xls?

Question

What is the best way to import an excel 2007 (.xlsx) file into R? I keep receiving this error: Error in .jnew("java/io/FileInputStream", file) : java.io.FileNotFoundException: C:\\AB_DNA_Tag_Numbers.xlsx (The system cannot find the file specified).

Answer 1

It is telling the exact thing what the problem is i.e. the file not found. It basically means you are not giving the exact path to R (To tell it exactly the directory path where the file is stored, for example C/folder/my_file.xls )

try using readxl library in R, its very good at handling excel files.