Python xlrd 模块 [英] Python xlrd module
问题描述
根据XLRD模块的文档,
According to the documentation of the XLRD module,
row_values(rowx, start_colx=0, end_colx=None)
返回给定行中单元格值的一部分."
"Returns a slice of the values of the cells in the given row."
并给出以下python代码:
And given the following python code:
import xlrd
wb=xlrd.open_workbook("xl1.xlsx")
sh = wb.sheet_by_index(0)
for rownum in range(sh.nrows):
print sh.row_values(rownum)
输出为:
[12.0, u'test.0']
[34.0, u'te.st']
[u'test123', u'12.test']
并且exel文件包含以下数据:
and the exel file holds the following data:
12.0、test.0、34.0、test、test123、12.test
12.0 , test.0 , 34.0 , te.st , test123 , 12.test
那么,根据输出,我得到什么类型的数据结构作为一行?它不是元组,(因为在打印元组类型时,没有 u' 作为字符串的前缀), u' 的含义是什么?而且它就像我们在数据结构中有两种类型的数据 - int 和非 int".这是真的吗?我在文档中找不到任何关于此的信息.谢谢!
So, what type of data structure do I get as a line according to the output? Its not a tuple, (becasue when printing a tuple type, there is no u' as a prefix to a string), and what is the meaning of the u' ? And also its like we have two types of data in the data structure - int and "non int". Is it true? I could not find any information about this in the documentation. Thanks!
推荐答案
row_values
返回具有适当数据类型的单元格值列表.列表中每一项的数据类型取决于源excel文件中的单元格类型.
row_values
returns a list of cell values with appropriate data types. Data type of each item in the list depends on the cell type in the source excel file.
可能有只有 string
、float
和 int
数据类型的项目,请参阅此 映射表(在那里找到 Cell
的文档)了解更多信息.
There could be items with only string
, float
and int
data types, see this mapping table (find there docs for Cell
) for more info.
u
只是表示这是一个 unicode 字符串.文档 解释得很好.
u
just means that this is a unicode string. Documentation explains it pretty well.
希望有所帮助.
这篇关于Python xlrd 模块的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!