# connect a compounds list to an online tool

**URL:** <https://forum.knime.com/t/connect-a-compounds-list-to-an-online-tool/10927>\
**Category:** Cheminformatics\
**Created:** [May 4, 2018, 5:19pm UTC](https://forum.knime.com/t/connect-a-compounds-list-to-an-online-tool/10927 "2018-05-04T17:19:43Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ilaria](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/i/e56c9b/32.png) [@ilaria](https://forum.knime.com/u/ilaria)\
**Post date:** [May 4, 2018, 5:19pm UTC](https://forum.knime.com/t/connect-a-compounds-list-to-an-online-tool/10927/1 "2018-05-04T17:19:43Z")

</div>

Thanks Patrick for your interest.

i have a list of chemical compounds (.xlsx; each row of this .xlsx list correspond to a chemical).

Go to: [http://www.lipidmaps.org/tools/structuredrawing/StrDraw.pl?Mode=SetupFAStrDraw](http://www.lipidmaps.org/tools/structuredrawing/StrDraw.pl?Mode=SetupFAStrDraw).  
I want to insert each row of the .xlsx list, in the empty field to generate a .sdf file.

Please have a look to the attachment

i’m asking if there is a way to do this automatically, becouse my list is made of 400 hundreds rows.

Thanks in advance for your interest

 ![to%20be%20clear](https://forum-cdn.knime.com/uploads/default/original/2X/d/d13d6588d14140c486c44af382dcaa4424a3a783.JPG)

---

<div class="post-metadata">

**Author:** ![Patrick1974](https://forum-cdn.knime.com/user_avatar/forum.knime.com/patrick1974/32/996_2.png) [@Patrick1974](https://forum.knime.com/u/Patrick1974)\
**Post date:** [May 6, 2018, 11:10am UTC](https://forum.knime.com/t/connect-a-compounds-list-to-an-online-tool/10927/2 "2018-05-06T11:10:08Z")

</div>

Hey @ilaria,

even after reading your post 3 times and after having a look at the linked web page - what’s your question? Please share a sample of your input and output data and a little bit more comprehensible explanation of the challenge at hand.

Thanks in advance and kind regards,

Patrick

---

<div class="post-metadata">

**Author:** ![InsilicoConsulting](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/i/50afbb/32.png) [@InsilicoConsulting](https://forum.knime.com/u/InsilicoConsulting)\
**Post date:** [June 3, 2018, 12:08pm UTC](https://forum.knime.com/t/connect-a-compounds-list-to-an-online-tool/10927/3 "2018-06-03T12:08:19Z")

</div>

Probably means to retrieve actual structures from an online portal for all chemical names mentioned in xls and tyen save it to sdf

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [June 23, 2023, 8:29pm UTC](https://forum.knime.com/t/connect-a-compounds-list-to-an-online-tool/10927/4 "2023-06-23T20:29:24Z")

</div>


