On Tue, Feb 04, 2014 at 04:39:13PM +1100, Javier Candeira wrote:
Yes, I have now received the template sheets, and they are .xlsx, not
xls. I'm doing a round of trying different Python libraries, see what
happens.
I'm fairly sure there are public python libraries that can preserve
an xlsx
Javier Candeira jav...@candeira.com writes:
At work I need to manipulate a series of excel spreasheets
What manipulations are needed?
- What's the current best Python library for excel manipulation?
I don't know much about them, but Pandas depends on these two:
They work very well. I Have been using xlrd for some years under both python 2.
7 and 3.3 on OSX and Linux over some years now whenever I have had to deal with
them. The down side is that they do not understand the contemporary version of
excel but need the saved in the previous document
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
On 4 February 2014 15:22, Rasjid Wilcox rasj...@openminddev.net wrote:
Under Linux etc.
Use a head-less copy of OpenOffice, and use its automation (pyUno) to
generate a spreadsheet that way. Be prepared for a lot of pain.
Last time I heard (early 2013) the headless build only worked on