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).
3
-
1This would be better suited to stackoverflow.com.Andy Mikula– Andy Mikula2009-07-16 20:54:44 +00:00Commented Jul 16, 2009 at 20:54
-
Is this the first occurence of a SU question beloning on SO? If so, congrats!balpha– balpha ♦2009-07-16 20:58:37 +00:00Commented Jul 16, 2009 at 20:58
-
Not by a long shot, unfortunately ;)Andy Mikula– Andy Mikula2009-07-16 21:01:52 +00:00Commented Jul 16, 2009 at 21:01
Add a comment
|
2 Answers
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!
answered Jul 16, 2009 at 21:19
Alex Martelli
887k175 gold badges1.3k silver badges1.4k bronze badges
2 Comments
John Machin
Please folks READ the OP's question ... the xl* packages DON'T SUPPORT GRAPHS.
John Machin
Hello hello ... the person with the equally erroneous Java-packages solution has deleted his answer ...
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.
