ExcelRT supports powerful scripting commands to add dynamic content and user interactions to a workbook. A button click or an action like a workbook open, save or switching between sheets can run a list of script commands.
Script commands can interact with the user, file system or the Internet. Most commands are platform neutral and work the same regardless of the computer or device OS.
When your App needs a feature that cannot easily be accomplished with a spreadsheet formula, cell validation or conditional formatting, a few script commands can usually get the job done.
ExcelRT supports Plugin files. A Plugin file is built from a folder of nested files (often HTML content) that adds new features to a workbook. A Plugin is a single compressed, encrypted file that can be easily distributed and shared between workbooks.
ExcelRT developers can password protect a plugin to conceal proprietary source files while allowing other developers to use the plugin features.
Comma Separated Variable (CSV) files are a popular way to exchange data between spreadsheets, databases or other applications. ExcelRT can use and create CSV files in almost any format to share data or serve as an offline or online database for your workbook based application.
Comma-separated, Tab-separated and other popular CSV formats can be determined, read or written with simple script commands. CSV features can efficiently use large data structures within memory or from an Internet source.
ExcelRT includes a CSV Viewer to easily view CSV data in memory at design time or even present it to the user from a script command.
ExcelRT Builder includes a plain text editor for editing HTML, CSV or any text files while authoring your workbook. The text editor can be customized and presented with a script command for use within your App.