JChem for Excel
Before Using
Supported Versions
JChem for Excel Ribbon
Standard Menu
Advanced Menu
Switch From Standard to Advanced Menu
Working with Structures
Add a structure to a cell
Edit a structure in a cell
Insert single structures
Save single structure to file
Structure editing in task pane
Copy and Paste
Inside Excel
Copying Structures With or Without Data
Exclude Hidden Rows
Between Excel Instances
To External Applications
Copy and Paste with IDs
Copy and Paste Single Structures with Ctrl+C-V
To External Structure Editors
From External Applications
From Instant JChem (IJC)
From External Structure Editors
Show and Hide Structures
Show structures and Show structure IDs
Delete structures from selected range
Resizing Structures
Printing Structures
Structures in merged cells
Convert to SMILES (from Structure)
Convert from SMILES (to Structure)
Convert to Image (from Structure)
Convert from Image (to Structure)
Convert to SMARTS (from Structure)
Convert from IUPAC Name or CAS Number (to Structure)
Convert to IUPAC Name (from Structure)
Structure Transformation Actions
Convert Accord, ChemDraw and ISIS for Excel files to JChem for Excel files
JChem for Excel File Converter Tool
JChem for Excel File Converter Action
JChem for Excel File Converter Right-Click Menu Item
Calculations with Third-Party Services
Open Structure Files
Open Multiple Structure Files with and without Data
Open All Files in a Folder
Merge Files to a Single Worksheet
Import From Database
Import from Database
Managing Connections
Connecting to an Oracle Database
Connecting to a MySQL Database
Connecting to an MSSQL database
Connecting to PostgreSQL database
Connecting with JChem Webservices
Working with Connections
Favourite Entities
Exploring Database Tables, Views and Columns
Mapping Results to a Worksheet
Search Options
Specify Query Criteria
Selecting Columns for Import
Selecting Rows for Import
Running the Search
Import From Database By IDs
Associate IDs
Import From IJC Database
Before Import
Selecting Source For Import
Selecting Columns For Import
Import from File
Import from File
Selecting Fields to Import
Running the Import Process
Import From File By IDs
Import with Document to Structure
Export to File
Save to Share
R-group Decomposition
Selecting Query and Target Structures
Specification of Different Options
Running the Decomposition Process
SAR Table Generation
Running SAR Table Generation
Structure Filter
Filter (Search) Options
Working with Filter Results
Clone Results to a New Sheet
Options
General
Database Connection
Formatting
Licensing
File Import
IJC Import
File Export
Printing
Structure Sheet
Image Conversion
Structure Display
Structure Editor
Actions
Event Handling
Functions
Custom Excel Chemical Functions
Using JChem Excel Functions
Reference
Normal
Charge
Electronegativity
Polarizability
Chemical Terms
Dissimilarity
Drug Discovery Filtering
Elemental Analysis
Geometry
Hydrogen Bond Donor-Acceptor
Isomers
Conformer
Stereoisomer
Resonance
Naming
Protonation and Partitioning
Major microspecies
Isoelectric Point
Partitioning
pKa
Solubility
Tautomers
Topology Analysis
Ring
Path based
Distance based
Refractivity
Structure
R-group Decomposition Functions
Reactor
Markush Enumeration
Reactions
2D/3D Clean
MCS Structure
Structural Framework
Structure Checker
Standardizer
JCStructure
JCIDSYSStructure
Image
Display Options - Rendering
Display Options - Misc
Plug-Ins
Troubleshooting
Manually enabling JChemExcel.Functions
Disable and re-enable JChem for Excel
Upgrade to Latest Version
No help available for JChem for Excel functions
User Interface Customization
Actions Reference
AboutAction
AddEditStructureSingleCellAction
AddEditStructureTaskPaneAction
ClearFilterAction
ConvertAccordToJC4XLAction
ConvertChemDrawToJC4XLAction
ConvertISISToJC4XLAction
DecreaseStructureSizeAction
EmbedInJCSMILESAction
ExportFileAction
HelpAction
ImportFileAction
ImportFileByKeyAction
ImportFromDatabaseAction
ImportFromDatabaseByKeyAction
IncreaseStructureSizeAction
LicenseAction
MoleculeWorksheetFilterAction
OpenStructureSingleCellAction
OptionsAction
RedrawStructuresAction
RemoveHitColoringAction
ResizeStructuresToDefaultInSelectionAction
RGroupDecompositionAction
SaveAsStructureSingleCellAction
ShowHideStructuresAction
ShowHideStructuresActionforIDs
UnembedFromJCSMILESAction
Conversions
ConvertFromInChiToStructureAction
ConvertFromIUPACNameToStructureAction
ConvertFromMOLToStructureAction
ConvertFromShapeAction
ConvertFromSMILESToStructureAction
ConvertFromTextToStructureAction
ConvertToChemDrawOLEAction
ConvertToCXSMARTSAction
ConvertToCXSMILESAction
ConvertToInChiAction
ConvertToIUPACNameAction
ConvertToOLEAction
ConvertToSMARTSAction
ConvertToSMILESAction
ConvertToStructureCommentAction
ConvertToStructureImageAction
ConvertToJCSYSStructureAction
Copy - Paste
CopyToChemDrawOLEAction
CopyToChemDrawOLEAndValuesAction
CopyToClipboardAsMarvinOLESingleCellAction
CopyToClipboardSingleCellAction
CopyToOLEAction
CopyToOLEAndValuesAction
CopyToStructureImageAction
CopyToStructureImageAndValuesAction
PasteFromClipboardSingleCellAction
Structure Transformation
AromatizeStructureAction
DearomatizeStructureAction
DehydrogenizeStructureAction
HydrogenizeToStructureAction
ThreeDCleanStructureAction
TwoDCleanStructureAction

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!