PyExcelerator - mishandling of formulas?

Marco Aschwanden PPNTWIMBXFFC at spammotel.com
Thu Nov 17 17:11:04 CET 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