XLW addin for Excel



PLEASE NOTE: XLW is a Wrap creation tool and an account with our sister company ExcelWraps.com is required to deploy the wrap to users.
XLW empowers Excel users to create innovative online forms called Wraps, not Apps, because they are simply Excel workbooks wrapped in our transformational technology. Wraps respond immediately, just like a spreadsheet, but also include ‘beyond’ Excel features like digital signatures, media uploads, GPS mapping, barcode/QR code generation and all the controls you would expect in the best modern apps. We provide a website to deploy wraps and we support any device (PC, tablet or smartphone). Remote users login to the site where information gathered in wraps is immediately available in 'MyWraps' reports with zooming charts. Sensitive information is restricted by assigning user roles. We take care of hosting, site security and data backups. We support our clients directly at their desktops using remote access tools ensuring that anyone can harness our technology immediately and without the support of IT professionals.

Online Forms Solution - Replicate any existing paper forms and launch as enterprise applications on PCs, tablets and smartphones. Ideal for time sheets, task management, workflow, incident reporting, safety assessments, compliance, site inspections, supply line management, audits, inventory processing… etc. We offer a future with no paperwork, no lost forms, no undecipherable scribbles, no unidentifiable signatures, no photocopying, no duplicate errors, no filing and immediate access to the data you have collected.
Visit ExcelWraps.com for more information and follow the online help and tutorials.

Calculation Preview

14 Nov 2017
Last Modified
08 Jan 2020
File Size:
1,270.10 Kb
File Version:
File Author:
John Doyle

Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
Comments: 3
JohnDoyle[Admin] 6 years ago
Sprint 43 - 1st June 2017 at 22:00
Improved AdminTenant Controls for ExcelWraps Permission Groups.
Increase maximum Wrap Media Upload file size to 64MB to support video file uploads at a client's request. Introduction of Fair Usage Policy ExcelWraps user charge assumes that an average user requires 2GB of file storage i.e. a 50 user system is contained within 100GB. Typically Wrap data storage is extremely compact and this limit is unlikely to be exceeded. However some Client's may require larger file storage capabilities and in these circumstances MoreVision will provide additional space for an additional monthly cost.
Restyled MyWraps Reports so that more information can fit on the screen.
Remove carriage return and line feeds characters from MyWraps reports so that appearance can be better controlled and MyWraps charts can be correctly displayed.
MyWraps automatic typing of date and datetime data.
Administrator override when Wrap definitions are locked (i.e. when recalculate instances is triggered)
Administrator password tab now showing in site dashboard user menu.
User import/export controls improve to include user workgroups.
Wrapsites can be configured to suppress printing. A client requested this feature so that paper copies are never allowed and that the site content becomes the only controlled copy.
XLW improved automatic cell naming for HTML Widgets.
XLW will prevents double validation of Excel files.
XLW v17.06.01 released.
Sprint 42 - 20th April 2017 at 22:00
Server Software improved to allow users to create new accounts.
New Wrap Row Show Widget
New Text Export Widget
New image hotspot widget
Server Software improved with automated build and deployment script to verify Unit and QUnit tests pass.
Server Software improved with site setup recipe
Wraps improved to so that user css or javascript refreshes are never required.
Server Software improved with automated test tools for driving the web site.
Site improved with updated Help pages.
As Developers we need to ensure no client data is on development machines.
New XLW border line controls to complement native Excel border controls.
XLW now shows Wrapsite and Wrap group information in XLW validation dialog.
Release XLW v17.04.20
Wrap load time improvement - Wrap permissions database is optimised with a dramatic reduction in wrap load time (17 fold improvement in the worst cases).
Sprint 39, 40 and 41 - 8th March 2017 at 22:00
Low severity security vulnerabilities identified OWASP ZAP have been removed.
Assessment of OWASP top ten vulnerabilities including A1 Injection; A2 Weak authentication and session management; A3 XSS; A4 Insecure Direct Object References; A5 Security Misconfiguration; A6 Sensitive Data Exposure; A7 Missing Function Level Access Control; A8 Cross Site Request Forgery; A9 Using Components with Known Vulnerabilities; A10 Unvalidated Redirects and Forwards.
Addition of anti-spam CAPTCHA controls on site comment feature and contact us feature. These apply to anonymous visitors only (users who are not logged into the site).
Upgrade to latest release of CMS 1.10.2.
Simplification of site controls and dashboard for AdminTenant to provide protection against possible corruption. Management of some CMS features can now only be undertaken by Administrators including Roles, Modules, Site Settings, Themes, WorkFlows, Import/Export, Spam Controls, Custom Forms, Queries, Content Definition, Widgets, Tenants and Reports. Please note that AdminTenant's still retain permission for Wrap Import/Export Wrap and MyWraps reports.
User 'Creation Time' and 'Last Login Time' now available on the 'User' menu on the site dashboard.
Configurable password controls added - Password must contain at least one lower case letter (a-z); Password must contain at least one upper case letter (A-Z); Password must contain at least one number (0-9); Password must contain at least one special character (e.g. !@#$%^&*(){}[].); Set Minimum Password length; Set Password expiration (30 days by default); Set Password format (hashed or encrypted);
Support for users without email address - Many organisations do not supply all their staff with email addresses which is required for our 'Lost Your Password' routine. We have devised an alternative method which requires the support of site Administrators to reset user passwords and pass it onto users with no email address. When the user first logs in with the administrator's reset password the user is forced to reset the password to one of his own. This ensures that only the user ever knows his own passwords and digital signatures cannot be falsely obtained.
Set site lockout after failed attempts to login (15 minute lockout after 4 failed login attempts).
Configurable session timeout after a period of inactivity (default 15 minutes). Re-direction to login page after session timeout.
All client data removed permanently from developer machines (now only on ISO27001 compliant secure servers).
Internal development team audit to demonstrate compliance to the newly instigated ExcelWraps Security Policy.
Addition of WrapLinkAggregate functions in Wraps.
Data sent to only Axis Label or Tooltip in MyWraps Reports.
XLW Rejects Excel tabs starting with a number (potentially problematic for wrap creation).
WrapLinks can now extract all signature details ('&filter-sig-detail=cell'; '&filter-sig-summary=cell'; '&filter-sig-datetime=cell'; '&filter-sig-date=cell'; '&filter-sig-time=cell'; '&filter-sig-firstname=cell'; '&filter-sig-lastname=cell'; '&filter-sig-nickname=cell'; '&filter-sig-company=cell'; '&filter-sig-location=cell').
Wraplinks do not automatically update if the wrap state is 'frozen' which could trigger a recalculation and an error warning that you cannot change a frozen wrap instance.
Option to use non-minimised javascript to assist developers with wrap debugging.
Comment feature now has simpler interface.
MyWraps Aggregate AVERAGE function now ignores null values (the same behaviour as Excel's AVERAGE function).
AutoNumbers must now be explicitly defined in WrapLinks to provide improved error messages.
Addition of keyword WrapName in MyWraps reports which is useful for MyWraps reports with 'appended' wraps.
Release of XLW v.17.03.08
Sprint 38 - 1st November 2016 at 22:00pm
Optimisation of 'Matrix and Morph' solutions. Faster wrap load time.
Optimisation of 'Matrix and Morph' solutions. Faster report generation times by introduction of unique key pre-filtering algorithms.
Improved keyboard selection and MyWraps reporting. Automatic 'type' definition (text, number, date, datetime) for keyboard selection on tablet and phone devices and also default typing in MyWraps reports.
Improved WrapLinks now includes to indicate that a user does not have correct permissions to create a new wrap instance. E.g. will be shown to users with an electrical competence when the wrap is intended for users with a mechanical competence and vice versa. If you do have permission to create a new instance is shown.
New version of XLW 16.11.01 to support new site functionality.
Sprint 37 - 12th October 2016 at 22:00pm
Improved keyboard selection responsive to cell contents (text or numeric keyboards - iOS short numeric keyboard suppressed as decimal point is not available).
Improved leave/stay warnings when navigating from a wrap instance.
Improved Aggregate functions in MyWraps reports (better handling of null values).
Improved WrapLink functionality (nothing displayed when URL="").
Improved Holder cell functionality to support UserCount with role selection logic.
JohnDoyle[Admin] 7 years ago
Fixed Circular reference error if cell name matches XLW function.
New XLW Version Checker added.
Improved About XLW and Subdomain Controls.
JohnDoyle[Admin] 7 years ago
Improved Holder cell to include UserCount function.
Improved status checking of Validation form.
Hyperlink widgets cell naming improved.
Improved sub-domain selector controls.
Cell naming enforced for all input cells (read-only relaxation removed).
Cell naming enforced for WrapLinkList cells.