XLSior logo
XLSior Online Help

Getting started
Overview
Requirements
Installation
Removal
Conventions
Limitations
Troubleshooting
Preferences
Setting preferences
User
Updating
Sort AutoDocs
Add information to worksheets
Printing
Add sheets to workbooks
Workbook
Updating
Sort AutoDocs
Add information to worksheets
Printing
Testing
Defining tests
Test sheet
Test set
Test data
Test conditions
Running Tests
Tips
Automated Documentation
Sheets
Names
Cell comments
External links
Advanced techniques
Summary sheet
Formatting
Input range
Heading range
Check range
Warning range
Manual range
Comments box
Timestamp
Documentation
Notes Sheet
Comments Box
Print Footer
Timestamps
Operating on sheets
Protecting sheets
Hiding sheets
Ordering sheets
Saving versions and releases
Versions
Releases
Automated importing
Defining imports
Updating imports
Programming with XLSior
Preferences
Testing
Automated documentation
Documentation
Formatting
Operating on sheets
Saving versions and releases
Automated importing
Help

Overview of XLSior

XLSior makes it easy to build better Excel spreadsheets by supporting the use of automatic testing, systematic development and organisation-wide standards and processes.

It includes tools for

  • Automatic testing
  • Automatic documentation and formatting
  • Controlling development versions and releases
  • Handling protected and hidden worksheets
  • Automatic importing of values from other workbooks

The advantages of using XLSior include:

  • Improved productivity for spreadsheet developers
  • Spreadsheets that are easier to maintain and update
  • Spreadsheets that are less likely to contain errors

XLSior is a simple Excel add-in. It introduces no macros into your workbooks, and doesn't use the Scripting library (often disliked by security conscious IT departments). It helps both novice and expert Excel developers.

All XLSior's features can be accessed programatically throught the fully documented API, allowing you to build them into your own processes.

With XLSior you can be confident that your Excel spreadsheets have been thoroughly tested and have basic documentation. XLSior encourages the use of simple layout conventions, and means that never again will you have to spend hours undoing changes you have just made. All users can be sure that they are using the latest trustworthy version of your spreadsheets.