用python解析excel文件

问题描述

我想将Excel文档解析成Python中的列表。
有没有一个python库对这个动作有帮助？
那个库里有什么功能？

解决方案

你最好打算解析Excel文件是图书馆。 网站包含和相关的python excel库，包括一个，它有一些使用xlrd的很好的例子。当然，在StackOverflow上也有许多可能有用的。

更新：
根据John的评论，库现在支持 xls 和 xlsx 文件格式。

希望有所帮助。

I want to parse excel document to lists in Python.Is there a python library which is helpful for this action?And what functions are relevant in that library?

解决方案

You're best bet for parsing Excel files would be the xlrd library. The python-excel.org site has links and examples for xlrd and related python excel libraries, including a pdf document that has some good examples of using xlrd. Of course, there are also lots of related xlrd questions on StackOverflow that might be of use.

UPDATE:As per John's comment, the xlrd library now supports both xls and xlsx file formats.

Hope that helps.

这篇关于用python解析excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！