Dynamo Data.ExportToExcel Problems

Revit
, ,
1

Hi All,

I’m currently trying to export some data into excel and I’m running into a couple issues.
I’ve created a couple lists for model changes, and created sub-lists to break them up.

But when I try to use the Data.ExportToExcel node, I just get a Warning saying “Warning: Data.ExportToExcel has failed”. I’ve dug around some forums and checked some videos and see other peoples Excel export node doesn’t have the “WriteAsString” input where mine does but its just a boolean that’s default to False. (Tried False / True).

I’ve seen a few people mention it can be due to windows updates and to try the XML Export instead which has a boolean ouput instead of data, but it doesn’t do anything and doesn’t open the Excel file upon running the script. Then when I try and open the Excel file manually I get an error message and that the file needs recovered.

Any Ideas?

Thanks

image
image823×617 85.9 KB

2

Have you tried putting the filepath in as a string?

Use the string from object node between the file path node and the excel node.

Also, what does the yellow warning say?

4

Yea I tried the string input too, had the same issue with both XML and Export.
The warning just says “Warning: Data.ExportToExcel has failed”

image

5

Wow, what a helpful message :joy:

Have you tried feeding in a single string as the data to see if that prints anything?

Have you checked your sheet name is correct?

Have you tried putting the same node on the canvas and rewriting it (sometimes they corrupt)

6

Just opened the excel file and it seems that changing the file path to a string sorted it with the Data.OpenXMLExportExcel node instead of the Data.ExportToExcel Node. But when I open the excel file after running the script it asks me to recover the file and I get this error report:

image
image2093×1006 245 KB

Weird, why do you think that is?

Thanks for the help!

7

If you open task manager do you have excel running in the background?

I’ve; found a couple of times Dynamo doesn’t seem to shut excel properly- particularly if I use the BumbleBee node (I know you’re not).

Have you tried with a new, blank excel sheet?

8

Yea I tried a couple different excel files, and no excel isn’t running in the background from what I can see on task manager.

It seems to have completed the task now I have the excel file with the information I need, but I’m not looking to have to check an error report every time I want to run the script. Might dig round and see if there are other ways I can do it, thanks

1 Like