-
Notifications
You must be signed in to change notification settings - Fork 0
/
xlrdtest.py
35 lines (29 loc) · 916 Bytes
/
xlrdtest.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
# -*- coding: utf-8 -*-
#/usr/bin/env python
import xlrd
xlsfile = '/home/clay/test.xlsx'
book = xlrd.open_workbook(xlsfile)
# 获取sheet对象
# 方法1
# sheet_name = book.sheet_names()[0]
# print sheet_name
# sheet1=book.sheet_by_name(sheet_name) #通过sheet名字来获取,当然如果你知道sheet名字了可以直接指定
# sheet0=book.sheet_by_index(0) #通过sheet索引获得sheet对象
# 获取行数和列数
sheet1 = book.sheet_by_index(0)
# nrows = sheet1.nrows
# nclos = sheet1.ncols
# 打印每列的值
# for clonum in range(sheet1.ncols):
# print sheet1.col_values(clonum)
# 打印每行的数据
# for rownum in range(sheet1.nrows):
# print rownum
# print sheet1.row_values(rownum)
# 打印每行的数据,排除第一行标题行
nrows = sheet1.nrows
for num in range(1,nrows):
a = sheet1.row_values(num)
for i in a:
print i
print type(i)