User guide

Note: To import CFW files into Excel, save them with the “allow CAL/OLE Automation access” security setting
checked. See “Setting Security Options” in the ChemBioFinder user guide for details.
Note: Structures saved as ChemFinder XML files can be imported into Excel using the add-in.
When you import a table, structure data are transformed into structure drawings in the first column, and all other fields
are imported in separate columns.
To import a table:
1. In Excel, select the cell where you want the import to start. The upper-left corner of the import is at this cell. Data is
filled down and to the right.
2. Go to ChemOffice13>Import/Export>Import Table. The Import Table dialog box appears.
3. Type or select the file name to import and click Open. All records are added to your worksheet.
Note: A progress dialog displays the import progress. You can cancel the import process at any time by clicking
Cancel. On clicking Cancel, you will be prompted either keep the records which were imported, or cancel the
import process or continue with importing.
Note: You can import a table only into a new ChemOffice worksheet.
Importing hit lists
You can search records in ChemBioFinder and import the hit list structures with data into Excel using the Import
ChemFinder List command.
To import a hit list:
1. Go to ChemOffice13>Import/Export>Import ChemFinder List.
2. If you are prompted to start ChemBioFinder, click Yes.
3. In the message box, click Yes to import the hit list. The records are imported into Excel.
Exporting tables
e status bar displays the /Excel lets you export tables to MDL SDFiles format. The first column of the area you select
to export must have the word “Structure” in its top cell. Structures outside the first column are discarded.
To export data:
1. Select the cells to export, including the cell that contains the word “Structure”.
Note: You can export selected rows and columns from a structure table. Ensure that the cell selection is continuous.
See examples below.
ChemBioDraw 13.0
Chapter 10: ChemDraw/Excel 158 of 401