Guys, I did this routine in 2019 but I can no longer use it in versions 22 to 24 of revit, is it possible to solve this problem?
This erro
The file:
CRIAÇÃO DE PRANCHA.dyn (35.1 KB)
Lista de folhas.xls (26.5 KB)
The error tells you exactly what’s going on: sheetNumber is expecting a string and you’re providing a double. You need to convert the sheet number to a string.
1 Like
Hi @ELEVENBIM to change the Number (double) to string you can use a node called
Number to String
Hopefully that will solve your problem
i have updated your script working well.
CRIAÇÃO DE PRANCHA.dyn (55.5 KB)
Yes, thank you very much, the problem has been resolved, you can’t imagine how happy you make me, I’ve been trying for months to understand what the problem was.
Could you describe the mistake I was making?
thank so much.
However, the whole numbers have become decimals, is it possible to convert, and leave the whole number in the project number?
Hi @ELEVENBIM, please add these steps to remove decimal values
Earlier you were inputting “sheet number” as a Number but the node required it as a string so we convereted Numbers to string using “String from Object” node.
I hope this resolves your problem. Thanks
1 Like
Hi, you can do it this way 
too with this instruction in codeblock
Math.Floor(a)+"";
if you only have numbers
Sincerely
christian.stan
2 Likes
As an alternate. You can put a true boolean on your read from excel node on the “readassrrings” since you dont need numbers anywhere in your script now
2 Likes