Python - 阅读电子表格 [英] Python - Reading a spreadsheet
本文介绍了Python - 阅读电子表格的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
这是一个赛马计划,其中几匹马的信息将以不同的行或列列在一个Excel表格中。我需要知道我是否可以分别对这些马进行计算,然后计算给定马的分数。
解决方案
OpenPyXL (用于读/写Excel 2007 xlsx / xlsm文件的Python库)具有非常好的和Pythonic API。
What I need to know is, can I get Python to read a spreadsheet (preferably Microsoft Excel), then parse the information and input it into an equation?
It's for a horse-racing program, where the information for several horses will be in one excel spreadsheet, in different rows or columns. I need to know if I can run a calculation for each of those horses separately and then calculate a score for the given horse.
解决方案
OpenPyXL ("A Python library to read/write Excel 2007 xlsx/xlsm files") has a very nice and Pythonic API.
这篇关于Python - 阅读电子表格的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文