4
python读取xlsx
source link: http://abcdxyzk.github.io/blog/2021/03/02/python-xlsx/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
kk Blog —— 通用基础
kk Blog —— 通用基础
date [-d @int|str] [+%s|"+%F %T"]
Use the up and down arrows to select a result. Press enter to go to the selected search result. Touch device users can use touch and swipe gestures.
python读取xlsx
2021-03-02 23:07:00
pip install xlrd==1.2.0
https://www.cnblogs.com/tynam/p/11204895.html
#coding:utf-8
import xlrd
import sys
def readxls(filename):
data = xlrd.open_workbook(filename)
table = data.sheet_by_index(0)
datas = []
for rn in range(table.nrows):
datas.append(table.row_values(rn))
return datas
f1='mm.xlsx'
datas = readxls(f1)
Posted by kk
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK