Transcription of Advanced Scripting: Running Excel from Lua
{{id}} {{{paragraph}}}
Thermoflow, Inc. 2018 Webinar on Advanced Scripting: Running Excel from Lua, February, 2018 David LopezAdvanced Scripting: Running Excel from LuaHarvesting GT Data from Excel Thermoflow, Inc. 2018 Webinar on Advanced Scripting: Running Excel from Lua, February, 2018 David LopezScripting: Brief Overview Use your own logic to: Create a new, custom output parameter Programmatically set existing model inputs Define your own functions, call external Thermoflowprograms use the open-source scripting language Lua Thermoflow, Inc. 2018 Webinar on Advanced Scripting: Running Excel from Lua, February, 2018 David LopezScript Definition Need to define: What it produces: New, custom outputs Choose model input(s) to set What it needs: Model inputs or outputs When it happens: Before calculation begins (initialization / to set inputs once) During the loop (to set inputs each loop) THERMOFLEX only!
©Thermoflow, Inc. 2018 –Webinar on Advanced Scripting: Running Excel from Lua , February, 2018 –David Lopez Automating Excel •Excel exposes a COM interface to allow for both
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}
Thornton Vare Seminars, Advanced Excel, Advanced, Mac Guide-Advanced Excel, Defined Names, Excel, Formulas & Functions in Microsoft Excel, Advanced Excel Part 2, Advanced Excel Tips and Tricks, Advanced Formulas and Functions in Microsoft Excel, Formulas and functions in Microsoft Excel, Formulas and Functions with Excel