# Updating Values in Excel

**URL:** <https://forums.eggplantsoftware.com/t/updating-values-in-excel/3798>\
**Category:** Eggplant Functional\
**Tags:** excel, eggplant-functional\
**Created:** [May 9, 2018, 2:03pm UTC](https://forums.eggplantsoftware.com/t/updating-values-in-excel/3798 "2018-05-09T14:03:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![nahmad33](https://forums.eggplantsoftware.com/letter_avatar_proxy/v4/letter/n/b77776/32.png) [@nahmad33](https://forums.eggplantsoftware.com/u/nahmad33)\
**Post date:** [May 9, 2018, 2:03pm UTC](https://forums.eggplantsoftware.com/t/updating-values-in-excel/3798/1 "2018-05-09T14:03:06Z")

</div>

I’m loading an excel doc into eggplant as a database making changes to values in that database but the changes arent taking place in the excel is there another step I’m missing?

---

<div class="post-metadata">

**Author:** ![kenandrus](https://forums.eggplantsoftware.com/letter_avatar_proxy/v4/letter/k/96bed5/32.png) [@kenandrus](https://forums.eggplantsoftware.com/u/kenandrus)\
**Post date:** [May 9, 2018, 2:06pm UTC](https://forums.eggplantsoftware.com/t/updating-values-in-excel/3798/2 "2018-05-09T14:06:39Z")

</div>

Hello Nahmad,  
The recommended method for requesting assistance with Eggplant scripting is that you send questions like this to [support@eggplant.io](mailto:support@eggplant.io). Please send your spreadsheet and the code you are using to write to it also, and we will provide suggestions.  
Regards,  
Ken   
Eggplant Technical Engineer

---

<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 23, 2018, 12:59pm UTC](https://forums.eggplantsoftware.com/t/updating-values-in-excel/3798/3 "2018-05-23T12:59:35Z")

</div>

This may help...  
  
set global myConnectionString to (type:"excel", file:ResourcePath(datafilename), **writable: Yes** ) -- set the specified variable, myConnectionString, to store the contents of the referenced Excel file

  

//set global myTestPatients to table "WorksheetName" of global myConnectionString -- declare worksheet using worksheet name

  

set global CurrentPatient to the record of global myConnectionString where RecNumber is global RecordCountCounter  
  

//set global TestPatient to the record of global myConnectionString where RecNumber is global RecordCountCounter

  

put "x" into global CurrentPatient.scratch -- in this example "scratch" is a column header in my Excel worksheet