How to read data in excel using Python-Python Tutorial-php.cn

Home

Backend Development

Python Tutorial

How to read data in excel using Python

高洛峰

Mar 17, 2017 pm 04:42 PM

excelpython

python中要想处理excel，必须用到第三方模块xlrd，所以windows 我安装方法是cmd中命令：E:\ANZHUANG\Python\Scripts>easy_install xlrd （路径必须在python的scripts下和必须安装easy_install）

#coding=utf-8
import xlrd
def print_xls(path):
data=xlrd.open_workbook(path)   #打开excel
table=data.sheets()[1] #打开excel的第几个sheet
nrows=table.nrows   #捕获到有效数据的行数
books=[]
for i in range(nrows):
ss=table.row_values(i)   #获取一行的所有值，每一列的值以列表项存在
#print ss
for i in range(len(ss)):
print ss[i]            #输出一行中各个列的值
print &#39;+++++++++++++++++++&#39;
if name==&#39;main&#39;:
print_xls(&#39;D:\\文档\\431547909921.xls&#39;)

excel内的内容格式如下：

197 10208014 黄钊男医学院预防医学经金学院经济学类

198 10208006 宋马小薇女医学院预防医学医学院临床医学

199 10207014 杨婵媛女医学院制药工程医学院口腔医学

200 10207018 祖丽皮亚女医学院制药工程医学院临床医学

201 10207029 周力波男医学院制药工程医学院临床医学

输出结果：

199.0

10207014.0

杨婵媛

女

医学院

制药工程

医学院

口腔医学

+++++++++++++++++++

200.0

10207018

祖丽皮亚

女

医学院

制药工程

医学院

临床医学

+++++++++++++++++++

201.0

10207029

周力波

男

医学院

制药工程

医学院

临床医学

+++++++++++++++++++

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

Statement

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

Python and Time: Making the Most of Your Study TimeApr 14, 2025 am 12:02 AM

To maximize the efficiency of learning Python in a limited time, you can use Python's datetime, time, and schedule modules. 1. The datetime module is used to record and plan learning time. 2. The time module helps to set study and rest time. 3. The schedule module automatically arranges weekly learning tasks.

Python: Games, GUIs, and MoreApr 13, 2025 am 12:14 AM

Python excels in gaming and GUI development. 1) Game development uses Pygame, providing drawing, audio and other functions, which are suitable for creating 2D games. 2) GUI development can choose Tkinter or PyQt. Tkinter is simple and easy to use, PyQt has rich functions and is suitable for professional development.

Python vs. C : Applications and Use Cases ComparedApr 12, 2025 am 12:01 AM

Python is suitable for data science, web development and automation tasks, while C is suitable for system programming, game development and embedded systems. Python is known for its simplicity and powerful ecosystem, while C is known for its high performance and underlying control capabilities.

The 2-Hour Python Plan: A Realistic ApproachApr 11, 2025 am 12:04 AM

You can learn basic programming concepts and skills of Python within 2 hours. 1. Learn variables and data types, 2. Master control flow (conditional statements and loops), 3. Understand the definition and use of functions, 4. Quickly get started with Python programming through simple examples and code snippets.

Python: Exploring Its Primary ApplicationsApr 10, 2025 am 09:41 AM

Python is widely used in the fields of web development, data science, machine learning, automation and scripting. 1) In web development, Django and Flask frameworks simplify the development process. 2) In the fields of data science and machine learning, NumPy, Pandas, Scikit-learn and TensorFlow libraries provide strong support. 3) In terms of automation and scripting, Python is suitable for tasks such as automated testing and system management.

How Much Python Can You Learn in 2 Hours?Apr 09, 2025 pm 04:33 PM

You can learn the basics of Python within two hours. 1. Learn variables and data types, 2. Master control structures such as if statements and loops, 3. Understand the definition and use of functions. These will help you start writing simple Python programs.

How to teach computer novice programming basics in project and problem-driven methods within 10 hours?Apr 02, 2025 am 07:18 AM

How to teach computer novice programming basics within 10 hours? If you only have 10 hours to teach computer novice some programming knowledge, what would you choose to teach...