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
_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor
