[melbourne-pug] Excel spreadsheet munging under Linux. Limits?

[Tim Richardson]

On Tue, Feb 4, 2014 at 2:47 PM, David Crisp <dcrisp at 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/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/melbourne-pug/attachments/20140204/4efc2eec/attachment-0001.html>