By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,494 Members | 1,079 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,494 IT Pros & Developers. It's quick & easy.

pyExcelerator - Can I read and modify an existing Excel-WorkBook?

P: n/a

Hi

I would like to
1. import an existing Excel-sheet (a template)
2. and add some data to it
3. and save it under a different name afterwards.

To me it seems, that pyExcelerator does not support the reading for
modification of an Excel-sheet. It allows only the "parse_xls" but I would
like to keep the "formatting" in the template.

Did I miss a "load", "read" or "open" function in pyExcelerator that would
hand me back a WorkBook?

Greetings,
Marco
Jul 11 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Marco Aschwanden wrote:
>
Hi

I would like to
1. import an existing Excel-sheet (a template)
2. and add some data to it
3. and save it under a different name afterwards.

To me it seems, that pyExcelerator does not support the reading for
modification of an Excel-sheet. It allows only the "parse_xls" but I
would like to keep the "formatting" in the template.

Did I miss a "load", "read" or "open" function in pyExcelerator that
would hand me back a WorkBook?

Greetings,
Marco

If you are on Windows, you may find using COM interface to
actual Excel application easier.

-Larry Bates
Jul 11 '06 #2

P: n/a
I'm pretty sure it doesn't support reading an existing document. That
would be useful.

On 7/11/06, Larry Bates <la*********@websafe.comwrote:
Marco Aschwanden wrote:

Hi

I would like to
1. import an existing Excel-sheet (a template)
2. and add some data to it
3. and save it under a different name afterwards.

To me it seems, that pyExcelerator does not support the reading for
modification of an Excel-sheet. It allows only the "parse_xls" but I
would like to keep the "formatting" in the template.

Did I miss a "load", "read" or "open" function in pyExcelerator that
would hand me back a WorkBook?

Greetings,
Marco
If you are on Windows, you may find using COM interface to
actual Excel application easier.

-Larry Bates
--
http://mail.python.org/mailman/listinfo/python-list

--
Gregory Piñero
Chief Innovation Officer
Blended Technologies
(www.blendedtechnologies.com)
Jul 11 '06 #3

P: n/a
No, by it I meant pyExcelerator :-)

On 7/11/06, Larry Bates <la*********@websafe.comwrote:
If by "it" you mean Excel's COM interface, it most certainly will.
With COM you call all the same functions/methods that Microsoft
calls to open, save, and manipulate the spreadsheet.

Here are a few links that might help:

http://mathieu.fenniak.net/plotting-...ugh-pythoncom/
http://www.markcarter.me.uk/computing/python/excel.html
http://mathieu.fenniak.net/plotting-...ugh-pythoncom/

Hope info helps.

-Larry

Gregory Piñero wrote:
I'm pretty sure it doesn't support reading an existing document. That
would be useful.

On 7/11/06, Larry Bates <la*********@websafe.comwrote:
Marco Aschwanden wrote:

Hi

I would like to
1. import an existing Excel-sheet (a template)
2. and add some data to it
3. and save it under a different name afterwards.

To me it seems, that pyExcelerator does not support the reading for
modification of an Excel-sheet. It allows only the "parse_xls" but I
would like to keep the "formatting" in the template.

Did I miss a "load", "read" or "open" function in pyExcelerator that
would hand me back a WorkBook?

Greetings,
Marco
If you are on Windows, you may find using COM interface to
actual Excel application easier.

-Larry Bates
--
http://mail.python.org/mailman/listinfo/python-list


--
Gregory Piñero
Chief Innovation Officer
Blended Technologies
(www.blendedtechnologies.com)
Jul 11 '06 #4

P: n/a
Hello,
I agree that it would be nice to use one package to read and modify an
Excel Sheet. I have only had to do either one or the other, read a
sheet and use the data for something else, or export data to an
Excel-Sheet. Perhaps you might like to look at xlrd:

http://www.lexicon.net/sjmachin/xlrd.htm

It works fines as far as reading Excel is concerned.

Greetings,

Richard Sharp

Gregory Piñero wrote:
No, by it I meant pyExcelerator :-)

On 7/11/06, Larry Bates <la*********@websafe.comwrote:
If by "it" you mean Excel's COM interface, it most certainly will.
With COM you call all the same functions/methods that Microsoft
calls to open, save, and manipulate the spreadsheet.

Here are a few links that might help:

http://mathieu.fenniak.net/plotting-...ugh-pythoncom/
http://www.markcarter.me.uk/computing/python/excel.html
http://mathieu.fenniak.net/plotting-...ugh-pythoncom/

Hope info helps.

-Larry

Gregory Piñero wrote:
I'm pretty sure it doesn't support reading an existing document. That
would be useful.
>
On 7/11/06, Larry Bates <la*********@websafe.comwrote:
>Marco Aschwanden wrote:
>
Hi
>
I would like to
1. import an existing Excel-sheet (a template)
2. and add some data to it
3. and save it under a different name afterwards.
>
To me it seems, that pyExcelerator does not support the reading for
modification of an Excel-sheet. It allows only the "parse_xls" butI
would like to keep the "formatting" in the template.
>
Did I miss a "load", "read" or "open" function in pyExcelerator that
would hand me back a WorkBook?
>
Greetings,
Marco
>
>
>If you are on Windows, you may find using COM interface to
>actual Excel application easier.
>>
>-Larry Bates
>--
>http://mail.python.org/mailman/listinfo/python-list
>>
>
>


--
Gregory Piñero
Chief Innovation Officer
Blended Technologies
(www.blendedtechnologies.com)
Jul 13 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.