How to read multiple Excel files in R

How to read password protected excel file in R ?

Last Updated : 18 Jul, 2021

In this article, we are going to see how to read password-protected Excel files in R programming language.

File in use: file

Method 1: Using excel.link Package.

Here we will use excel.link package to read the file with a password.

Installation:

install.packages(“excel.link”)

xl.read.file() function is used to read Excel files in R programming.

Syntax:

xl.read.file( “file_name”, password = “pass”)

Example 1:

R

# import lib 
library("excel.link") 
  
# read file with pass 
df <- xl.read.file("data.xlsx", password = "gfg@123") 
  
# display df 
head(df)

Output:

The same module can be used to first unlock the file and then copy its contents onto another so that it can be accessed again without any password. Here we save the file with a password NULL value and save it to another file.

Syntax:

xl.save.file( file.object, “New_file”, password = NULL , write.res.password = NULL)

Program:

R

# import lib 
library("excel.link") 
  
# read file with pass 
df <- xl.read.file("data.xlsx", password = "gfg@123") 
  
# save the df into new file 
xl.save.file(df, "Output.xlsx", password = NULL, 
             write.res.password = NULL) 
  
# read file without any password 
df1 <- xl.read.file("Output.xlsx") 
  
head(df)

Output:

Method 2: Using XLConnect package.

Here we will use XLConnect package to read the password-protected file. This package provides comprehensive functionality to read, write and format Excel data.

loadWorkbook() function loads Microsoft Excel workbooks.

Syntax:

loadWorkbook(filename , password )

readWorksheet() function reads data from worksheets.

Syntax: readWorksheet( object, sheet).

Parameters:

Object: The ‘>workbook to use

Sheet: The name or index of the worksheet to read from

Program:

R

# import lib 
library(XLConnect) 
  
# load the file 
workbook <- loadWorkbook("data.xlsx", password = "gfg@123") 
  
# read the object 
df <- readWorksheet(workbook, "sheet1") 
  
# display df 
head(df)

Output:

How to read multiple Excel files in R

kumar_satyam

Improve

Article Tags :

Similar Reads

How to read excel file in R ?

We may work with structured data from spreadsheets, take advantage of R's capabilities for data analysis and manipulation, and incorporate Excel data into other R processes and packages by reading Excel files in R. The readxl package offers a simple and effective method for reading Excel files into

How to Create a Password Protected ZIP File in Linux?

Linux provides Zip command to work with a file like compressing the file and decompressing with a password. It's not come with built-in you need to install from an external source. The Zip command has two different utility(zip and unzip). zip is used for compressing the file and unzip is used for de

How to read multiple Excel files in R

In this article, we will discuss how to merge multiple Excel files in the R programming language. Modules Used:dplyr: The dplyr package in R is a structure of data manipulation that provides a uniform set of verbs, helping to resolve the most frequent data manipulation hurdles.plyr: The â€œplyrâ€ packa

How to Password Protect Your Excel Macro?

It is a best practice, to protect the Macro (VBA Code) from other users to edit or view. In this article, we explain to create a simple macro and protect the same "VBA Project" using a password in Excel from other users. Implementation: Follow the below steps to protect your excel macro with a passw

How to Read Large JSON file in R

First, it is important to understand that JSON (JavaScript Object Notation), is a lightweight data-interchange format that is easy for humans to read and write and easy for machines to parse and generate. JSON files are often used for data transmission between a server and a web application and can

How to Protect Sheet in Excel

How to Protect a Sheet in Excel- Quick Steps Right Click on the Worksheet Tab Select Protect Sheet >>Enter Password Select the Actions you want to allow the UsersClick OkWhen working with sensitive or shared data in Excel, ensuring the security of specific sheets is essential. Excel sheet prot

How to Crack Excel File Password?

Have you ever found yourself locked out of an important Excel spreadsheet, desperately needing access to crucial data? Whether you've forgotten the password or inherited a file with restricted access, learning how to crack Excel file passwords can be a lifesaver. This article will walk you through e

How to read JSON files in R

JSON (JavaScript Object Notation) is a lightweight data-interchange format that is easy to read for humans as well as machines to parse and generate. It's widely used for APIs, web services and data storage. A JSON structure looks like this: { "name": "John", "age": 30, "city": "New York"} JSON data

How to import an Excel File into R ?

In this article, we will discuss how to import an excel file in the R Programming Language. There two different types of approaches to import the excel file into the R programming language and those are discussed properly below. File in use: Method 1: Using read_excel() In this approach to import th

How to import an Excel file into Rmarkdown?

In this article, we are going to learn how to import excel file into Rmarkdown in R programming language. Excel file is a file where the data is stored in the form of rows and columns. The R markdown is a file where we can embed the code and its documentation in the same file and are able to knit it