reading from excel

hello,

i am reopening a file from a few months ago. i didn't change anything within the script or in the spreadsheet since the last time i used it, when it worked. the only thing i changed was the location of the files, and i have reset the file path, so i'm not sure why the spreadsheet reader component is returning the error message: "solution exception: the type initializer.'

i am trying to have grasshopper read the data from an excel spreadsheet. this script once worked. does anyone know how i can get it to work again?

thank you~

Attachments:

spreadsheet reader.gh, 9 KB
screenshot.JPG, 86 KB

Replies to This Discussion

Permalink Reply by Prentiss Darden on April 21, 2014 at 9:17am

there was a reply to this, but now it is gone... does anyone know of a solution? thank you.

Permalink Reply by Prentiss Darden on April 21, 2014 at 10:43pm

i realized i didn't have the Open XML SDK installed, and now that i do, the error that said "1. Solution exception:The type initializer for 'ClosedXML.Excel.XLWorkbook' threw an exception" is gone, but now i receive a new error message: "1. Solution exception: Object reference not set to an instance of an object."

i tried attaching a different excel file and that worked fine, it's just this file that isn't working properly.

the spreadsheet is a simple list of 13 points with (x,y,z) coordinates that i'd like to make a mesh from.

any suggestions? files attached. thank you.

Attachments: