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 4 5810
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
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)
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)
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)
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Ian Dunn |
last post by:
I'm simply trying to access an instance of Excel that has been opened
manually by the user in order to put a few values in the existing sheet.
Here's the code I've tried:
Dim oXL As...
|
by: hmiller |
last post by:
Hey there folks:
I have been trying to get this work for about a week now. I'm new to
VBA...
I am trying to transfer a populated table in Access to an existing, but
blank, Excel worksheet. I...
|
by: abhiab54 |
last post by:
Hi,
I want to open already existing excel sheet search for perticular string & write specific value below the cell containing that string.
Please help I have limited knowledge of Vb, Perticularly...
|
by: veer |
last post by:
hello expert
i have a programe in which i want to modify or add new records in excel sheet
but it opened read only and when ever i want to insert the record it give the message that give new name...
|
by: tsanthoshk |
last post by:
Hi All
I am trying to read and modify input excel file. when i update the data in excel sheet already existing format is washing out. It mean if excel sheet contain colors those are not appearing...
|
by: student491 |
last post by:
Hello,
i tried to open existNg Excel file by using follow metho bt it give error ... that this file doestnt exist or path is incorrect........
wb =...
|
by: thanawala27 |
last post by:
Hi,
I had problems writing in an existing Excel File.
There is an excel file with a worksheet. I would like to open this existing Excel file and add another worksheet and write data into it....
|
by: amuven |
last post by:
Hi All,
I'm new to python I have written very basic and small code and I request to help for the following senario.For my project i want to write a python code which should open an already...
|
by: glenn.ward |
last post by:
Hello
I have existing Excel files complete with formulas, formatting and
some with macros. I was wondering if VB.Net would allow me to edit an
existing Excel file. I know I can recreate such a...
|
by: premMS143 |
last post by:
How to append Data to an existing Excel file?
means,
I'm using VB as front end & once I exported the data to Excel file & saved it as 'ABC.xls'.
Now, the question/doubt is;
I addded some more...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |