October 12, 2022, 5:00pm
I was playing around with the Excel connector and created a list in Grasshopper.
Receiving that in Excel takes about 4 long minutes for about 450 rows with 4 columns each.
Is that the expected performance or is there something wrong with my setup?
October 12, 2022, 8:31pm
That’s definitely not the expected behavior!
Any chance you can share a sample stream for us to debug?
October 13, 2022, 7:41am
I created a test stream here:
Speckle (for some reason I can´t access speckle.xyz with my speckle connector, but the data should be the same as in the example from yesterday)
A few things I noticed:
If I use ‘Receive last selection’ it only takes a few seconds
If I receive the root object it also only takes a few seconds
I want my data to come through properly formatted though (which it doesn´t if I receive the root object)
Thus I had to ‘rewire’ my speckle objects in GH…
and select the child of the root object (the list with 455 elements, see above) to get it into excel properly, which takes now only 2 long minutes not being behind a vpn today…
October 27, 2022, 2:27pm
another question related to the Excel connector. I have the following workflow:
Creating a custom Speckle objects in Grasshopper
Receiving that stream in Excel
Altering some of the data
Sending it back from Excel
Receiving the altered stream in Grasshopper
Unfortunately step 5 fails with the error “Input object is not a Speckle object, nor can it be converted to one.”
Should that normally work?
October 27, 2022, 2:36pm
Would it be possible to share with us the stream and excel sheet?
This should be supported but there may be some extra documenting needed on our side to clarify some things
October 27, 2022, 3:06pm
I can´t create a “real” stream because somehow my Excel connector doesn´t work with speckle.xyz…
I attached a .gh script to showcase how I create the initial stream and a Excel sheet to illustrate how it looks received in Excel.
fake data from attached script:
real data (can´t share the script): Speckle
speckle.xlsx (19.0 KB)
excel.gh (8.8 KB)
October 27, 2022, 5:13pm
I Just debugged the slowness issue, it seems to be because each element is detached and that’s causing an extra API call. As a matter of fact, 455 * 0.15-0.3 sec results in approx 2 min.
Can you disable detaching on your source elements and try again?
I’ll also ping
@dimitrie to see if it’s normal that the object loader takes so long to retrieve such simple objects. Ofc, the calls could be parallelized as well…
Load last received works much faster as it’s pulling some cached data
Receive last selection:
November 2, 2022, 4:25pm
Ok, for everyone else eventually reading this thread: setting ‘range with headers’ in Excel did the trick (pretty obvious actually), now receiving in Grasshopper works like a charm
November 4, 2022, 10:23am
Some more feedback on the Excel connector…
Can we make the connector remember the stream & branch of each individual sheet?
If you send to multiple branches in the same book, you most certainly end up sending to the wrong branches since it seems to pick the last used one (of a different sheet eventually).
November 4, 2022, 10:53am
Do you mean saving the stream cards per sheet instead of per workbook?
It can probably be done!
November 14, 2022, 9:44pm
January 26, 2023, 4:09pm
@connor and @gjedlicska have improved the receive logic and made the connector much faster; an update will come very soon!