Home Backend Development Python Tutorial How to read excel table in python

How to read excel table in python

Jun 22, 2019 pm 02:03 PM

How to read excel table in python

Hello everyone, let’s explore how to use Python to operate Excel files today. Similar to the word file operation library python-docx, Python also has special libraries to provide support for Excel file operations. These libraries include xlrd, xlwt, xlutils, openpyxl, and xlsxwriter. Among them, my favorite is openpyxl, which is also The main content of this explanation. Excel files are familiar to everyone. They are used in daily work and study. Let's recall, what are the steps for you to operate an Excel file? The picture below shows an Excel file. Let’s compare it and think about it.

How to read excel table in python

OK, let’s walk through it together. First, we need to create or open an Excel file, and then select an A worksheet, which is the sheet in the picture above, finally reads or sets the value of cell. Correspondingly, in openpyxl, there are three concepts: Workbooks, Sheets, and Cells. Workbook is an open excel file, that is, an excel workbook; Sheet is a table in the workbook, that is, a worksheet; Cell is a simple cell. openpyxl revolves around these three concepts. Regardless of reading and writing, it is "three things": open the Workbook, locate the Sheet, and operate the Cell. OK, now that we understand the basic concepts, let’s see it in action!

First of all, openpyxl is not a pre-installed library of Python 3. We need to install it manually. It is very simple to open the command line window and enter pip install openpyxl. As shown in the picture below, mine has been installed, so the output information may be different from everyone else's.

How to read excel table in python

After installing openpyxl, import it through the import statement, and then execute the help method to see To see what is included in the openpyxl library, you don’t need to know it, just have an impression.

How to read excel table in python

Some words in it are still very familiar, such as cell, chart, styles, workbook, worksheet, In addition to using the help method, you can also use the dir method to view all members of a library. I have marked some that we may use later in red. You can focus on them during the learning process.

How to read excel table in python

The following are the general steps for operating Excel files:

1. Open or create an Excel : You need to create a workbook object. The load_workbook method is used to open an Excel, and creating an Excel is done directly by instantiating the workbook class.

2. Get a worksheet: You need to create a workbook object first, and then use the method of the object to get a worksheet object.

3. If you want to get the data in the table, you need to get a worksheet object first, and then get the Cell object representing the cell from it.

OK, let’s take a look at the actual operation in Python. The object of the operation is the position list of civil servants entered in the Hainan Examination in 2018, as shown in the figure below.

How to read excel table in python

Some basic operation examples are given below, you can follow them and write them down.

How to read excel table in python

Show the operation again, read the cells in the specified row and row at once, use the iter_rows method, which means iterate by row within the range specified by the parameter , if you want to iterate by columns, you can use the iter_cols method.

How to read excel table in python

The above code shows how to operate an existing Excel file. Let’s take a look at the example of creating a new Excel file.

How to read excel table in python

The generated Excel file is as shown below:

How to read excel table in python

OK, do you feel that operating Excel is very easy? That’s because you have made progress in learning Python during this period. Give yourself a thumbs up! Thank you for your attention and reading. There will be more delicious programming in the future, so please enjoy it.

The above is the detailed content of How to read excel table in python. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undress AI Tool

Undress AI Tool

Undress images for free

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Peak: How To Revive Players
1 months ago By DDD
PEAK How to Emote
4 weeks ago By Jack chen

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Polymorphism in python classes Polymorphism in python classes Jul 05, 2025 am 02:58 AM

Polymorphism is a core concept in Python object-oriented programming, referring to "one interface, multiple implementations", allowing for unified processing of different types of objects. 1. Polymorphism is implemented through method rewriting. Subclasses can redefine parent class methods. For example, the spoke() method of Animal class has different implementations in Dog and Cat subclasses. 2. The practical uses of polymorphism include simplifying the code structure and enhancing scalability, such as calling the draw() method uniformly in the graphical drawing program, or handling the common behavior of different characters in game development. 3. Python implementation polymorphism needs to satisfy: the parent class defines a method, and the child class overrides the method, but does not require inheritance of the same parent class. As long as the object implements the same method, this is called the "duck type". 4. Things to note include the maintenance

How do I write a simple 'Hello, World!' program in Python? How do I write a simple 'Hello, World!' program in Python? Jun 24, 2025 am 12:45 AM

The "Hello,World!" program is the most basic example written in Python, which is used to demonstrate the basic syntax and verify that the development environment is configured correctly. 1. It is implemented through a line of code print("Hello,World!"), and after running, the specified text will be output on the console; 2. The running steps include installing Python, writing code with a text editor, saving as a .py file, and executing the file in the terminal; 3. Common errors include missing brackets or quotes, misuse of capital Print, not saving as .py format, and running environment errors; 4. Optional tools include local text editor terminal, online editor (such as replit.com)

What are algorithms in Python, and why are they important? What are algorithms in Python, and why are they important? Jun 24, 2025 am 12:43 AM

AlgorithmsinPythonareessentialforefficientproblem-solvinginprogramming.Theyarestep-by-stepproceduresusedtosolvetaskslikesorting,searching,anddatamanipulation.Commontypesincludesortingalgorithmslikequicksort,searchingalgorithmslikebinarysearch,andgrap

What is list slicing in python? What is list slicing in python? Jun 29, 2025 am 02:15 AM

ListslicinginPythonextractsaportionofalistusingindices.1.Itusesthesyntaxlist[start:end:step],wherestartisinclusive,endisexclusive,andstepdefinestheinterval.2.Ifstartorendareomitted,Pythondefaultstothebeginningorendofthelist.3.Commonusesincludegetting

Python `@classmethod` decorator explained Python `@classmethod` decorator explained Jul 04, 2025 am 03:26 AM

A class method is a method defined in Python through the @classmethod decorator. Its first parameter is the class itself (cls), which is used to access or modify the class state. It can be called through a class or instance, which affects the entire class rather than a specific instance; for example, in the Person class, the show_count() method counts the number of objects created; when defining a class method, you need to use the @classmethod decorator and name the first parameter cls, such as the change_var(new_value) method to modify class variables; the class method is different from the instance method (self parameter) and static method (no automatic parameters), and is suitable for factory methods, alternative constructors, and management of class variables. Common uses include:

Python Function Arguments and Parameters Python Function Arguments and Parameters Jul 04, 2025 am 03:26 AM

Parameters are placeholders when defining a function, while arguments are specific values ​​passed in when calling. 1. Position parameters need to be passed in order, and incorrect order will lead to errors in the result; 2. Keyword parameters are specified by parameter names, which can change the order and improve readability; 3. Default parameter values ​​are assigned when defined to avoid duplicate code, but variable objects should be avoided as default values; 4. args and *kwargs can handle uncertain number of parameters and are suitable for general interfaces or decorators, but should be used with caution to maintain readability.

How do I use the csv module for working with CSV files in Python? How do I use the csv module for working with CSV files in Python? Jun 25, 2025 am 01:03 AM

Python's csv module provides an easy way to read and write CSV files. 1. When reading a CSV file, you can use csv.reader() to read line by line and return each line of data as a string list; if you need to access the data through column names, you can use csv.DictReader() to map each line into a dictionary. 2. When writing to a CSV file, use csv.writer() and call writerow() or writerows() methods to write single or multiple rows of data; if you want to write dictionary data, use csv.DictWriter(), you need to define the column name first and write the header through writeheader(). 3. When handling edge cases, the module automatically handles them

Explain Python generators and iterators. Explain Python generators and iterators. Jul 05, 2025 am 02:55 AM

Iterators are objects that implement __iter__() and __next__() methods. The generator is a simplified version of iterators, which automatically implement these methods through the yield keyword. 1. The iterator returns an element every time he calls next() and throws a StopIteration exception when there are no more elements. 2. The generator uses function definition to generate data on demand, saving memory and supporting infinite sequences. 3. Use iterators when processing existing sets, use a generator when dynamically generating big data or lazy evaluation, such as loading line by line when reading large files. Note: Iterable objects such as lists are not iterators. They need to be recreated after the iterator reaches its end, and the generator can only traverse it once.

See all articles