Workbook Object: Overview

Display all  Hide all

Workbook Object: Overview

The DataPlugin consists of objects and subobjects that you create, delete, and modify with a script. You receive the Workbook object if you select the file reader Spreadsheet Reader when you create a new DataPlugin. The file reader Spreadsheet reader can access Excel files which were created with OpenOffice, Excel 2007, Excel 2003, or an earlier version and which are not password protected. The ReadStore procedure receives the workbook object with a reference to the file to be loaded via the Workbook parameter. When loading data from an XLSM file, DIAdem does not execute the macros contained in this file.

To search for data in or to load data from a spreadsheet, Microsoft.NET Framework 4.0 must be installed on your computer. DIAdem installs Microsoft.NET Framework 4.0 by default.

The Workbook object structure is shown in the following:

For an overview of the global methods and properties of the DataPlugin, click here.