OfficeSheet for MsExcel (OS4XL) is the first and only fully functional Smart Client for Ms Excel. OS4XL provides a unique portal into MsExcel data and functionality for information-intensive work environments, such as corporate and government knowledge workers.
OS4XL augments the operation and use of MsExcel and integrates it into an overall information workflow in a number of key areas:Data Acquisition: OS4XL provides fast and precise data acquisition from MsExcel worksheets, based on names, selected areas or explicit ranges.
Â Acquire cell data as well as additional information such as comments, links and formats such as font (v1. 1). Â Easily acquire and manage metadata, such as lists of worksheet names (v1.
1), and standard and custom properties (v1. 2). Â Conversion of data from MsExcel lists to a database-like table of columns and rows should be a no-brainer, but it is often non-trivial due to common data acquisition problems, such as multiple row headers and inconsistent column header naming.
OS4XL provides solutions for these types of problems. Data Management: OS4XL provides a range of functions for operating on MsExcel worksheets in multiple units, with functions such as copy and append that are data structure aware.
Â OS4XL enables you to open multiple files in one operation, or process an almost unlimited number of files in a series of batches.
Data Conditioning and Manipulation: OS4XL assists you to overcome the numerous pitfalls that await the analyst who wants to integrate data from multiple spreadsheets, most of which are hand-edited.
Â Often much of the data in a spreadsheet has been beautified with various formats and augmentations to make it more visibly appealing but reduce its ability to be used in any downstream automation, such as invisible columns and rows, multiple blanks columns and rows, and text comments.
Before performing data integration functions (see below), many spreadsheets need to be conditioned and data edited. Data Integration and Assimilation: OS4XL provides multiple functions to integrate data into a single structure.
How often have you been in the situation where you have one spreadsheet with part of your data, another with a different and slightly overlapping set of your data, and a third that contains the rest.
Â OS4XL enables you to avoid re-typing, or dangerous manual copy and pasting from one sheet to another. OS4XL enables you to analyse data frequency and perform functions based on indexed data: Lookups, Updates and Merges (v1.
1). Data Analysis & Reduction: whilst Pivot tables have become part of many information workers daily lives, the data that is produced is not readily usable for other tasks other than presentation.
Once youve created a nice pivot table and produced a subsetting of data, it is often quite difficult to put this ing the pivot summary data to use in another application.
Â OS4XL provides an intermediate form of Pivot Grid with a wrapper of data management functions that enables very rapid distillation of masses of information, and then that summary data can be immediately used in the next step of your analysis.
Data Distribution & Collaboration: once you have transformed, conditioned, integrated, and validated your information, you want to put it to some use.
Â Or maybe you never got that far: you found that data was missing or invalid and needed to send back to one of your correspondents.
Data Reinsertion: the last step of your process is more than likely to redistribute or re-use the information within the original application, in this case MsExcel.
Â OS4XL enables this to be pushed back to the worksheet in straightforward grid format (v1. 0) and an advanced grouped format making use of MsExcel grouping functions (v1.