在 while 循环中调用工作表名称

发布于 2024-12-17 15:11:25 字数 546 浏览 3 评论 0原文

我已经导入了 xlrd 等。我的代码的主要部分如下：

for serie_diam in range(0,9):
namesheet = "Diamètre " + str(serie_diam)
#select(namesheet)
numLine = sh.row_values(3)
OK = 1
while OK == 1:
    d = sh1(numLine, 1)
    D = sh1(numLine, 2)
    rs = sh1(numLine, 7)
    for i in range(4):
        BB = sh1(numLine, 2 + i)
        if BB != 0:
            print repr(d).rjust(2), repr(D).rjust(3), repr(B).rjust(4), repr(rs).rjust(5)

我的 xls 文件中有 7 张表，我想知道如何在同一个 while 循环中循环这些表，因为 OK == 1 where for当我只写“sh1”时。

如果这个问题太简单了，我很抱歉！

原文

I have imported xlrd etc. The main part of my code is then as follows:

for serie_diam in range(0,9):
namesheet = "Diamètre " + str(serie_diam)
#select(namesheet)
numLine = sh.row_values(3)
OK = 1
while OK == 1:
    d = sh1(numLine, 1)
    D = sh1(numLine, 2)
    rs = sh1(numLine, 7)
    for i in range(4):
        BB = sh1(numLine, 2 + i)
        if BB != 0:
            print repr(d).rjust(2), repr(D).rjust(3), repr(B).rjust(4), repr(rs).rjust(5)

I have 7 sheets in my xls file overall and I would like to know how I can loop through these in the same while loop as OK == 1 where for the moment I have written just 'sh1'.

I'm sorry if this question is too easy!

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

一江春梦 2024-12-24 15:11:25

import xlrd

book = xlrd.open_workbook('xlrd_test.xls')

for sheet in book.sheets():
    print sheet.row(0) # do stuff here - I'm printing the first line as example

# or if you need the sheet index for some purpose:
for shidx in xrange(0, book.nsheets):
    sheet = book.sheet_by_index(shidx)
    # would print 'Page N, first line: ....'
    print 'Page %d, first line: %s' % (shidx, sheet.row(0))

import xlrd

book = xlrd.open_workbook('xlrd_test.xls')

for sheet in book.sheets():
    print sheet.row(0) # do stuff here - I'm printing the first line as example

# or if you need the sheet index for some purpose:
for shidx in xrange(0, book.nsheets):
    sheet = book.sheet_by_index(shidx)
    # would print 'Page N, first line: ....'
    print 'Page %d, first line: %s' % (shidx, sheet.row(0))

回复收藏 0 原文

~没有更多了~