Excel module for export and import

General
1

Not sure whether this has been discussed before and apologies if so, could you include a module to allow export an import to excel files?

2

Hey there ! Can you please describe this a bit more ? Is this about storing spreadsheets on the platform and accessing them from within the tools ?

3

Hi, apologies I’ve just cracked it by using the ‘clr.AddReference(“Microsoft.Office.Interop.Excel”)’ I can export a schedule to excel. And in answer to your question yes.

1 Like
4

This is in OkPy right?

Regarding accessing spreadsheets (and other resources) on the platform, it’s on the roadmap! There’s some things we need done before but we’ll enable that within a couple of releases .

5

We have improve Excel interop by giving the OkPy agent an excel toolkit! Try it out if you can in [2.0.0.9](Release 2.0.0.9 ¡ OrkestraOnline/Orkestra_Online ¡ GitHub) :slight_smile:

6

I tried using c# and it worked in 2.0.0.7 for importing and exporting excel haven’t tried python but will do. C# works well and this is brilliant being able to code and test in. Interesting I’ve just downloaded and tested 2.0.0.9 and when importing a OKQAZIP file everything disappears and Revit crashes same happened in 2.0.0.7. Luckily I’m testing on another pc don’t want to update the work pc until this resolves. Is this something you are aware of? This is all excellent stuff thought.

1 Like
7

Thanks so much @Greyboots ! Super glad you like it :grin: . And believe me it only gets better from here !

We’ll look into okqazip import crash. We had a github issue that could be related . We’ll report progress here .