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).
Asked
Active
Viewed 5,329 times
3
-
1This would be better suited to http://www.stackoverflow.com. – Andy Mikula Jul 16 '09 at 20:54
-
Is this the first occurence of a SU question beloning on SO? If so, congrats! – balpha Jul 16 '09 at 20:58
-
Not by a long shot, unfortunately ;) – Andy Mikula Jul 16 '09 at 21:01
2 Answers
7
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!
Alex Martelli
- 854,459
- 170
- 1,222
- 1,395
-
1Please folks READ the OP's question ... the xl* packages DON'T SUPPORT GRAPHS. – John Machin Jul 17 '09 at 03:04
-
Hello hello ... the person with the equally erroneous Java-packages solution has deleted his answer ... – John Machin Jul 18 '09 at 01:39
1
On Windows you could use the pywin32 package to create an Excel COM Object and then manipulate it from a script. You need to have an installed Excel on that machine though. I haven't done this myself so I can't give you and details but I've seen this working so can at least confirm that it's possible. No idea about OS X, unfortunately.
bluebrother
- 8,636
- 1
- 20
- 21