Excel Documents
Ken
I am wondering if it is possible to close and open documents (such as Excel spreadsheets) directly from Igor Pro. Since it is possible to load data from Excel spreadsheets into waves using XLLoadwave, it would be convenient to be able to call that document from Igor as well.
Thanks.
June 29, 2011 at 07:03 pm - Permalink
If you are working in windows, something as simple as:
ExcecuteScriptText "excel.exe"
will open excel in the foreground. Search for "command line" in the excel help system for details on starting excel from the command line. Also look up ExecuteScriptText in the Igor help docs for more information.
At the brief quote above states, ExcecuteScriptText also works with Apple Scripts.
June 30, 2011 at 06:25 am - Permalink
DisplayHelpTopic "ActiveX Automation" // for Windows
DisplayHelpTopic "Igor Command Line" // for Windows
DisplayHelpTopic "Apple Events" // for Macintosh
DisplayHelpTopic "AppleScript" // for Macintosh
John Weeks
WaveMetrics, Inc.
support@wavemetrics.com
June 30, 2011 at 12:46 pm - Permalink
ExecuteScriptText "\"" + "Excel.exe" + "\" " + "\"" + Path + "\""
I am still looking for a way for Igor to recognize what programs/files are open in the taskbar, as well as a way to close an Excel file.
July 6, 2011 at 08:59 am - Permalink
You can use the same technique to make Excel open the file.
July 6, 2011 at 11:01 am - Permalink