How to import CDF file to Excel and display graphics as WMF

[magro]

Hello,

I want to import a *.CDF data file (for example a hplc- or gc-chromatogram generated by EZChrom Elite or Shimadzu's Class-VP) to Excel (Version Excel 2010). Excel should display the CDF data as WMF graphics (including integration limits and peak Labels).

How does it work? Does anyone have experience with this topic?
Does anyone know a VB- or VBA-code for this problem?

Thank you for your suggestions and ideas.

magro

[varossf]

CDF is ASCII based so it will not be like WMF. However, if you still have the EZChrom software, under the advanced section of the method, second tab, you can specify to export the chromatogram as WMF. As you can also specify what is displayed on the chromatogram you can have then RT, area, start stop and baseline being in the WMF.

[aceto_81]

I'm not sure if the integration is stored within the cdf file.

[shfo]

Err, CDF is not ASCII based as far as I know. I'm not terribly familiar with EZChrom or Shimadzu so someone should correct me if I'm wrong here, but the CDFs I've seen are generic binary files that contains raw chromatographic data. There may be something in the CDF format description that allows for integration data to be saved, but it's not universally used by different vendors and I really wouldn't count on that information being in there. I'm fairly sure that CDFs don't contain any records of peak labels either. So while it's certainly possible to write a CDF importer in VBA (and someone may well have done so), I'm not sure how useful the results would be to you.

[magro]

Hello shfo,

Thank you for your feedback. You are right. The netCDF/*.AIA/ANDI format is a binary format. It must be "translated". Therefore I'am looking for a CDF-importer in VBA.
The advantage of the CDF-format for me is that it contains peak labels and integration limits.
Unfortunately I do not have much experience in VBA. Therefore I am looking for people who have made ​​that before.

Err, CDF is not ASCII based as far as I know. I'm not terribly familiar with EZChrom or Shimadzu so someone should correct me if I'm wrong here, but the CDFs I've seen are generic binary files that contains raw chromatographic data. There may be something in the CDF format description that allows for integration data to be saved, but it's not universally used by different vendors and I really wouldn't count on that information being in there. I'm fairly sure that CDFs don't contain any records of peak labels either. So while it's certainly possible to write a CDF importer in VBA (and someone may well have done so), I'm not sure how useful the results would be to you.

[magro]

Hello aceto_81,

in my case the integration and peak label are stored in the cdf file.

I'm not sure if the integration is stored within the cdf file.

[magro]

Hello,

I would say that the CDF format is a binary code. This code can be translated to ASCII.
From the ASCII data you can create a WMF image by an interpreter (or save the clipboard as WMF), but how?

CDF is ASCII based so it will not be like WMF. However, if you still have the EZChrom software, under the advanced section of the method, second tab, you can specify to export the chromatogram as WMF. As you can also specify what is displayed on the chromatogram you can have then RT, area, start stop and baseline being in the WMF.

[antonk]

Our UniChrom is free for data processing
http://www.unichrom.com/dle.php
List of formats supported
http://www.unichrom.com/chrom/uc-ffe.shtml

getting vector chromatogram image - use menu Edit/Copy
WMF is placed in clipboard.
Image resolution and size is tuned via Instrument/Parameters dialog.

[Klinge42]

Hi magro,

did you solve the problem yet?
OpenChrom may be useful, the images are in png though.
But the chromatograms can also be exported as csv- or Excel-files.
If you need further assistance contact us via the OpenChrom website:
http://www.openchrom.net/main/content/contact.php

Regards

[tom jupille]

Have you tried Chrom Merge? He has a demo version available:
http://chrommerge.com/demo.html