Hi,
Yesterday I placed a bug report on PyExcelerators-Sourceforge-page... but
I am not so sure anymore, whether this is really a bug - I could imagine
that I missed something, but I don't see what. Please confirm that my bug
is due to mishandling and I will gladly retreat my bug report.
In a formula, I would like to point to a field on another worksheet.
pyExcelerator chokes on these references!
<example>
import pyExcelerator
wb = pyExcelerator.Workbook()
ws_summary = wb.add_sheet('Summary')
ws_data = wb.add_sheet('Data')
ws_summary.write(0,0, pyExcelerator.Formula('Data:A1')) <--- Here it
chokes!
ws_data.write(0, 0, '4000')
wb.save('not_parsing.xls')
</example>
Is this a bug or am I doing something wrong?
Regards,
Marco 4 3618
Marco Aschwanden wrote: Hi,
Yesterday I placed a bug report on PyExcelerators-Sourceforge-page... but I am not so sure anymore, whether this is really a bug - I could imagine that I missed something, but I don't see what. Please confirm that my bug is due to mishandling and I will gladly retreat my bug report.
In a formula, I would like to point to a field on another worksheet. pyExcelerator chokes on these references!
<example>
import pyExcelerator
wb = pyExcelerator.Workbook() ws_summary = wb.add_sheet('Summary') ws_data = wb.add_sheet('Data')
ws_summary.write(0,0, pyExcelerator.Formula('Data:A1')) <--- Here it chokes! ws_data.write(0, 0, '4000')
wb.save('not_parsing.xls')
</example>
Is this a bug or am I doing something wrong?
I think you're doing it wrong. ":" character means range, to refer to a
sheet use "!" charater: Data!A1
Marco Aschwanden wrote: Hi,
Yesterday I placed a bug report on PyExcelerators-Sourceforge-page... but I am not so sure anymore, whether this is really a bug - I could imagine that I missed something, but I don't see what. Please confirm that my bug is due to mishandling and I will gladly retreat my bug report.
In a formula, I would like to point to a field on another worksheet. pyExcelerator chokes on these references!
<example>
import pyExcelerator
wb = pyExcelerator.Workbook() ws_summary = wb.add_sheet('Summary') ws_data = wb.add_sheet('Data')
ws_summary.write(0,0, pyExcelerator.Formula('Data:A1')) <--- Here it chokes! ws_data.write(0, 0, '4000')
wb.save('not_parsing.xls')
</example>
Is this a bug or am I doing something wrong?
I think you're doing it wrong. ":" character means range, to refer to a
sheet use "!" charater: Data!A1
On Thu, 17 Nov 2005 09:27:26 +0100, Serge Orlov <Se*********@gmail.com>
wrote: ws_summary.write(0,0, pyExcelerator.Formula('Data:A1')) ws_data.write(0, 0, '4000')
I think you're doing it wrong. ":" character means range, to refer to a sheet use "!" charater: Data!A1
Right you are. It "changed" somehow... anyhow, even if you change it, it
will choke on the same line. I received an answer... a workaround which
doesn't make me happy, but it is, as it is!
[...]
This is not a bug. This is by design. pyExcelerator does not
unerstand such syntax. Try Formula("HYPERLINK(address; name)")
[...]
Which means:
ws_summary.write(0,0, pyExcelerator.Formula('HYPERLINK("Data!A1"))
does the trick, but the text shown is a hyperlink now!
Thanks for your help,
Regards,
Marco
On Thu, 17 Nov 2005 09:27:26 +0100, Serge Orlov <Se*********@gmail.com>
wrote: ws_summary.write(0,0, pyExcelerator.Formula('Data:A1')) ws_data.write(0, 0, '4000')
I think you're doing it wrong. ":" character means range, to refer to a sheet use "!" charater: Data!A1
Right you are. It "changed" somehow... anyhow, even if you change it, it
will choke on the same line. I received an answer... a workaround which
doesn't make me happy, but it is, as it is!
[...]
This is not a bug. This is by design. pyExcelerator does not
unerstand such syntax. Try Formula("HYPERLINK(address; name)")
[...]
Which means:
ws_summary.write(0,0, pyExcelerator.Formula('HYPERLINK("Data!A1"))
does the trick, but the text shown is a hyperlink now!
Thanks for your help,
Regards,
Marco This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Marco Aschwanden |
last post by:
Hi,
Yesterday I placed a bug report on PyExcelerators-Sourceforge-page... but
I am not so sure anymore, whether this is really a bug - I could imagine
that I missed something, but I don't see...
|
by: tkpmep |
last post by:
I downloaded PyExcelerator.zip as I need to write some data into Excel
files, and tried unsuccessfully to install it. I unzipped the files
into C:/Python24/Lib/site-packages/PyExcelerator, and in a...
|
by: tkpmep |
last post by:
I have just installed PyExcelerator, and now want to use it to read
Excel spreadsheets with a variable number of rows and columns and with
multiple sheets. Unfortunately, no documentation seems to...
|
by: Marco Aschwanden |
last post by:
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...
|
by: susan |
last post by:
Hi,
I'm new of Python, and this problem stucked me whole day but can't be
solved.
I use python 2.4.3, which is download from cygwin packages. Then I
downloaded pyexcelerator-0.5.3a, unzip it,
...
|
by: tkpmep |
last post by:
My program creates three lists: the first has dates expressed as
strings, the second has floats that are strictly positive, and the
third has floats that are strictly negative. I have no trouble...
|
by: aneesh.goel.rbtx |
last post by:
I'm using pyExcelerator to take a folder of CSV files and create Excel
workbooks for all of them, then generate an Excel workbook with the
data from all of them.
Everything up until here works...
|
by: patrick.waldo |
last post by:
Hi all,
I was just curious if there was a built-in or a more efficient way to
do take multiple rows of information and write them into excel using
pyExcelerator. This is how I resolved the...
|
by: A_H |
last post by:
Hi, I'm using PyExcelerator, and it's great, but I can't figure out a
few things:
(1) I set the cell style to '0.00%' but the style does not work.
(2) I want to place a border around the...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
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...
| |