Importing Datasets from Excel |
||
The Basic Parts Three Steps Limitations The Algorithm Other Conversions
|
Window ComponentsThere are three panes or window sections in the Import window. To access their menus, right-click on either of the two list boxes in the left-hand part of the window. Sheet ListThe upper-left list box contains the names of the worksheets (spreadsheets) contained in the currently open Excel workbook. Converted Dataset ListThe lower-left list box contains the names of the worksheets you have converted to DataWallet's "dataset" format. Sheet DataThe right-hand grid displays the contents of the worksheet currently selected in the Sheet List. Three Steps to ImportingHere are the steps to import an Excel worksheet into a DataWallet wallet file.
You can delete a converted dataset before adding it to the wallet by right-clicking on the lower-left list box of the Import window and selecting "Delete" from the menu. Limitations of Excel ImportationExcel worksheets can be very complex. DataWallet scans each newly opened worksheet looking for a simple rectangular structure: a single "header" row and up to 1000 "data" rows. If the sheet does not fit into this pattern, the results of importation may not be what you want. The Importation AlgorithmHere's what DataWallet does when importing a worksheet.
If more than 10 entirely blank consecutive rows are encountered the conversion ends. If more than 1000 lines are converted you will be given a warning and asked if you want to continue the conversion, since it's unlikely that such a large amount of data needs to be stored in DataWallet. Other ConversionsExcel supports other file formats; in particular, there is a simple format known as "comma-separated variables" (CSV) in which each line of text is composed of data fields separated by commas. Since almost any data format can be rendered in this simple fashion, other file formats can be imported into DataWallet by a two step procedure: first, convert your data into a CSV file, then import it using DataWallet's Excel importation feature. |