blocks|key|3507305|text|要确保您的文件没有损坏，请尝试使用另一个文件；我怀疑xlrd是否有问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3507306|另外，我还清理了您的代码，使其看起来更好看一些。例如，if+row+>+0检查是不必要的，因为您可以首先在range(1,+sheet.nrows)上迭代。|offset|length|style|CODE|3507307|def+get_data_form_excel(address):
++++#+this+returns+a+generator+not+a+list;+you+can+iterate+over+it+as+normal,
++++#+but+if+you+need+a+list,+convert+the+return+value+to+one+using+list()
++++for+sheet+in+xlrd.open_workbook(address).sheets():
++++++++for+row+in+range(1,+sheet.nrows):
++++++++++++yield+[str(sheet.cell(row,+col).value)+for+col+in+range(sheet.ncols)]|code-block|syntax|javascript|3507308|或|3507309|def+get_data_form_excel(address):
++++#+you+can+make+this+function+also+use+a+(lazily+evaluated)+generator+instead
++++#+of+a+list+by+changing+the+brackets+to+normal+parentheses.
++++return+[
++++++++[str(sheet.cell(row,+col).value)+for+col+in+range(sheet.ncols)]
++++++++for+sheet+in+xlrd.open_workbook(address).sheets()
++++++++for+row+in+range(1,+sheet.nrows)
++++]|3507310|entityMap^0|0|R|A|1H|L|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@$D|U|E|V|F|G]|$D|W|E|X|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|Y|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|J|7|10|8|@]|9|@]|A|$K|L]]|$1|Q|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|R|$]]

To make sure your file is not corrupt, try with another file; I doubt xlrd is buggy.

Also, I've cleaned up your code to look a bit nicer. For example the <code>if row &gt; 0</code> check is unneeded because you can just iterate over <code>range(1, sheet.nrows)</code> in the first place.

<pre><code>def get_data_form_excel(address):
 # this returns a generator not a list; you can iterate over it as normal,
 # but if you need a list, convert the return value to one using list()
 for sheet in xlrd.open_workbook(address).sheets():
 for row in range(1, sheet.nrows):
 yield [str(sheet.cell(row, col).value) for col in range(sheet.ncols)]
</code></pre>

or

<pre><code>def get_data_form_excel(address):
 # you can make this function also use a (lazily evaluated) generator instead
 # of a list by changing the brackets to normal parentheses.
 return [
 [str(sheet.cell(row, col).value) for col in range(sheet.ncols)]
 for sheet in xlrd.open_workbook(address).sheets()
 for row in range(1, sheet.nrows)
 ]
</code></pre>

blocks|key|2366320|text|在尝试了一些其他文件之后，我确信这是关于该文件的，而且我认为它与Microsoft+2003和2007的差异有关。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2366321|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

After trying some other files I'm sure it's about the file, and I think it's related to Microsoft 2003 and 2007 differences.

blocks|key|3507349|text|我最近也遇到了这个问题。我试图读取一个excel文件，xlrd.nrows给出的行号比实际的要小。作为Zeinab+Abbasi+saied，我尝试了其他文件，但它运行良好。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3507350|最后，我发现了不同之处:在失败的文件中嵌入了一个基于VB脚本的按钮，用于下载记录并将记录追加到当前的工作表中。|3507351|然后，我尝试将文件转换为.xlsx格式，但它要求我保存为另一种已启用宏的格式，例如.xlsm。这一次xlrd.nrows给出了正确的值。|3507352|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I recently got this problem too. I'm trying to read an excel file and the row number given by xlrd.nrows is less than the actual one. As Zeinab Abbasi saied, I tried other files but it worked fine. 

Finally, I find out the difference : there's a VB-script based button embedded in the failed file, which is used to download and append records to the current sheet.

Then, I try to convert the file to .xlsx format, but it asks me to save as another format with macro enabled, e.g .xlsm. This time xlrd.nrows gives the correct value.

blocks|key|2366386|text|excel文件是否使用外部数据？我只是遇到了同样的问题，找到了解决办法。我用excel从google表格中获取信息，我想让python向我展示这些数据。因此，我的修复程序将转到DATA>Connections(在“获取外部数据”中)>属性并取消检查“在保存工作簿之前从外部数据范围中删除数据”。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2366387|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Is your excel file using external data? I just had the same problem and found a fix. I was using excel to get info from a google sheet, and I wanted to have python show me that data. So, the fix for me was going to DATA>Connections(in "Get External Data")>Properties and unchecking "Remove data from the external data range before saving the workbook"

I got a really strange problem. I'm trying to read some data from an excel file, but the property <code>nrows</code> has a wrong value. Although my file has a lot of rows, it just returns 2. 

I'm working in pydev eclipse. I don't know what is actually the problem; everything looks fine. 

When I try to access other rows by index manually, but I got the index error. 

I appreciate any help.

If it helps, it's my code:

<pre><code>def get_data_form_excel(address):
 wb = xlrd.open_workbook(address)
 profile_data_list = []
 for s in wb.sheets():
 for row in range(s.nrows):
 if row &gt; 0:
 values = []
 for column in range(s.ncols):
 values.append(str(s.cell(row, column).value))
 profile_data_list.append(values)
 print str(profile_data_list)
 return profile_data_list
</code></pre>

sheet.nrows has a wrong value - python excel file

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有个很奇怪的问题。我正在尝试从excel文件中读取一些数据，但是属性nrows有一个错误的值。虽然我的文件有很多行，但它只返回2。我的工作是日食。我不知道到底是什么问题，一切看起来都很好。当我尝试通过索引访问其他行时，但是得到了索引错误。我很感谢你的帮助。如果有帮助，那就是我的代码：def get_data_form...

问sheet.nrows有错误的值- python文件。
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问sheet.nrows有错误的值- python文件。EN