how to read excel file in an array of strings

[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 !.

[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

[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