Developed by
Description
Product description
SpreadsheetWeb Applications connector for Creatio allows you to integrate complex Excel calculations into your Creatio processes.
Use cases:
The connector helps to turn logic-heavy Excel spreadsheets into web applications without any programming involved.
Key features:
- SpreadsheetWeb allows you to use your existing Excel tools without even leaving Creatio.
- Version control is handled from a single location. This means that you can rest easy knowing all users have the same version of your Excel model.
- Run IF/THEN/ELSE logic and any other type of logic that can be created in Excel, return calculation results to Creatio, and then capture them in your processes.
Notes:
You need to have a SpreadsheetWeb account. SpreadsheetWeb offers a 14-day trial that you can sign up for here.
Pricing
Price
SpreadsheetWeb Applications connector for Creatio
Free
Terms & Conditions
By installing this product you agree to terms and conditions outlined in the license agreement.
Support
Support is available for this application.
Support conditions
To keep this app free of charge support is provided only by email.
Support contacts
Email
support@spreadsheetweb.com
Installation
Product compatibility
Product
All products on Creatio platform
Version
7.18 and up
DBMS
PostgreSQL
MS SQL
Platform
.NET Framework
Deployment options
Cloud
Account data sharing
By installing or downloading the App, you confirm that you agree with sharing your account data (name, email, phone, company and country) with the App Developer as their End User.
The App Developer will process your data under their privacy policy.
Guides and manuals
Go to your Creatio project, and select User task from the system actions list. Drag and drop the module into the process. Search for “Spreadsheetweb Calculator” under the “Which user task to perform?” menu and select it.
Once added, select the SpreadsheetWeb Calculator to configure it. Copy your API URL and Application Key from the SpreadsheetWeb Web Service application into the corresponding fields in the module. You can find this information by pressing the blue Edit Application button on the Control Panel if you have a paid SpreadsheetWeb account.
If you have a trial account, you can find the Application Key by pressing Launch if using an Access API application. In Designer applications, this field is called Web Service Key and it can be accessed by pressing the Edit button. Use “https://www2.spreadsheetweb.com/Api” for the API URL in Access API and Designer applications.
Add input and output mappings into the SpreadsheetWeb Calculator module by entering the named ranges corresponding to their counterparts in the SpreadsheetWeb application. The workbook named ranges are case-sensitive and must be an exact match. The fields with red asterisk next to them are required – you must add at least one input and one output field in addition to the Api URL and Application Key. Run your process and get the results in Creatio.
Feedback
Leave your feedback about the solution to its developer and Marketplace team
Type
Compatibility
Installing the integration is free. SpreadsheetWeb offers a 14-day trial that you can sign up for here: https://www2.spreadsheetweb.com/Lite/Home/AddApplication.
To continue using the product, you need to purchase a SpreadsheetWeb license. Licensing fees are based on the number of web applications and workbook size.