PyExcelerator - mishandling of formulas?
Marco Aschwanden
PPNTWIMBXFFC at spammotel.com
Thu Nov 17 11:11:04 EST 2005
On Thu, 17 Nov 2005 09:27:26 +0100, Serge Orlov <Serge.Orlov at 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
More information about the Python-list
mailing list