Surpac tip – How to use TWAPI in a Surpac macro to read directly from a spreadsheet
While CSV or text files are commonly used to feed input into TCL macros in Surpac, they often come with limitations—such as loss of formulas and formatting when exporting from Excel. To overcome this, a more efficient approach is to use TWAPI to interface directly with Excel from within Surpac macros. This post introduces how to implement that method.