Importing Excel files into R xlsx or xls

Question

Please can someone help me on the best way to import an excel 2007 (.xlsx) file into R. I have tried several methods and none seems to work. I have upgraded to 2.13.1, windows XP, xlsx 0.3.0, I don't know why the error keeps coming up. I tried:

AB<-read.xlsx("C:/AB_DNA_Tag_Numbers.xlsx","DNA_Tag_Numbers")

OR

AB<-read.xlsx("C:/AB_DNA_Tag_Numbers.xlsx",1)

but I get the error:

 Error in .jnew("java/io/FileInputStream", file) : 
  java.io.FileNotFoundException: C:\AB_DNA_Tag_Numbers.xlsx (The system cannot find the file specified)

Thank you.

Answer 1

To get started, here's a template for importing an Excel file into R:

library("readxl")

read from excel ("Path where your Excel file is stored\\File Name.xlsx")

You can also use this template if you want to import a specific sheet from an Excel file.

library("readxl")
read_excel("Path where your Excel file is stored\\File Name.xlsx",sheet = "Your sheet name") 

Importing an Excel file into R: A Step-By-Step Guide
The readxl package must be installed first. To install the readxl package in the R Console, run the following command: install.packages("readxl")... install.packages("readxl") install.packages("readxl")
Step 2: Make a spreadsheet in Excel. Assume you have an Excel spreadsheet with product information:...
Step 3: Open R and open the Excel file.