Dynamo export excel fails

Revit
1

Hi.
I am trying to run a very simple script to export one schedule to excel. But it is not working. Anyone can help me?

imagem
imagem1920×1046 143 KB

2

Hi @aafonsoBYKA8

What’s your Revit Version?

3

I think overWrite option causes that problem. It is a bug in Dynamo because it deletes the sheet and creates a new one. While that happens, it is shown an warning message…
Try to do it without overWrite and select a new path.

4

revit 2022.1

5

I just tried that and the operation fails.
It is very frustrating. I just need to find a way to export several schedules to excel… I really dont understand why this very simple thing isnt working.

6

What is shown if you click on “Read more”?

7

You can send file sample error to here ? I will review and edit it in open source. I have also seen quite a few questions about this.

8

@aafonsoBYKA8 Try using OpnXML export nodes. It’s available for Revit 2022.1:

10_OpenXML_Nodes
10_OpenXML_Nodes1920×884 74.1 KB

1 Like
9

A couple of thoughts:

  1. you are writing a schedule to excel. It would probably be more simple to export as a text, and import the data into excel via the text file.

This offers a nice workflow as you can create a more dynamic link to the data and any post-processing operations in excel, even within the same sheet.

  1. there is an excellent add-in from bimONE for writing to excel, which also offers bidirectional exchanges. Doesn’t work well for type-based tables.

  2. regarding your error explicitly. Maybe you need to explicitly set the last Boolean to write as strings?

  3. Otherwise, you might try replace by condition using the ‚isnull‘ node to clean your data. I doubt this is the issue. I’ve sent ‚null‘ to excel many times…but perhaps if you are not formatting as strings, this is causing an error.

10

Thank you. I tried like that, but still not working

imagem
imagem484×532 85 KB

11

imagem
imagem1688×675 310 KB

12

Now it only shows this

imagem
imagem2104×776 342 KB

13

I cant upload files because I am a new member.
Here is a link to download the file.
Hope you can help me.

https://we.tl/t-OnCZWPLhrX

14

Check this:

15

This about importing. My issue is when exporting.

16

Do u have null data in your schedule, meaning empty cells? I have seen that cause this issue.

Try to export out a single item from the list where all 4 values exist and see if it fails.

Sched[0] from the image appears to have all values

Then try with one that doesn’t or doesn’t appear to anyway

Sched[1]

17

Hi Teresa,

till we get a solution to your problem, you can use these-

image
image857×463 32 KB

let us know if it worked.
Regards,
ap

1 Like
18

I have no null values

imagem
imagem1920×1074 193 KB

19

Does it work if you use a single list item as I suggested?

The grouping headers are potentially causing the issue.
image

image

20

Thank you!
It exports like this.

imagem
imagem638×1437 45.5 KB

Do you know how I can get it into diferent columns?