使用Python自动创建/操纵Excel电子表格 [英] Using Python to Automate Creation/Manipulation of Excel Spreadsheets

问题描述

我有一些CSV格式的数据，我想拉入Excel电子表格，然后创建一些标准的图表。由于数据最初是在Python应用程序中生成的，所以我希望只需扩展该应用程序，以便它可以进行所有的后期处理，而且我不用手动执行。是否有一个易于使用和操纵Excel电子表格的Python界面？这样做的好样品吗？只是这个Windows（我主要在Mac上工作，并且具有Excel，但是如果需要，可以在Windows上这样做）。

I have some data in CSV format that I want to pull into an Excel spreadsheet and then create some standard set of graphs for. Since the data is originally generated in a Python app, I was hoping to simply extend the app so that it could do all the post processing and I wouldn't have to do it by hand. Is there an easy interface with Python to work with and manipulate Excel spreadsheets? Any good samples of doing this? Is this Windows only (I'm primarily working on a Mac and have Excel, but could do this on Windows if necessary).

推荐答案

p> xlutils （以及随附的软件包 xlrd 和 xlwt ）应该允许您的Python程序轻松地进行任何可能需要的Excel文件的创建，阅读和操作！

xlutils (and the included packages xlrd and xlwt) should allow your Python program to handily do any creation, reading and manipulation of Excel files you might want!

这篇关于使用Python自动创建/操纵Excel电子表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！