# Data|Shapes ui.filepath and Excel.readfrom file issue

**URL:** <https://forum.dynamobim.com/t/data-shapes-ui-filepath-and-excel-readfrom-file-issue/21779>\
**Category:** Uncategorized\
**Created:** [May 9, 2018, 11:19pm UTC](https://forum.dynamobim.com/t/data-shapes-ui-filepath-and-excel-readfrom-file-issue/21779 "2018-05-09T23:19:49Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![smusitano](https://avatars.discourse-cdn.com/v4/letter/s/71e660/32.png) [@smusitano](https://forum.dynamobim.com/u/smusitano)\
**Post date:** [May 9, 2018, 11:19pm UTC](https://forum.dynamobim.com/t/data-shapes-ui-filepath-and-excel-readfrom-file-issue/21779/1 "2018-05-09T23:19:49Z")

</div>

Evening all,  
Working with Data|shapes UI.FilePath Data node and UI.MultipleInputForm ++ to give user interface to select file from HD. then pass to Excel.ReadFromFile node.  
However it gives an error of incorrect input types, as the file path is not being read as a var. The file path out of the UI.MultipleInputsForm++ is in a list so i have tried to use GetItemAtIndex to exctract, but this doesnt work.

It all works OK, using the dynamo nodes to do the same, but I require the UI dialog so user can select from dir on HD.

See screen grab of what i am doing in test senario,  
 ![Datashapes%20issue](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/f/6f79997a93452dec446e85b262150f2c51207015.PNG)

Any ideas of what i need to do to get the input format correct to read the file using Data|shapes nodes.

Many thanks  
Steve

---

<div class="post-metadata">

**Author:** ![Dharman](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/dharman/32/20649_2.png) [@Dharman](https://forum.dynamobim.com/u/Dharman)\
**Post date:** [May 9, 2018, 11:37pm UTC](https://forum.dynamobim.com/t/data-shapes-ui-filepath-and-excel-readfrom-file-issue/21779/2 "2018-05-09T23:37:05Z")

</div>

Hi Steve,

I’m pretty sure Excel.ReadFromFile takes a file object as input NOT a filepath. You probably need a File.FromPath node between List.GetItemAtIndex and Excel.ReadFromFile

Hope that helps

---

<div class="post-metadata">

**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\
**Post date:** [May 10, 2018, 1:36am UTC](https://forum.dynamobim.com/t/data-shapes-ui-filepath-and-excel-readfrom-file-issue/21779/3 "2018-05-10T01:36:55Z")

</div>

Hi @smusitano @Dharman

@smusitano Your feeding xml file to Excel.Read node where actually the input should be xlsx.

---

<div class="post-metadata">

**Author:** ![smusitano](https://avatars.discourse-cdn.com/v4/letter/s/71e660/32.png) [@smusitano](https://forum.dynamobim.com/u/smusitano)\
**Post date:** [May 10, 2018, 10:58am UTC](https://forum.dynamobim.com/t/data-shapes-ui-filepath-and-excel-readfrom-file-issue/21779/4 "2018-05-10T10:58:19Z")

</div>

Perfect, not sure why i missed that… long day, late night 🙂 !!  
I had it in the original script, but before the List.GetItemAtIndex node. Found the issue to be actually be duplicate List.GetItemAtIndex node on top of each other, one with inputs no output and the other with outputs no input. ahhhhhh

Thanks all sorted now

---

<div class="post-metadata">

**Author:** ![smusitano](https://avatars.discourse-cdn.com/v4/letter/s/71e660/32.png) [@smusitano](https://forum.dynamobim.com/u/smusitano)\
**Post date:** [May 10, 2018, 11:00am UTC](https://forum.dynamobim.com/t/data-shapes-ui-filepath-and-excel-readfrom-file-issue/21779/5 "2018-05-10T11:00:06Z")

</div>

Yes, you are correct Kulkul, I am reading an XML. Excel formats them very nicely to extract info very easily.😀