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 3621
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: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
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: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |