readAsStrings Excel Read

[chander_parkash_gupt]

Hi Guys,

Could anyone highlight the meaning of ‘readAsStrings’ ?

Thanks,

Chander.

[john_pierson]

It will pull all of the data from the excel file as strings (Text-ish). Even if they are numbers (integers). This means we can tie that to text parameters in revit right away or insert other strings. It takes a Boolean to toggle it

 

I hope that makes sense.

[john_pierson]

And just to provide a little more info. A string is defined as a sequence of characters.

[chander_parkash_gupt]

Thanks for the prompt response, John !

Pls see attached. Why am i getting an error in reading a simple excel file?

Regards.

[john_pierson]

Add a file from path node between file path and excel read. That should do the trick.

[chander_parkash_gupt]

Beautiful.

Thanks so much, John !

[Williams_Espinosa]

Could you indicate how finally I stay? pls

[sheppe86_sheppe86]

<li style="text-align: left;">My company has apple computers with a windows parallel system. All of the microsoft office products like excel are on the Mac side while Revit and Dynamo are on the windows side. I am trying to reference an excel file to push data into my rooms. However I keep getting an error that "excel is not installed" in Dynamo. Does this have to do with the windows parallel and mac conflict?

[Dimitar_Venkov]

Hi Sheppe,

You could save your spreadsheet as a *.csv file and use the “ImportFromCSV”. Alternatively there’s the “Raindrops” package. I haven’t tested it on the newer versions of Dynamo, but with it you can save your data in a Google spreadsheet and directly read it in Dynamo.