Open Office instead of Excel

[vargas.michaeljoshua]

I don’t have MS Office Excel but I’m using Open Office. What should I do in order to read the open office file? I can’t find a node for open office.

[Renzoj14]

As far as I know there isn’t a out of the box node for that. Check the package manager or else get excel installed

[jacob.small]

If open office can save out to a CSV (fairly certain it does) than that is an option.

[Andrew_Hannell]

I have not tried this, but I believe you can create an ODBC connection an ODS file
I don’t know if OpenOffice install necessary drivers by default

Similar to this:

https://sea2.discourse-cdn.com/business6/uploads/dynamobim/optimized/2X/c/c02d96cd333eecbd17223369f802321370056848_1_690x388.PNG

Pushing a formula to Excel from a Dynamo String

I agree with the database idea- although you probably don’t want to reinvent everything if it is now (almost) working MSAccess is problematic, particularly with 64bit operating systems I have successfully used Dynamo with the free version of SQL server (used to be called SQLExpress, think it is something different now) The joins/lookups of data would probably be much easier in an SQL query. You can easily link the SQL tables back into MSAccess or Excel for reporting.

[vargas.michaeljoshua]

Thank you sir! I’m trying to install Excel to ease the pain.

[vargas.michaeljoshua]

Thank you for help Sir! Actually I’m a newbie here, so I will try to comprehend this sample.

[Renzoj14]

No problems, while most of the time there is a work around, always try to solve the problem from root