Uable to read the excel file using TTToolbox

[vijesh (VIJESH KUMAR V)]

Hi all, thanks in advance. I am unable to read the excel file using TTToolbox. An image of the error is placed below.

[tay.othman (tay.0)]

Assigned Grasshopper Category! With excel sub category.

Can you share your system info? It seems that your excel cannot be read. Can you try with another file? Also can you save your file to xls instead xlsx?

[vijesh (VIJESH KUMAR V)]

Win 11, i7. Excel 2016. Using Rhino 6.

.xls also not working.

[tay.othman (tay.0)]

Try another file. Also run command systeminfo

[vijesh (VIJESH KUMAR V)]

Host Name: XXXXXXXXXXX
OS Name: Microsoft Windows 11 Home Single Language
OS Version: 10.0.22621 N/A Build 22621
OS Manufacturer: Microsoft Corporation
OS Configuration: Standalone Workstation
OS Build Type: Multiprocessor Free
Registered Owner: XXXXXXXXXXXXX
Registered Organization: N/A
Product ID: XXXXXXXXXXXXXXXXXXx
Original Install Date: 05-10-2022, 21:19:49
System Boot Time: 15-01-2023, 09:39:52
System Manufacturer: Dell Inc.
System Model: G3 3500
System Type: x64-based PC
Processor(s): 1 Processor(s) Installed.
[01]: Intel64 Family 6 Model 165 Stepping 2 GenuineIntel ~2592 Mhz
BIOS Version: Dell Inc. 1.20.0, 08-09-2022
Windows Directory: C:\WINDOWS
System Directory: C:\WINDOWS\system32
Boot Device: \Device\HarddiskVolume1
System Locale: en-us;English (United States)
Input Locale: 00004009
Time Zone: (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi
Total Physical Memory: 16,146 MB
Available Physical Memory: 3,662 MB
Virtual Memory: Max Size: 32,756 MB
Virtual Memory: Available: 10,439 MB
Virtual Memory: In Use: 22,317 MB
Page File Location(s): C:\pagefile.sys
Domain: WORKGROUP
Logon Server: \XXXXXXXXXXXXX
Hotfix(s): 4 Hotfix(s) Installed.
Network Card(s): 3 NIC(s) Installed.
[01]: Intel(R) Wi-Fi 6 AX201 160MHz
Connection Name: Wi-Fi
DHCP Enabled: Yes
DHCP Server:
IP address(es)
[02]: Killer E2500 Gigabit Ethernet Controller
Connection Name: Ethernet
Status: Media disconnected
[03]: Bluetooth Device (Personal Area Network)
Connection Name: Bluetooth Network Connection
Status: Media disconnected
Hyper-V Requirements: VM Monitor Mode Extensions: Yes
Virtualization Enabled In Firmware: Yes
Second Level Address Translation: Yes
Data Execution Prevention Available: Yes

[tay.othman (tay.0)]

No this,
In rhino Type, SystemInfo and copy paste items here, I’m trying to figure out if another plugin is causing the issue

[Japhy]

If i recall the excel needs to be closed in order to read it.

[nô_si_châu]

Maybe you are using 32 bit excel, change to 64 bit try!

[vijesh (VIJESH KUMAR V)]

Rhino 6 SR35 2021-8-10 (Rhino 6, 6.35.21222.17001, Git hash:master @ 073ac7b225c67348731c6597127b9410126c3139)
License type: Educational, build 2021-08-10
License details: Cloud Zoo. In use by: Vijesh Kumar V ()

Windows 10.0.0 SR0.0 or greater (Physical RAM: 16Gb)
Machine name: VIJUSPIDER

Computer platform: LAPTOP - Plugged in [100% battery remaining]

Hybrid graphics configuration.
Primary display: Intel(R) UHD Graphics (Intel) Memory: 1GB, Driver date: 6-1-2021 (M-D-Y).
> Integrated graphics device with 3 adapter port(s)
- Windows Main Display is laptop’s integrated screen or built-in port
Primary OpenGL: NVIDIA GeForce GTX 1660 Ti (NVidia) Memory: 6GB, Driver date: 5-2-2022 (M-D-Y). OpenGL Ver: 4.6.0 NVIDIA 512.72
> Integrated acclerated graphics device with 4 adapter port(s)
- Secondary monitor is laptop’s integrated screen or built-in port

OpenGL Settings
Safe mode: Off
Use accelerated hardware modes: On
Redraw scene when viewports are exposed: On

Anti-alias mode: 4x
Mip Map Filtering: Linear
Anisotropic Filtering Mode: High

Vendor Name: NVIDIA Corporation
Render version: 4.6
Shading Language: 4.60 NVIDIA
Driver Date: 5-2-2022
Driver Version: 30.0.15.1272
Maximum Texture size: 32768 x 32768
Z-Buffer depth: 24 bits
Maximum Viewport size: 32768 x 32768
Total Video Memory: 6 GB

Rhino plugins
C:\Program Files\Rhino 6\Plug-ins\Commands.rhp “Commands” 6.35.21222.17001
C:\Program Files\Rhino 6\Plug-ins\rdk.rhp “Renderer Development Kit”
C:\Program Files\Rhino 6\Plug-ins\RhinoRender.rhp “Rhino Render”
C:\Program Files\Rhino 6\Plug-ins\rdk_etoui.rhp “RDK_EtoUI” 6.35.21222.17001
C:\Program Files\Rhino 6\Plug-ins\rdk_ui.rhp “Renderer Development Kit UI”
C:\Program Files\Rhino 6\Plug-ins\NamedSnapshots.rhp “Snapshots”
C:\Program Files\Rhino 6\Plug-ins\IronPython\RhinoDLR_Python.rhp “IronPython” 6.35.21222.17001
C:\Program Files\Rhino 6\Plug-ins\RhinoCycles.rhp “RhinoCycles” 6.35.21222.17001
C:\Program Files\Rhino 6\Plug-ins\Grasshopper\GrasshopperPlugin.rhp “Grasshopper” 6.35.21222.17001
C:\Program Files\Rhino 6\Plug-ins\Toolbars\Toolbars.rhp “Toolbars” 6.35.21222.17001
C:\Program Files\Rhino 6\Plug-ins\3dxrhino.rhp “3Dconnexion 3D Mouse”
C:\Program Files\Rhino 6\Plug-ins\Displacement.rhp “Displacement”

[vijesh (VIJESH KUMAR V)]

am using 64bit

[vijesh (VIJESH KUMAR V)]

closed and only read.

[wim (Wim Dekeyser)]

Hi -
Have you tried any of the other Excel reader plug-ins for Grasshopper? → https://www.food4rhino.com/en/browse?searchText=excel&form_build_count=1&sort_by=score
One user especially liked NPOI:

Import and export Excel files with the NPOI plugin : EXCELLENT!

This Plugin rocks ! NPOI_Excel Plugin -No need for Excel to be opened -Very fast write -Ability to create files with multiple worksheets -Import and export of cell ranges -… It is based on NPOI, a Dot Net port of POI , a java library allowing to read and wrtite multiple Microsoft formats. The example file is partly in Chinese, but I have translated it in English here : ExcelExample-Translated.gh (17.8 KB)

-wim

[gankeyu (Keyu Gan)]

You may also try PancakeSpreadsheet, which is also based on NPOI. The original NPOI plugin has issues with newer Rhino (7/8).

PancakeSpreadsheet