Importing Excel files into R xlsx or xls

0 votes

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.

Mar 25 in Database by Edureka
• 13,640 points
37 views

1 answer to this question.

0 votes

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.

answered Mar 30 by gaurav
• 13,560 points

Related Questions In Database

0 votes
1 answer

How do I split a cell in Excel into two or more where they are divided horizontally?

Table cells should be combined. To make a ...READ MORE

answered Apr 6 in Database by gaurav
• 13,560 points
44 views
0 votes
1 answer

Merging Two excel files as two sheets in one workbook in java

Basically for this, you need to create ...READ MORE

answered Feb 21 in Database by gaurav
• 13,560 points
42 views
0 votes
1 answer

Importing notepad data to excel (difficult split)

Excel: How to Use It On the Data ...READ MORE

answered Mar 14 in Database by gaurav
• 13,560 points
28 views
0 votes
0 answers

Merging Two excel files as two sheets in one workbook in java

I have two xlsx files at folder ...READ MORE

Mar 10 in Database by Edureka
• 13,640 points
84 views
0 votes
1 answer

How to Export Tally Data programmatically to CSV or Excel format

Open data (Ledger/P&L or Balance Sheet) that ...READ MORE

answered Mar 15 in Database by gaurav
• 13,560 points
110 views
0 votes
1 answer

Sigma or Summation function in Excel

The SUM function in Excel is another ...READ MORE

answered Mar 15 in Database by gaurav
• 13,560 points
45 views
0 votes
1 answer

How to convert a column number (e.g. 127) into an Excel column (e.g. AA)

If anyone needs to do this in ...READ MORE

answered Mar 30 in Database by gaurav
• 13,560 points
34 views
0 votes
1 answer

Converting xlsx to xls using Microsoft Office Compitablity Pack's excelcnv

Simply rearranging the positions of the parameters ...READ MORE

answered Mar 25 in Data Science by gaurav
• 13,560 points
81 views
0 votes
1 answer

Unable to compress excel file (XLSX or XLS) using java

Because the formats with a 'x' at ...READ MORE

answered Apr 11 in Database by gaurav
• 13,560 points
173 views
0 votes
1 answer

Merge excel files into a new excel file based on filename

How do I merge Excel files that ...READ MORE

answered Mar 31 in Database by gaurav
• 13,560 points
74 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP