How to read data from excel tables by Python

This article mainly introduces the relevant knowledge of "how Python reads the data of excel form". The editor shows you the operation process through an actual case. The method of operation is simple, fast and practical. I hope that this article "how Python reads the data of excel form" can help you solve the problem.

Editor here recommends the use of a very compatible package, after use, you can access the Excel table file in the Linux environment, this package is xlrs.

Paste the following code after opening workbook:

Import xlrdwb = xlrd.open_workbook ('myworkbook.xls')

Check the form name:

Wb.sheet_names ()

There are two ways to get the first form by index or name:

Sh = wb.sheet_by_index (0) sh = wb.sheet_by_name (upright Sheet1')

Output the data of each row after the operation:

For rownum in range (sh.nrows): print sh.row_values (rownum)

Just want to get the first column of data:

First_column = sh.col_values (0)

You can also use the index to get the data (default starts at 0):

Cell_A1 = sh.cell (0J0). Valuecell_C4 = sh.cell (rowx=3,colx=2) .value on "how Python reads data from excel tables" ends here. Thank you for reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.