18 January 2026:
Sahi Pro is an enterprise grade test automation platform which can automate web, mobile, API, windows and java based applications and SAP.
This forum is now archived and is in read-only mode. Please continue discussions on our improved new Sahi Pro Community forum.
Sahi Pro is an enterprise grade test automation platform which can automate web, mobile, API, windows and java based applications and SAP.
How to commit changes in Excel
paidavamshi
Members
When am writing some values to Excel, in the same function am trying to read the same value immediately after writing it, am getting Null
to write the values in to Excel i used the below script
_set($ContractRef, _getText(_textbox(1)));
db.update("update [Contract$] set Contract = '"+$ContractRef+"'");
to get the values from the Excel i used the below script
_setValue(_textbox(1),($Contract[0]["Contract"]));
The value is stored in the excel when we open and check it.
Is there any commands to Commit changes to Excel
Regards,
Vamshi
to write the values in to Excel i used the below script
_set($ContractRef, _getText(_textbox(1)));
db.update("update [Contract$] set Contract = '"+$ContractRef+"'");
to get the values from the Excel i used the below script
_setValue(_textbox(1),($Contract[0]["Contract"]));
The value is stored in the excel when we open and check it.
Is there any commands to Commit changes to Excel
Regards,
Vamshi
Comments
I got the solution.
I declared below variable in variables library, so initially it is taking all the values from Excel->Contract sheet(which is null)
$Contract=db.select("select * from [Contract$]");
_setValue(_textbox(1),($Contract[0]["Contract"]));
So now i placed the same script after writing the values into Excel now my script look like
_set($ContractRef, _getText(_textbox(1)));
db.update("update [Contract$] set Contract = '"+$ContractRef+"'");
then
$Contract=db.select("select * from [Contract$]");
_setValue(_textbox(1),($Contract[0]["Contract"]));
So it worked
Thanks and regards,
Vamshi Paida