How to read data from excel file in Python

Python can be used to read data from an excel file. The module called xlrd is used to retrieve information from a spreadsheet.

Command to install xlrd module:

      pip install xlrd

A workbook contains the data in the Excel file.

Input file:

import xlrd

location = ("path of file")

#to open excel using open_workbook()
wb = xlrd.open_workbook(location)

# open a sheet using index
sheet = wb.sheet_by_index(0)

# open a sheet using name of the sheet
#print(sheet.sheet_by_name('name_of_sheet'))

# printing row 0 and column 0
print(sheet.cell_value(0, 0))

# printing row 0 and column 1
print(sheet.cell_value(0, 1))

Output:

NAME
AGE

author avatar
Python Point Team

You may also like

15 Powerful Step for Mastering JSON Parsing in Python: Boosting Data Manipulation and Validation
21 June, 2023

Introduction In the world of programming, data plays a crucial role, and managing it efficiently is of utmost importance. JSON (JavaScript Object Notation) has emerged as a popular data interchange format due to its simplicity and flexibility. In this article, …

Introduction to Transfer Learning with Python: A Practical Guide
31 December, 2022

Introduction: Definition of transfer learning Overview of how transfer learning works in the context of machine learning Why transfer learning is useful and important Section 1: Transfer learning in Python with Keras In this section, we will explore how to …

How to Check Type in Python
31 December, 2022

In this article, we will learn to check type in Python. The built-in function type() can be used to check the type of data in Python.

Subscribe
Notify of
0 Discussion
Inline Feedbacks
View all comments