New in ExcelRT 3.0

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.

Use script commands to generate reports or present custom dialogs to collect user data. Show or hide sheets, columns or rows, read and write Internet data or CSV files. Script commands can modify variables, lists, arrays, strings and cell data, add conditional logic, loops, perform math, call subroutines or manipulate images.

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 meet HTML!

Add Html controls on workbook sheets to display HTML, CSS or Javascript content from an offline or online source. Simply add a folder of HTML files to the Plugin folder used by ExcelRT and link to it to an Html control.

Link an Html control to a URL for live Internet content in your App. Show, hide or change the content displayed by an Html control while your App is running.

Workbook and scripting command data can flow to and from HTML and Javascript to provide seemless integration. Changing workbook data can be presented in dynamic charts, graphs or live animations using HTML technologies embedded within your App.

Click to Play
ExcelRT HTML

Plugins

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.

Click to Play
ExcelRT Plugin

CSV on Steriods

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.

ExcelRT supports multiple CSV memory structures and dozens of scripting commands to load, save, view, search, sort and manage CSV data. Easily move columns, rows or individual cell data between CSV structures, workbook sheets or text files.
Click to Play
ExcelRT CSV

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.

Text Editor

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.