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.
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.
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.
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.
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.
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.
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.
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.
Learn more about HTML, Web Page Control, Python, Plugins or CSV features by downloading the ExcelRT Examples.