I’m exporting some info to Excel and then later reading it back in. The problem I’m having right now is with Element IDs. I thought I was doing List.IndexOf (or List.AllIndicesOf) wrong, but it turns out that when I read the IDs in from Excel, they come in as Doubles, but when I get an Element ID …

OK, I found the String.ToNumber node, which helps a bit. But, still: YEEESH I have to jump through a LOT of hoops converting things back and forth just to compare a number with a decimal to an integer, even if they are have same value. If Math.Round could handle a List, or if IndexOf could compare…

[image] DaveP: I’ve also tried Math.Round, but that can’t handle arrays, just single values. Math.Round can handle lists. Have you tried to change the lacing? It will not give you a integer type though: [image]

Thank you for this Einar! The 2’nd option worked fantastic for me! This was precisely the last key in a script that I’ve been thinking about for two days!! Will save us countless hours of time in the future :smiley:

I usually just convert the IDs to text for export and import and reformat them as needed. Integers will convert nicely to text. Doubles will not, which is where integer conversion is absolutely necessary to avoid pointless rounding zeros.

Convert Double to Integer

FAQ

Einar_Raknes September 9, 2016, 7:41pm 3

12 Likes

Change the revit family parameter depend on the element ID?

Id(s) to Family types

Topic		Replies	Views
Convert to integer in if statement codeblock Revit codeblock , dynamo	5	1879	March 31, 2022
Round numbers and join text in the same row Revit excel	13	1564	August 12, 2019
List.IndexOf not giving desired Result Revit	8	2427	November 16, 2018
List.IndexOf node → -1 result, not constantly while input is the same Revit excel	6	146	January 20, 2025
How to get element by id from Excel? Developers revit , python	3	2206	December 8, 2016

Convert Double to Integer

Related topics