• 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

      “not in” belongs to which type of operator in python?
      29 December, 2020

      “not in” belongs to the membership operator in python. Membership operator have two operators “in” and “not in”. They are used to test whether a value or variable is found in a sequence (string, list, tuple, set and dictionary). e.g., …

      What is the difference between Python 2 and 3
      8 December, 2020

      Python 2 and 3 got many differences between them. In this article, we will go through some important differences between them. While comparing these two, it is pretty clear that python 3 is much better than 2. Python 2 is …

      How To Check If A List Is Empty In Python
      7 December, 2020

      In this article, we will see how to check if a list is empty or not. A list is said to be empty when there are no elements in the list. Method 1: Output: Method 2: Output:

      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

      • How to get access to the course after purchase?
      • “not in” belongs to which type of operator in python?
      • What is the difference between Python 2 and 3
      • How To Check If A List Is Empty In Python
      • How to Change Line in Python
      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