Page 1 of 1

how to read excel file in an array of strings

Posted: 05 Apr 2014, 18:51
by adhamdwikat
how can read complete excel column and store it in the script node in an array of strings ?
the way i thought about was to traverse the rows one by one form an excel node once the scene loads , but in this way I am only able to store 1 row at every frame , so assume i have 200 rows and my project is 25 FPS then the process will take 8 seconds which is long time !.

Re: how to read excel file in an array of strings

Posted: 08 Apr 2014, 19:16
by lerou
I would suggest the Excel Range Array.. but for some reason that one only reads floats :/

You could script it yourself, I guess.

cheers,
rou

Re: how to read excel file in an array of strings

Posted: 18 Apr 2014, 11:34
by joschy
try this:
http://www.gemboxsoftware.com/spreadsheet/overview

They have a free version, Maximum number of rows per sheet is 150.
I have used it successful with ventuz to write in a excelsheet. They have a bunch of functionality.

joschy