In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-04 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Development >
Share
Shulou(Shulou.com)06/01 Report--
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.
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.