Hie, I have done a list of numbers and a export of that numbers to excel. The problem is that in excel in the place of one value appears a blank space and i don´t understand why. In the the second column appear 105.27, in the fith appear 108.64 but in the eighth not appear 111.11 and appear a blan…

Round the values before export.

Hey, Maybe this is useful? [image] Cheers, Mark

Hey hey, replacing nulls by a 0 value should do the trick

[image] Trying to change a NULL parameter value Revit Try this [image]

Thanks a lot. I try it but appear the blank space also. Regards [image] [image]

Thanks. The problem is that in Dynamo the value exist but in one moment it dissapear. Do yo know how i can locate the item with null value in a list? Regards

Thanks. The problem is that in Dynamo the value exist but in one moment it dissapear. Regards

I can see from the table that the data is offset because of null values. try following the steps in the post links I gave earlier to identify and replace nulls.

Hey, I would try and make a simple example to test… One you could post here? Sometimes the null is because of transpose nodes… If there are different amounts of values you get nulls to make the list lengths the same… [image] Hope that helps, Mark

Thanks. I think so but i couldn´t find the problem. Regards.

Blank space in a excel export

Uncategorized

Jean-Marc October 21, 2020, 7:44am 5

Topic		Replies	Views
Excel Producing False Null Values Lists-Logic	19	3180	January 24, 2017
How to get rid of null? Uncategorized	3	558	April 28, 2020
Create Sublists/Shift Indices? Packages	28	2113	February 11, 2015
Export values to Excel Revit	1	647	December 16, 2016
Excel.WriteToFile gives null value even after boolean filtering mask Revit excel , dynamo	4	827	July 26, 2018

Blank space in a excel export

Related topics