Handling Macro Enabled Excel Files in SpreadsheetWeb – Controlling User Interface with VBA
Excel provides a wide range of user interface features that allow users to interact with the application. However, these features can be time-consuming to use, especially when performing repetitive tasks. Macros can be used to automate these tasks and streamline the...
Handling Macro Enabled Excel Files in SpreadsheetWeb – Converting VBA-based UDFs to LAMBDA functions
Incorporating VBA-based UDFs (User-Defined Functions) in Excel empowers users to extend the functionality of their spreadsheets beyond the standard set of available functions. By leveraging VBA (Visual Basic for Applications), a versatile programming language native...
A Step-by-Step Guide to Implementing a Subscription-Based Business Model with Your SpreadsheetWeb Application
Excel is a powerful tool that has been widely used in the business world for decades. While it is commonly associated with financial analysis and data management, entrepreneurs often use Excel to build applications that are viable and specifically tailored to a niche...
Modifying Stylesheets for Designer Applications
Iframe Tutorial
You can use an inline frame (iframe) to embed a web application created with SpreadsheetWEB into your own website. All of the application features will be available in the embedded web application.If you embed a restricted application (Restricted or...
Localization Tutorial
Almost all text content found throughout designer applications and the Control Panel can be customized for localization or branding purposes. A comprehensive localization requires modifying the language in three sections: within the application, in...
Adding Charts into Print Processes
Charts in the user interface can be tied to images in your PDF or Word export documents. To do this, you need to place an image (any image) into your Word document. The contents of the image file don’t have an effect in how the charts will be displayed in...
Adding or Removing Data Columns in the Data Page
Note that this feature is currently only available in designer applications.Data captured with SpreadsheetWEB applications can be easily accessed from the Data page in the Control Panel. This centralized data capture system allows interacting with...
How to Add Dynamic Images in Designer Applications
The versatile content fields of designer applications can host rich text, anything you can do with HTML tags, and even dynamic images through the use of external URLs. Using dynamic images can substantially enhance the look-and-feel of your applications, and give your...