Extracting Metadata from an XLS(X) File

If you want to extract metadata from an XLS(X) file, right-click Metadata (in Outline) and select New MetadataExtract from XLS(X) file .

[Tip]Tip

Equally, you can drag an XLS file from the Navigator area and drop it on Metadata in the Outline. This will also bring the extracting wizard described below.

Extract Metadata from Excel Spreadsheet Wizard

Figure 32.18. Extract Metadata from Excel Spreadsheet Wizard


In this wizard:

Optional tasks you can do in this dialog:

As a final step, click either Finish or Next. If you use Next, you can change the metadata name.

Extraction of Metadata from XLS(X) File into External Metadata File

You can extract metadata from an XLS(X) file and save it to an external file. In main menu, choose FileNewOther. A new window opens. In the window, choose CloverDXMetadataMetadata (Extract Metadata from XLS(X) file).

The last step of the wizard lets you specify the metadata file name and its location.