Error : HRESULT: 0x800A03EC

Revit
1

Hi,

i try the export with dynamo, it fits very good :slight_smile:
but i think it fits only with e few doors.

because i have an error to export the parameter of 300Doors

Fehler-beim-Export.jpg1172×825 138 KB

Excel_Test_Türliste_02.dyn (107.1 KB)

2

Hi Heinrich,

Could you drop your excel file as well?

3

Sicherung-Türdefinition.xlsx (38.2 KB)
this is the file

4

Sorry your script is in German language. May be some one else (@Peter_Kompolschek) who can understand german language better can help you.

5

Don’t know why it doesnt work for you.

Pasted image1875×196 5.67 KB

6

i think, it is the problem, when there are 300 doors or more.
I test it with 50 doors, no problem, but with 250 it is a problem.

can i create a split in the export? after 100 lines, next sheet? only one idea…

7

did you export 1255 doors?

8

Yes, even filled empty values with 0.00. But it works with empty lists too. Maybe no RAM?

9

i have a Win 8.1 PRO with Xeon CPU E5-1620v3 @3.50GHz
RAM: 32GB

I dont think that is the problem

I started a new file, but there I reach the error with only 100doors
another Revit-Projekt with 150 doors are OK.

I dont know what there ist??? :frowning:

10

Maybe dynamo 1.1 can’t handle it. I’ve done this in 1.0

11

I download 1.0.0, but same Problem

no result and every time same error

12

Could you post rvt file with doors? Create array or sth

13

i try it with a new file, seven time I try to export , 5 failed :frowning:

all files i hope you can help me, this is the dyn-file i started

my screencast : http://autode.sk/2bxR8RW

Türen_Export_Dynamo.rvt (1.1 MB)
Tueren.xlsx (51.2 KB)
Excel_Test_Türliste-04.dyn (173.9 KB)

14

Don’t worry we will help you.

15

Hi Heinrich,

@Heinrich_Boldt I modified your script. What it does is that it writes all the parameters with their values to excel. After it writes to excel you can then remove the unwanted parameters from excel. Here is the dyn script Excel_Test_Türliste-04(Kulkul).dyn (20.0 KB)

Doors1.gif1907×971 1.84 MB

16

Sorry,

today I´m so busy, i try to look tomorrow, OK?

one option is, that my Excel2016 is broken, after reinstallation on Monday i can start to test next time i`m in the office ( think on fryday next week)

Thank you

17

I was seeing this when exporting Text Notes with an = symbol in the front of strings

18

I get this same error with Excel.WriteToFile, but not consistently. Maybe 99% of the time. Even when I test it with data as just a dummy string.