Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to write the code that Python extracts Excel content". In the daily operation, I believe that many people have doubts about how to write the code that Python extracts Excel content. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "how to write the code for Python extraction Excel content". Next, please follow the editor to study!

To be honest, there are many libraries for Python to manipulate excel, but I have hardly found an api to implement this requirement. For example, the openpyxl library I use most often doesn't have this feature either.

Finally, check it out, only xlwings this library! Note: this library is a third-party library, we must install it in advance, and be sure to use the latest version! The latest version! The latest version! Otherwise, there are some methods you can't use.

# Open the cmd window and install the xlings library pip install xlwings # before using the xlwings library, you need to import the relevant knowledge of the import xlwings as xwxlwings library in advance

First, the xw.App () we see is a function in the xlwings library.

Xw.App (visible=False,add_book=False)

Where:

Visible: True means that the program window is displayed after starting the excel program. If False, the program window runs in the background after the excel program is started

Add_book: True means to create a new blank workbook after starting the excel program. If False, the workbook will not be created after starting the excel program

App.books.open (file path)

The above function is used to help us open the workbook, which has a parameter passed in the path of the local excel, which is used to open the local workbook.

Complete code

The Excel text box is as follows:

Go directly to the code:

Import xlwings as xw app = xw.App (visible=False,add_book=False) wb = app.books.open ('test1.xlsx') for sheet in wb.sheets: for shape in sheet.shapes: if "TextBox" in shape.name: print (shape.text) # make sure the latest version of xlwings, the old version does not have the text method wb.close () app.quit ()

The results are as follows:

Of course, this is for a certain table, master the method, give you multiple tables, is not just a loop to read it?

1000 watches, you can go down and have a try!

At this point, the study on "how to write the code for Python to extract Excel content" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.