Desktop User Guides > Professional > Table scripting > Exporting tables > Microsoft Excel tables export > Microsoft Excel tables export: Interactive mode
 
Microsoft Excel tables export: Interactive mode
Sample script file: ExcelExport.mrs
This example script is based on the Museum sample data set. See Running the sample table scripts for information on running the example scripts.
When to use interactive mode
Use interactive mode when you want to get feedback during the export. For example, you will see a message if the output file already exists.
Main differences between exporting tables with and without interactive mode
Situation
Interactive mode enabled
Interactive mode disabled
File of same name already exists.
The user is presented with a Yes/No message box that requests permission to overwrite the file.
If the OverwriteOutput export property is set to True, the output file is overwritten, otherwise the export fails.
Overwrite of output file fails.
The user is presented with an OK box that explains that the output file cannot be overwritten and then the export fails.
The export fails.
Microsoft Office is not available
The user is presented with an OK box and the export fails.
The export fails.
One or more invalid export properties have been specified.
The user is alerted with an OK message box containing a list of the invalid properties. The valid properties are accepted.
Invalid properties are ignored and any valid properties are accepted.
Example
You select interactive mode by setting the Interactive export property to True:
TableDoc.Exports.mrExcelExport.Properties["Interactive"] = True
Requirements
▪UNICOM Intelligence Reporter
▪Microsoft Office 2007 or later
See also
Microsoft Excel tables export