On 03/19/2013 09:16 PM, Jim Byrnes wrote:
On 03/18/2013 11:25 PM, Dave Angel wrote:
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.
Yes I can and it does swallow it, so I redirected to a file and it says
<type 'str'>. Same as the error message. So now I need to figure out
why it's not returning the object expected.
I can run the sample scripts that were installed but not something I
originate. I guess I must be missing something procedural that is
keeping them from running properly.
Thanks for you help.
Regards, Jim
Just a follow up for completeness in case some else finds this and has
the same problem.
Replace line 2 sheet = KSpread.view().sheet()
with
sheetname = KSpread.currentSheet().sheetName()
sheet = KSpread.sheetByName(sheetname)
Then it will run with no errors.
Regards, Jim
_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor
