[Tutor] Scripting Calligra sheets with Python

[Dave Angel]

On 03/18/2013 09:56 PM, Jim Byrnes wrote:
> On 03/18/2013 07:54 PM, Dave Angel wrote:
>> On 03/18/2013 12:18 PM, Jim Byrnes wrote:
>>> I am trying to script Calligra Sheets (formerly KSpread) with python.  I
>>> have gotten some of the included example scripts to run so I know python
>>> scripting is running.
>>>
>>> I found the following snippet on their website:
>>>
>>> import KSpread
>>> sheet = KSpread.view().sheet()
>>> # swap text of B5 and C6
>>> t1 = sheet.text("B5")
>>> t2 = sheet.text(6,3)
>>> sheet.setText("B5", t2)
>>> sheet.setText(6, 3, t1)
>>> # swap value of D7 and E8
>>> v1 = sheet.value("D7")
>>> v2 = sheet.value(8,5)
>>> sheet.setValue("D7", v2)
>>> sheet.setValue(8, 5, v1)
>>>
>>> Error: 'str' object has no attribute 'text'
>>>   File
>>> "file:///usr/share/kde4/apps/sheets/scripts/extensions/myswap.py", line
>>> 4, in <module>
>>>
>>>
>>> This error message appeared in a dialog box.
>>>
>>> I've taught myself some Python but I don't understand what is happening
>>> here.  Shouldn't t1 be a sheet object?  What would cause it to be a str
>>> instead?
>>>
>>
>> Since somebody has censored the rest of the error traceback, we can't
>> even tell what line is giving the error.  Assuming you know it's
>>     t1 = sheet.text("85")
>
> I think line wrapping obscured that it is line 4 t1 = sheet.text("B5").

I saw the line 4, but didn't see anyplace where it showed me line 4.  So 
i had to guess.  And for all I knew, the error isn't happening on that 
line, but on some line called indirectly by that one.  The full stack 
trace would be reassuring.  But apparently your Calligra environment is 
censoring it.

>
>> then it has nothing to do with the type of t1, but with the type of
>> sheet.  If that's the case, then print out type(sheet) and see what it
>> actually is.  Then consult the documentation for the
>> KSpread.view().sheet() function and see what it's documented to return.
>>
>
> The docs say: Returns the KSpread::ViewAdaptor object in which the
> document is displayed.
>
> I would like to follow your advice and print out type(sheet) but right
> now I don't know how.  This is all running inside Calligra sheets and so
> far the only thing I have gotten out if it is the error message.

Are you permitted to edit this myswap.py file?  If so, add a line that 
prints the useful information immediately before the line which causes 
the exception.  And if print is also swallowed by your helpful 
environment, then write to a file.

>
> Thanks for the suggestion, now I can be a little more focused trying to
> figure this out, which is why I asked here first.  I have since taken
> Hugo's advise and posted to the Calligra list also.
>
>

import KSpread
sheet = KSpread.view().sheet()
# swap text of B5 and C6
print "Calling a method on the sheet object, of type", type(sheet)
t1 = sheet.text("B5")

-- 
DaveA