• Offers
    • RegisterLogin
      • Learn More
    PythonPoint.netPythonPoint.net
    • Offers
    • RegisterLogin
      • Learn More

      Python

      SKILL IS IMPORTANT THAN DEGREE Be skill full.
      • Home
      • Blog
      • Python
      • How to read xlsx file in python?

      How to read xlsx file in python?

      • Posted by Python Point Team
      • Categories Python
      • Date November 16, 2020
      • Comments 0 comment

      XLSX file popularly known as Excel file is a spreadsheet which makes us easy to store data in a tabular form. Now the question is that how can we read data from the excel file while writing a python program?

      Firstly, we have to install xlrd module.

      syntax:-

      pip install xlrd

      Now we can read the data in xlsx file by importing xlrd in python.

      syntax:-

      import xlrd
      location_of_file=("path of file")
      a=xlrd.open(location_of_file)
      print(a)

      In this way we can read xlsx file by importing xlrd.

      We can also print data of a particular row or column.

      syntax:-

      import xlrd 
      location_of_file=("path of file")
      a=xlrd.open(location_of_file)
      sheet_name.column_value(0,0)
      print(sheet_name.column_value(0,0))

      We have one more method to read xlsx file without xlrd.

      We can import pandas and read an xlsx file.

      syntax:-

      import pandas as pd
      data=pd.read_excel("file.xlsx", file_name='Sheet1')
      print(data)

      We can also read a data of a particular column or row by using pandas module.

      syntax:-

      import pandas as pd
      data=pd.read_excel('location_of_file')
      d=pd.dataframe(data, column['column_name'])
      print(d)

      We can also retrieve data of rows by calling their name as we did in columns.

      This is all about reading data from a xlsx file in python.

      • Share:
      author avatar
      Python Point Team

      Previous post

      How to install speech recognition in python?
      November 16, 2020

      Next post

      How to import numpy in python?
      November 16, 2020

      You may also like

      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.

      How to make web crawler in python?
      31 December, 2022

      A web crawler is a systematic, well-defined process of extracting specific data about a topic. We have a library named as scrapy which helps in making web crawler. We can install scrapy by the following command:- Now we can easily …

      Subscribe
      Login
      Notify of
      Please login to comment
      0 Discussion
      Inline Feedbacks
      View all comments

      Latest Courses

      (Hindi) Ways to earn minimum 1 Lakh Per month as Programmer

      (Hindi) Ways to earn minimum 1 Lakh Per month as Programmer

      ₹10,000
      (HINDI) Full Stack Web Development In Python 3.8 And Django 3.1

      (HINDI) Full Stack Web Development In Python 3.8 And Django 3.1

      ₹25,000 ₹2,500

      Latest Posts

      • Introduction to Transfer Learning with Python: A Practical Guide
      • How to Check Type in Python
      • How to make web crawler in python?
      • Why was the language called “python”?
      • Why Python is so Popular
      Contact
      •   support@pythonpoint.com

      We get you the best Python Courses and Blogs aiming to provide skill.

      We Believe Skill is much more important than a Degree

      Company
      • About Us
      • Blog
      • Offers
      • Contact
      Useful Links
      • Courses
      Support
      • Need Support

      © 2020 ALL RIGHTS RESERVED​ PYTHONPOINT.NET

      PythonPoint

      • Terms of Use
      • Refund Policy
      • Privacy Policy

      Login with your site account

      Lost your password?

      Not a member yet? Register now

      Register a new account

      Are you a member? Login now

      wpDiscuz