4

python读取xlsx

 3 years ago
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

2021-03-02 23:07:00language, python

« php获取月初和月尾时间 python读写dbf数据库 »

Copyright © 2021 - kk - Powered by Octopress 站长统计


About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK