# How to read data from template xlxs input file

**URL:** <https://community.automationedge.com/t/how-to-read-data-from-template-xlxs-input-file/4885>\
**Category:** Process Studio\
**Tags:** rpa, article, learning, process-studio, generic\
**Created:** [October 7, 2021, 5:07am UTC](https://community.automationedge.com/t/how-to-read-data-from-template-xlxs-input-file/4885 "2021-10-07T05:07:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jayesh.gosavi](https://avatars.discourse-cdn.com/v4/letter/j/919ad9/32.png) [@jayesh.gosavi](https://community.automationedge.com/u/jayesh.gosavi)\
**Post date:** [October 7, 2021, 5:07am UTC](https://community.automationedge.com/t/how-to-read-data-from-template-xlxs-input-file/4885/1 "2021-10-07T05:07:40Z")

</div>

I want to read the data from an excel file which is in template format, I have tried using the Microsoft input plugin but it doesn’t work, can anyone help me with this.

---

<div class="post-metadata">

**Author:** ![Garr14](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.automationedge.com/garr14/32/824_2.png) [@Garr14](https://community.automationedge.com/u/Garr14)\
**Post date:** [October 8, 2021, 2:42am UTC](https://community.automationedge.com/t/how-to-read-data-from-template-xlxs-input-file/4885/2 "2021-10-08T02:42:49Z")

</div>

Hello Jayesh,

Can you share the workflow you have created which uses template and other files as well?

---

<div class="post-metadata">

**Author:** ![jayesh.gosavi](https://avatars.discourse-cdn.com/v4/letter/j/919ad9/32.png) [@jayesh.gosavi](https://community.automationedge.com/u/jayesh.gosavi)\
**Post date:** [October 9, 2021, 4:19am UTC](https://community.automationedge.com/t/how-to-read-data-from-template-xlxs-input-file/4885/3 "2021-10-09T04:19:06Z")

</div>

Here is the demo workflow and the input file, my requirement is to fetch the details as path, display name and members from the excel file.

[DEMO\_2.psw](https://community.automationedge.com/uploads/short-url/7NJeQRD36swrGHqrZWnBCDm8Nzp.psw) (17.6 KB)

[ADMPReport\_COMPANY.xlsx](https://community.automationedge.com/uploads/short-url/1umCFqHDGj0TkkFvqrecUEZGAXL.xlsx) (47.2 KB)

---

<div class="post-metadata">

**Author:** ![Garr14](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.automationedge.com/garr14/32/824_2.png) [@Garr14](https://community.automationedge.com/u/Garr14)\
**Post date:** [October 13, 2021, 1:20am UTC](https://community.automationedge.com/t/how-to-read-data-from-template-xlxs-input-file/4885/4 "2021-10-13T01:20:51Z")

</div>

@jayesh.gosavi

As per the information you have provided, it doesnt seems to be possible to use plugin to achieve this.

We would suggest Java code to fetch these details.

---

<div class="post-metadata">

**Author:** ![jayesh.gosavi](https://avatars.discourse-cdn.com/v4/letter/j/919ad9/32.png) [@jayesh.gosavi](https://community.automationedge.com/u/jayesh.gosavi)\
**Post date:** [October 13, 2021, 3:48am UTC](https://community.automationedge.com/t/how-to-read-data-from-template-xlxs-input-file/4885/5 "2021-10-13T03:48:46Z")

</div>

okay thank you
