Page 1 of 1
How to export chromatograms to Excel?
Posted: Wed Sep 26, 2012 1:53 pm
by sofiarutesilva
I need to export my chormatograms to an Excel file. How can i do that?
My Chemstation is Rev.A.10.02.
Best regards
Sofia
Re: How to export chromatograms to Excel?
Posted: Wed Sep 26, 2012 4:28 pm
by Steve Reimer
If the A version of Chemstation (sorry don't have that version here) has the "clip" command, copy the chromatogram window to a file and then insert the file into the spreadsheet as an object. "Clip" has the low resolution of your screen display so it may not be useful if you want to enlarge an area to show integration but it is quick and easy.
Re: How to export chromatograms to Excel?
Posted: Wed Sep 26, 2012 7:57 pm
by dblux_
I need to export my chormatograms to an Excel file. How can i do that?
My Chemstation is Rev.A.10.02.
Best regards
Sofia
Depends what you really need.
a) If you want to embed chromatogram as a picture simply load your signal and then from Graphics menu choose Copy to Clipboard and paste clipboard to Excel file.
b) If you want to export chromatogram in digitized form, load your signal and from File menu choose Export File, then e.g. CSV file (choose radio button Signal).
MfG
Re: How to export chromatograms to Excel?
Posted: Mon Oct 08, 2012 1:42 pm
by eselmeister
Hi,
if it is a MSD chromatogram, you could also try to use OpenChrom:
http://www.openchrom.net
I've published the new preview release last weekend:
http://www.openchrom.net/main/content/d ... review.php
There's a plug-in, available in the marketplace, to export
chromatograms to *.xlsx format:
http://www.openchrom.net/dokuwiki/doku. ... arketplace
http://www.openchrom.net/dokuwiki/doku. ... le_formats
A batch converter is also available, if you have to process dozens of files:
http://www.openchrom.net/dokuwiki/doku. ... conversion
Cheers,
eselmeister
Re: How to export chromatograms to Excel?
Posted: Tue Oct 16, 2012 5:10 am
by mckrause
@dblux_ has the correct answer. It is the only way to move graphics in A.10.02.
Re: How to export chromatograms to Excel?
Posted: Tue Oct 16, 2012 7:29 am
by gstaepels
I just replace my Chemstation A10.03 with the new OpenLAB chemstation software. However, exporting data from the Chemstation to excel is simple: in "Specify Report" mark the XLS option, and if you want the graphics mark WMF as well. The data are stored in the sample folder.
Good luck
Gilbert