# How to Open an Excel file at a share and copy/paste its fields

**URL:** <https://forums.eggplantsoftware.com/t/how-to-open-an-excel-file-at-a-share-and-copy-paste-its-fields/8819>\
**Category:** Eggplant Functional\
**Tags:** eggplant-functional\
**Created:** [May 2, 2024, 6:38pm UTC](https://forums.eggplantsoftware.com/t/how-to-open-an-excel-file-at-a-share-and-copy-paste-its-fields/8819 "2024-05-02T18:38:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![lordjans](https://forums.eggplantsoftware.com/letter_avatar_proxy/v4/letter/l/3ab097/32.png) [@lordjans](https://forums.eggplantsoftware.com/u/lordjans)\
**Post date:** [May 2, 2024, 6:38pm UTC](https://forums.eggplantsoftware.com/t/how-to-open-an-excel-file-at-a-share-and-copy-paste-its-fields/8819/1 "2024-05-02T18:38:35Z")

</div>

I’m extremely green with this scripting tool and i need assistance please. Below the issue:

We are attempting to automate the provisioning of access for our users into our vendors’ portals, and we want to in-concept, use a spreadsheet copy/paste the user/access information into the website portal, that way avoiding mistakes.

I already have a script with defined information that proves that the website accepts the action, but i need an input on a spreadsheet which is already defined.

**(What needs be done)**  
I need to open a file (excel) with-in our shares and, use it as an input to copy/paste the already defined fields into a website fields.

Thank you.

---

<div class="post-metadata">

**Author:** ![DaveHester](https://forums.eggplantsoftware.com/user_avatar/forums.eggplantsoftware.com/davehester/32/104_2.png) [@DaveHester](https://forums.eggplantsoftware.com/u/DaveHester)\
**Post date:** [May 3, 2024, 10:31pm UTC](https://forums.eggplantsoftware.com/t/how-to-open-an-excel-file-at-a-share-and-copy-paste-its-fields/8819/2 "2024-05-03T22:31:09Z")

</div>

I think that you will find the information you need here: [Working with Excel as a Database | EPF Docs](https://docs.eggplantsoftware.com/studio/stk-working-with-excel/#configuring-the-excel-file-database-connection)

Otherwise, please post a response and we can work on a solution for you.

---

<div class="post-metadata">

**Author:** ![lordjans](https://forums.eggplantsoftware.com/letter_avatar_proxy/v4/letter/l/3ab097/32.png) [@lordjans](https://forums.eggplantsoftware.com/u/lordjans)\
**Post date:** [May 6, 2024, 1:29pm UTC](https://forums.eggplantsoftware.com/t/how-to-open-an-excel-file-at-a-share-and-copy-paste-its-fields/8819/3 "2024-05-06T13:29:39Z")

</div>

Hello,

Thank you for the provided information, doing so and done… now how can i make it copy/paste the defined fields in the spreadsheet. I’m pasting it into a site, and the fields there are already defined. Is the copy/paste action the one that i need.

Sample:

User First Name  
Peter \<— Copy/Paste

Thank you

Jans de los Santos