Grasshopper
Slingshot!
Slingshot! is an Open Source plug-in for connecting Grasshopper to relational databases
Slingshot! features collection of components for reading, writing, and managing relational database systems using SQL.
Slingshot returns "null" data
Hi.
I have been using Slingshot to read Excel files and it has been working fairly good until now.
Sometimes I experienced it returning "null" without me having any idea why. Trying out different things, like closing/opening Excel, closing/opening the GH file etc, have been working previously without leaving a clear solution.
Now finally I can do no small tricks that will make Slingshot return the data from Excel.
Any ideas?
Thanks Rasmus
Nathan Miller
hmmm... I am not completely sure. I have found the OLE DB connection into Excel to be kind of fussy.
Did you recently change your Excel version? I recently built a plug-in that uses some of the same methods and I had to install this since I was using office 64-bit.
http://www.microsoft.com/en-us/download/details.aspx?id=13255
Jan 27, 2014
Jacopo Sartore
Hi Rasmus,
I don't know if you still have this problem, but by following this website's hints (http://www.mikesdotnetting.com/article/280/solved-the-microsoft-ace...) I eventually managed to get a similar definition working on my Windows 7 64-bit system with Office 32-bit. Hope this could help everyone else!
Oct 15, 2015