05-11-2012, 03:37 PM
Create a function file for excel reading and updating.
EX: 1) Create a excel file and put variable name in 1st column and its value in 2nd column.( One time activity)
2) Read all the value from your application.
3) Read the excel file using already created function and compare each variable name and it's value with application.
3) If any mismatch in value between application and excel update the excel with new value
4) else read the existing value or use the application value.
Execution of above function once in a week or before execution of your script is your choice.
EX: 1) Create a excel file and put variable name in 1st column and its value in 2nd column.( One time activity)
2) Read all the value from your application.
3) Read the excel file using already created function and compare each variable name and it's value with application.
3) If any mismatch in value between application and excel update the excel with new value
4) else read the existing value or use the application value.
Execution of above function once in a week or before execution of your script is your choice.