Advertisement

XLS report in GC Chemstation

Discussions about GC and other "gas phase" separation techniques.

4 posts Page 1 of 1
Hello,

I just started working in a new place and one of the analysis in here is of fatty acids in GC. The data amount is pretty huge and at the moment the report is printed out and wrote to excel afterwards by typing it in. After first time doing it I realized I really don´t want to do it again and discovered that the Chemstation has an option to print the report to .xls file. So i went to report->specific report->ticked XLS and to file-> pressed OK. Nothing hapend, I tried to search with windows search and browsed all the data folders and found nothing. I also tried print report after I ticked the to file and .xls but this also didn´t have any results. Has anyone had the same problem or know where I can get help.

Chemstation Rev.B.03.01[317] (don´t know if it is relevant)
You are looking in the subdirectory (individual data directory .D), correct? I've done this with ChemStation, but older versions, haven't used B.

We have a macro custom written by Agilent (we paid for it) to calculate fatty acid equivalent weight, iodine value, and "acid value" for us, using a Custom Report. That saves us from pasting into an Excel template to have Excel do the calculations.

Just last week I was looking for sodium stearate distributions in solid deodorants (don't confuse those with antiperspirants).
Assuming everything is default on your computer and you only have 1 GC, it is here:

C:\Chem32\1\DATA\*The Prefix File Name*.D

Open the .D folder and the XLS file is there. Everytime you print for that sample or print preview, it will overwrite the old XLS file and create a new one.
Assuming everything is default on your computer and you only have 1 GC, it is here:

C:\Chem32\1\DATA\*The Prefix File Name*.D

Open the .D folder and the XLS file is there. Everytime you print for that sample or print preview, it will overwrite the old XLS file and create a new one.
Thanks, finally found it.
4 posts Page 1 of 1

Who is online

In total there are 32 users online :: 1 registered, 0 hidden and 31 guests (based on users active over the past 5 minutes)
Most users ever online was 5108 on Wed Nov 05, 2025 8:51 pm

Users browsing this forum: Amazon [Bot] and 31 guests

Latest Blog Posts from Separation Science

Separation Science offers free learning from the experts covering methods, applications, webinars, eSeminars, videos, tutorials for users of liquid chromatography, gas chromatography, mass spectrometry, sample preparation and related analytical techniques.

Subscribe to our eNewsletter with daily, weekly or monthly updates: Food & Beverage, Environmental, (Bio)Pharmaceutical, Bioclinical, Liquid Chromatography, Gas Chromatography and Mass Spectrometry.

Liquid Chromatography

Gas Chromatography

Mass Spectrometry