Prode Properties distribution for Windows includes a folder C:/Program Files/Prode/Excel with several examples, if you wish to create a new worksheet include the definitions for Excel VBA, these definitions are available in ppp.vba and instruct Excel about the methods exported by Prode Properties library, you can access these methods from Excel with formulas as =StrGD(1) or VBA, there are other options but those require a knowledge of Office interface, personally i prefer VBA which is simple to learn, also Excel includes a decent debugger which can be helpful to find arrors and mistakes in your code...
You can define streams (list of components, feed, models, BIPs etc.) from VBA or Editor,
from VBA you can start with initS() which clears all contents in specified stream then add components, feed fractions, models etc. and finally call setS() to store values,
you can modify the fractions of each component with putZ(..) and then call setS() to store values
For I = 1 To getCNr(stream)
val = Cells(I + 15, 3)
res = putZ(stream, I, val)
sum = sum + val ' increment total
Next I
see the attached worksheet as example