New in ExcelRT 3

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 seamless 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

Web Page Control

ExcelRT script commands can present a browser window and control the web page. Use script commands to click, write, copy or paste text in a web page.

View the HTML source, then specify controls by id, name, class or tag in script commands.

Click to Play
ExcelRT Web Page Control

Python

Python is a popular programming language available on almost every computer OS.

Use the Python script command to send ExcelRT workbook data to a python program and return the results. Combine spreadsheet authoring skills, the UI capabilities of ExcelRT plus the power of python to create rich applications.

Click to Play
ExcelRT Python

JSON

JSON is a popular text format to communicate structured data with Internet servers.

Load or save a JSON object as a text string and use script commands to get or set data in the JSON object.

Click to Play
ExcelRT JSON

Open Database Connectivity (ODBC)

Connect an ExcelRT workbook to virtually any database (MS Access, MS Excel, SQL Server, Oracle, PostgreSQL, FileMaker, etc) with ODBC integration. Most database vendors offer a free ODBC driver and many come preinstalled on Windows.

Read, modify, write or add data to a Mac or Windows database with simple script commands.

Click to Play
ExcelRT ODBC

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 Steroids

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.


Learn more about HTML, Web Page Control, Python, Plugins or CSV features by downloading the ExcelRT Examples.