On Tue, Feb 4, 2014 at 2:47 PM, David Crisp <dcr...@netspace.net.au> wrote:
> I have just finished a major project using the xlrd and xlwt python libs. > Theres also an xlutil lib as well which allows you to manipiulate excel. > but i havent played with that one. (I also used pymssql to push this data > into an MSSQL database.. but thats a different story) > > For a sheet that holds basic data I havent found anything the libs wont do. > > They work in Py3.3 and Py2.7 > +1 from me. Just in case it wasn't clear, these are pure python modules; they don't interact with Office automation objects, so they run anywhere (linux), it's more robust than using Office and much faster. However, these libraries offers only a limited subset of Excel functionality; you can't make charts, pivot tables or macros. The idea of opening an existing document, and modifying it, is not really supported as far as I could work out. You create new sheets. I may be wrong about that; all I've used it for is creating spreadsheets. I suspect google docs has a much better API in terms of enabling maximum "richness" and it may be something worth thinking about (i.e. Google Spreadsheets). The only real way to get perfect Excel creation is to automate an office binary installation. -- *Tim Richardson, Director* GrowthPath, Data-driven profit growth Mobile: +61 423 091 732 Office: +61 3 8678 1850 I tweet useful business & IT tips at growthpath_au GrowthPath Pty Ltd ABN 76 133 733 963 <http://www.growthpath.com.au/>
_______________________________________________ melbourne-pug mailing list melbourne-pug@python.org https://mail.python.org/mailman/listinfo/melbourne-pug