User 715e498bfb
10-04-2009 06:54:20
How to call API or write Java code to set the chemical structure’s property into the cells of Excel worksheet, so that we can use “JChem-for-Excel” plug-in to open the Excel file and sort the structures by order or filter them in worksheet (at present the chemical structure that we export excel file is in image format, which cannot be sorted by order).
If we do not support this, when will be the timeline?
ChemAxon 0e37943a96
14-04-2009 13:21:34
Dear Zhou,
at the moment we do not have an API for JChem for Excel, but we plan to create one. It would be possible to call this from external programs.
We could create that method for you, with an example, by the end of April.
It is not possible to sort on structure column, but it is possible to sort on related properties and structures move with the cells.
It is possible to filter on the structure column.
Tamas.
ChemAxon 0e37943a96
05-05-2009 14:00:02
Dear Zhou, we have postponed the next release till the end of May. A limited API functionality for adding structures to a sheet is going to be included into that release. Tamas.
User 715e498bfb
07-05-2009 08:49:50
| tpelcz wrote: |
Dear Zhou, we have postponed the next release till the end of May. A limited API functionality for adding structures to a sheet is going to be included into that release. Tamas. |
thank you.
ChemAxon 0e37943a96
22-06-2009 07:08:16
Dear Zhou,
unfortunately the API did not get into the current release. We plan a redesign in that area, and we will introduce the full API with examples in 1.1.2, by the end of August.
Best regards,
Tamas.
ChemAxon bd13b5bd77
10-03-2010 23:08:18
Dear Zhou,
please check the new version, API is introduced (at first in the 1.1.3 version).
From java the COM interface can be accessed too, via jacozzoom or jacob COM bridge or using Apach POI (in this case our structure sheet needs to be used - a bit more complicated like using our COM interface directly).
Documentation is available for the API on our download site.
Viktor