ImportFileByKeyActionBack to index page
Description: Imports structures and other data from a file to preexisting data on the Excel sheet.
For example: IDs (1-10) of the compounds are in column A on the Excel sheet for assay report, and SD file or MRV file has IDs (1-10) and the corresponding structures.
Import File By Key form - File tab
You can select a file from you want to import structures. You have to select column A as key column and the field name of IDs in SD/MRV file. You can also decide if you want to create column headers or not. The structures in SD/MRV file can be imported according to IDs.
Import File By Key form - Columns tab
If the selected file contains additional fields, you can specify which properties to import on the Columns tab, data without structures can be imported as well. There is no mandatory field, but at least one column has to be selected.
Import File By Key form - Progress tab
Clicking on the Import button starts the import process. The progress is displayed on the Progress tab. When the process is finished, the imported structures and data are displayed on the selected worksheet. Clicking Close button closes the Import File By Key wizard.
The ImportFileByKeyAction is not available in the JChem for Excel ribbon/context menu/menu/toolbar by default but it is possible to make it available by customization of the ribbon/context menu/menu/toolbar.