how to assign value to Inputfield in the script?

[#1]

I have 6 inputfields, after the user's entered the data, the values are saved in an excel file.

Whenever I add new data to my data model and do a reload, all the values of the input fields are reset to 0, so I need a way to give the user the values that they had entered.

Is there a way to load the excel sheet data and assign the values to specific inputfields on reload/ in the script?

Please its very urgent, any help in this will be greatly appreciated.

Thanks

[alexandros17]

Assign in the script the values from the excel to the variables used for the input field

[#3]

Thanks for the quick response, can you please provide me with an example, I am kinda a newbie.

[#4]

BTW, the inputfield doesnt like it when I assign a variable to it.

say for example:

LET vExcelValue=154;

in the pivot table under the expressions table : InputSum($(vExcelValue)) ... it gives me a '-' hypen