R : Reading xlsx sheet data

Step 1: Install xlsx package

Open R console and type following command.

install.packages("xlsx")

Step 2: Load the package

library(xlsx)

Step 3: Use the following command to read xls sheet.

> read.xlsx("names.xlsx", sheetIndex=1)
  firstName lastName
1    Tushar      abc
2     Sunil    Kumar
3   Sankalp    Dubey
4   Phalgun Garimela

Prevoius                                                 Next                                                 Home