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

Replies to This Discussion

Permalink Reply by Nathan Miller on January 27, 2014 at 7:51pm

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

Permalink Reply by Rasmus Holst on January 28, 2014 at 1:09am

Hi Nathan.

No I didn't change Excel version, but I did however change from Rhino 32 to 64bit.

I just tried your link. It seems my Excel version is 32 bit - Is that a problem?

Permalink Reply by Jacopo Sartore on October 15, 2015 at 4:06am

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!

RSS