My client has some fairly extensive calculations for product manufacture in excel. I am currently attempting to simulate the manufacturing line. My thought is to use excel commands to write values to the spreadsheet and then read back the results. I have this bit of code after an excel open:
excelsetsheet("SH");
excelwritenum(12,3,token.parent.Width+.5);
double myvalue = excelreadnum(17,8);
I am able to read the correct value in myvalue and assert it to a label. However the excelwritenum command does not seem to do anything. I'm guessing the excel sheet needs a recalculate triggered or something. Does anyone have any ideas?
I really do not want to duplicate all the equations in flexsim code.