Page 1 of 1
Totalchrom result files...export to MS Excel
Posted: Thu May 17, 2012 6:49 am
by far0n
Hi folks, my first post !!
Anyway, I'm looking for a way for Microsoft Excel to directly read result files from Totalchrom servers and extract the appropriate data. Anybody familiar ?
Cheers
Re: Totalchrom result files... import to MS Excel
Posted: Thu May 17, 2012 7:33 am
by scottythree
Under the Summary Report, click on the tab "File" then select "Edit Format" then go to the "Options" tab. Under this tab there is an option to select to save the report as a .CSV file for MS Excel. It should save this file in the same location as your result files.
Re: Totalchrom result files... import to MS Excel
Posted: Thu May 17, 2012 7:43 am
by far0n
Under the Summary Report, click on the tab "File" then select "Edit Format" then go to the "Options" tab. Under this tab there is an option to select to save the report as a .CSV file for MS Excel. It should save this file in the same location as your result files.
Is there any way of Totalchrom automatically creating CSV files with every trace ?
Re: Totalchrom result files... import to MS Excel
Posted: Thu May 17, 2012 2:56 pm
by DR
or you export the raw files as such using the (... brain fart... the extension with an "x" in it... RAX?) file type. Then these can be read as a column of abs. values to which you pair times based on your sampling rate. Be careful, it is not difficult to create more entries than Excel can handle in a single column.
Re: Totalchrom result files...export to MS Excel
Posted: Fri May 18, 2012 7:41 am
by scottythree
I am not sure if this would help as I haven't tried it before but there is an option in the Report Format editor that allows you to "Create ASCII delimited file".
Re: Totalchrom result files...export to MS Excel
Posted: Fri May 18, 2012 7:46 am
by scottythree
Also and perhaps what DR is referencing you can use the "Convert" function under the "Apps" tab. From there you can select the "TCtoASCII" tab and convert the .raw files to a .rax ASCII file.