Chromatography Forum

Chromatography Forum is a public discussion group where you can post questions, news, or messages of interest to chromatographers everywhere, but you must be registered to participate (registration is FREE). If you are a registered user, please log in.
http://www.chromforum.org/

Chemstation - Exporting Librarys to Excel

http://www.chromforum.org/viewtopic.php?t=20983

Page 1 of 1

Chemstation - Exporting Librarys to Excel

Posted: Thu Oct 11, 2012 5:01 pm
by dpeirish
Is there a way to export a chemstation library into excel format?

Re: Chemstation - Exporting Librarys to Excel

Posted: Fri Jan 11, 2013 6:22 am
by susan12
It is possible to export to .xls or .dif. Go to batch, select the batch options buttton -> Report Options -> Excel box. The report will be created in the form of an Excel workbook.

Re: Chemstation - Exporting Librarys to Excel

Posted: Fri Jan 11, 2013 11:46 am
by dblux_
It is possible to export to .xls or .dif. Go to batch, select the batch options buttton -> Report Options -> Excel box. The report will be created in the form of an Excel workbook.
But the question was about exporting L_i_b_r_a_r_y (no matter what was meant by this word, definitely not Report).

Re: Chemstation - Exporting Librarys to Excel

Posted: Fri Jan 11, 2013 2:49 pm
by shfo
This tool looks like it will convert an Agilent library to JCAMP-DX (Chemstation might be able to export to that too? I forget) which is a text format. You could then scrap the text data you need out of that JCAMP file into a CSV with Python/Perl or there might be a decent way to do it by opening the JCAMP file with Excel and reorganizing it with a VBA macro.
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/