Mapping results to a worksheet
Back to index page
When the search is finished, the number of hits are displayed on the Mapping tab.
| 1. | Specify the destination workbook and worksheet for the import. |
| o | Select an existing workbook from the combo box. The active workbook is selected by default. |
| o | Select an existing worksheet from the combo box for the import. The active worksheet is selected by default. |
| o | It is also possible to create a new worksheet for the import and type in the name for the new sheet. It is indicated if the entered sheet name already exists or blank or contains not allowed characters (red exclamation mark with tooltip). |
| o | It is possible to import structures with their properties to a worksheet, which is not empty. The new structures and data can be appended to the existing ones (Append radio button) or the existing structures and data can be overwritten by the imported ones (Overwrite radio button). |
| o | Start: It is possible to specify a starting cell for the import process. The column and row number can be specified or the active cell can be selected as starting cell. |
| o | Create Header: It is possible to import the structures and their data with or without headers by selecting/unselecting the Create Header check-box. The check-box is selected by default. |
| o | Transpose: It is possible to import the structures and their data into columns instead of rows by selecting the Transpose check-box. The check-box is unselected by default. |
| 3. | Click the Map button on the toolbar to map the records to the selected worksheet |
| 4. | The progress and other information are displayed on the Mapping TAB. |
| 5. | Close the Import from Database form. The imported structures with their properties are displayed on the specified worksheet. |
| 6. | The hit coloring specified in search options can be removed by using the Remove Hit Coloring function. |
Back to index page
Do you have a question? Would you like to learn more? Please browse among the related topics on our support forum or search the website. If you want to suggest modifications or improvements to our documentation email our support directly!
