Microsoft Excel Import/Export


Description Usage Options See Also

Description

The Microsoft® Office Excel® Import/Export Plugin allows Draco to load and save to Microsoft Excel formats, including xls and xlsx file formats. Having Excel installed is not a prerequesite for use of this feature. This import/export functionality is implemented using the Draco Plugin System.

Usage

The plugin is accessible via the Import or Export submenus in the File Menu. Two formats are supported, Microsoft Excel 97-2003 xls format, otherwise known as Binary Interchange File Format, and Microsoft Excel 2007 xlsx, which represents Office Open XML format.

Export

To generate an Excel file from the current worksheet, select the appropriate format in the Export submenu in the File Menu. Once the plugin has initialized, a file dialog is presented to select the filename to which data will be written. After selecting a filename, a brief option window will appear to specify output options. After clicking the Close button, the data will be written to the Excel spreadsheet.

Import

The Import feature operates in much the same way as the Export feature. To import Excel spreadsheet data, first select the appropriate format from the Import submenu in the File Menu. An option window will appear. Draco can only import a single sheet from within an Excel workbook; the user must select a sheet to import in the option window. Once the option window is closed, the data is imported into Draco.

Options

Both import and export features have options associated with reading and writing Excel files. The options are described below:

Export

Name Description
Variable Names in First Row Variable names are output to the first row of the Excel sheet

Import

Name Description
Worksheet to Import The sheet within the workbook to import
Variable Names in First Row The first row contains text that represents variables names
Last Row Index to Import The last row to load from the Excel worksheet, or -1 for all rows containing data
Last Column Index to Import The last column to load from the Excel worksheet, or -1 for all columns containing data

See Also

Plugin System Overview
Importing External Data


Microsoft and Excel are registered trademarks of Microsoft Corporation

Copyright © 2009 Approximatrix, LLC
Text licensed under the Creative Commons Attribution-Share Alike 3.0 License
DracoTM and the Approximatrix logo are trademarks of Approximatrix, LLC
Other trademarks are property of their respective owners