spreadSheetEditor query selection

[tjvoll]

I'm using a spreadSheetEditor to list a set of objects.  My problem is getting a list of rows that are selected (whether the selection is the row itself or the attributes within).

Using selectionConnections I'm able to populate a spreadSheetEditor with a main list of objects, but I'm having no luck retrieving anything from the selectionConnection.  It doesn't seem to perform the same way as with an outerlinerEditor.

Here is a basic example of my script:

string $window = window -widthHeight 400 300;

columnLayout -adj 1;
spreadSheetEditor -keyableOnly 0 lrc_drp_sse;

string $mainList = selectionConnection;
string $selectionList = selectionConnection;

spreadSheetEditor -e -mainListConnection $mainList -selectionConnection $selectionList lrc_drp_sse;

showWindow $window;

selectionConnection -e -s persp $mainList;
selectionConnection -e -s top $mainList;
selectionConnection -e -s front $mainList;
selectionConnection -e -s side $mainList;

So, then i just want to do something like this to get a list of the selected rows in the spread sheet:

selectionConnection -q -obj $selectionList;

thanks,
tom

[tjvoll]

Sorry, i didn't see the -execute flag for the SpreadSheetEditor.  This should do what i need.