# String from object problem when I import data from excel

**URL:** <https://forum.dynamobim.com/t/string-from-object-problem-when-i-import-data-from-excel/81775>\
**Category:** Uncategorized\
**Created:** [October 5, 2022, 12:24pm UTC](https://forum.dynamobim.com/t/string-from-object-problem-when-i-import-data-from-excel/81775 "2022-10-05T12:24:23Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![eness.gun](https://avatars.discourse-cdn.com/v4/letter/e/b19c9b/32.png) [@eness.gun](https://forum.dynamobim.com/u/eness.gun)\
**Post date:** [October 5, 2022, 12:24pm UTC](https://forum.dynamobim.com/t/string-from-object-problem-when-i-import-data-from-excel/81775/1 "2022-10-05T12:24:23Z")

</div>

Hello everyone,

Data has failed if I manipulate data used with read as a string node.  
Could you please help me to get data without “,” as a string.

Thank you .

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/0/d01d10ea6bfede1133e89ec3fb9a72097e44b1f4.png)

---

<div class="post-metadata">

**Author:** ![sovitek](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/sovitek/32/116237_2.png) [@sovitek](https://forum.dynamobim.com/u/sovitek)\
**Post date:** [October 5, 2022, 12:30pm UTC](https://forum.dynamobim.com/t/string-from-object-problem-when-i-import-data-from-excel/81775/2 "2022-10-05T12:30:00Z")

</div>

Hello @eness.gun ,could number to string from spring help you?

 ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/e/ae3a4d260d52f7504b0873a812a4395bc930ad6a.png)

---

<div class="post-metadata">

**Author:** ![eness.gun](https://avatars.discourse-cdn.com/v4/letter/e/b19c9b/32.png) [@eness.gun](https://forum.dynamobim.com/u/eness.gun)\
**Post date:** [October 5, 2022, 12:35pm UTC](https://forum.dynamobim.com/t/string-from-object-problem-when-i-import-data-from-excel/81775/3 "2022-10-05T12:35:43Z")

</div>

What is this package name ?

---

<div class="post-metadata">

**Author:** ![sovitek](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/sovitek/32/116237_2.png) [@sovitek](https://forum.dynamobim.com/u/sovitek)\
**Post date:** [October 5, 2022, 12:37pm UTC](https://forum.dynamobim.com/t/string-from-object-problem-when-i-import-data-from-excel/81775/4 "2022-10-05T12:37:16Z")

</div>

spring nodes

---

<div class="post-metadata">

**Author:** ![eness.gun](https://avatars.discourse-cdn.com/v4/letter/e/b19c9b/32.png) [@eness.gun](https://forum.dynamobim.com/u/eness.gun)\
**Post date:** [October 5, 2022, 12:52pm UTC](https://forum.dynamobim.com/t/string-from-object-problem-when-i-import-data-from-excel/81775/5 "2022-10-05T12:52:09Z")

</div>

Thank you but I have different problem about to == node.  
What do you think about it ? Why are all element output are false ?

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/b/fb059860302dd008048decbf5aa8dce8d4db8e19.png)

---

<div class="post-metadata">

**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\
**Post date:** [October 5, 2022, 1:08pm UTC](https://forum.dynamobim.com/t/string-from-object-problem-when-i-import-data-from-excel/81775/6 "2022-10-05T13:08:01Z")

</div>

If that’s not what you were expecting then I’d guess it’s an issue with list levels. Are the lists the exact same? How are you trying to order them? We can’t give you much help if we don’t know what you’re after.

And as an FYI, the reason you’re getting trailing zeros on your string conversion is because the numbers are stored as doubles. If you convert the doubles to integers (I suggest `Math.Floor`) they will convert without the trailing zeros.

---

<div class="post-metadata">

**Author:** ![sovitek](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/sovitek/32/116237_2.png) [@sovitek](https://forum.dynamobim.com/u/sovitek)\
**Post date:** [October 5, 2022, 1:10pm UTC](https://forum.dynamobim.com/t/string-from-object-problem-when-i-import-data-from-excel/81775/7 "2022-10-05T13:10:51Z")

</div>

Yes very importent is the same objecttype…you need cross product i think…

 ![Capture.PNG](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/e/6e42c523425c9f57bb93b035589267f094c9712e.jpeg)

---

<div class="post-metadata">

**Author:** ![eness.gun](https://avatars.discourse-cdn.com/v4/letter/e/b19c9b/32.png) [@eness.gun](https://forum.dynamobim.com/u/eness.gun)\
**Post date:** [October 5, 2022, 2:20pm UTC](https://forum.dynamobim.com/t/string-from-object-problem-when-i-import-data-from-excel/81775/8 "2022-10-05T14:20:41Z")

</div>

I have solved this program with basic python code.  
If we create set from list that can solve.

![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/a/1acdacc8efaee0aad5cb00b43db10a47ecbd07cc.png)
