Read Excel File

Hello,
I’m trying to read an excel fil on Grasshoper, using the TT Toolbox. But when I’m choosing the file, this error message appears : “1. Solution exception:Could not load file or assembly ‘NPOI, Version=2.3.0.0, Culture=neutral, PublicKeyToken=0df73ec7942b34e1’ or one of its dependencies. The system cannot find the file specified.”
Thanks for your help
Juliette

I can’t unlock the file…

You tagged this thread with “mac”, but the screenshot shows Windows…

You have to unblock the file, not the folder.
In the second picture you right-clicked the folder.

I usually unblock the .rar,so everything inside will be unblocked, instead of doing it for every file

Thanks for your answer.

Yes I’m working from a Mac, but using Parallels Desktop to have Windows on it.
Oh my bad. But even on the file, the unblock option does not appear…

Thanks, but I can"t unblock anything…

Did you unblock the .gha plugin file in the AppData\Roaming\Grasshopper\Libraries folder?
If not, do that and restart rhino.

I’ve tried but don’t have the option “unblock” in properties…

… is Microsoft Office/Excel installed? Which version?

Windows 10 and Excel 2021

… you have Excel inside parallels or not?
Excel for Windows.

TT Toolbox need windows libraries, if you have Excel for mac installed it doesn’t count.

The inside and outside a VM (like parallels) are like 2 separate machines.

Convert it to .csv, and use Pancake.

This is the ultimate solution to many of my use cases.

IIRC TT Toolbox requires an Office installation.

It’s on my long list to code a Excel-less xlsx reader/writer plugin.

i can offer a old xls reader writer.

XLS.zip (1.4 MB)

unzip the folder and put it in the component folder

or a SQLite plugin that i developed and its eager for testing.

There are many other plugins to read excel in
www.food4rhino.com
You can also use this library:

Extract the files to …\Grasshopper\Libraries:
And try this GH file:

excel reader.gh (11.0 KB)

2 Likes

will be available soon.

image

3 Likes

Just a reminder