column-pick can not transfer information into excel

[Kai Wen]

Dear Paul,
I open column-pick command after installing perl. It could produce a excel, but it told me can not download information, the new excel is just 1 Kb. My code is Liquid_comp_tbl.txt>aaa.xlsx, is there any thing wrong? Or need a comparable excel version?
Best,
Kai

[Paula]

Hi Kai,

The output from column-pick.command is a comma- or text-delimited text file that can be easily imported into Excel. It is not an actual Excel file. If you take the ">aaa.xlsx" off what you are typing then you will be able to see the output of column-pick.command, including any error messages.

The input to column-pick.command is mostly a list of files, tables, and columns. For example:

Code Select Expand

Name: col_custom.txt
Header: Excel
Format: csv              ! output a comma-delimited table that can be opened in Excel automatically by double-clicking in Finder/Explorer
!Format: txt              ! output a tab-delimited table that can be opened in Numbers (Mac) automatically from the terminal command line
!Padding: '0.0'

File: System_main_tbl.txt
Table: System
Columns: index Pressure Temperature

! custom expressions need to be at the end and are processed left to right; avoid special characters like in FeO* or Mg#
File: Liquid_comp_tbl.txt
Table: "Liquid Composition"
Columns: SiO2 TiO2 Al2O3 Fe2O3 Cr2O3 FeO MnO MgO NiO CaO Na2O K2O P2O5 H2O CO2 FeOtot={FeO}+0.9*{Fe2O3} Mgnum=({MgO}/40.3044)/(({MgO}/40.3044)+({FeO}/71.8464)) Mgpc=100*{Mgnum}

File: Phase_mass_tbl.txt
Table: Phase
Columns: liquid1 clinopyroxene1 clinopyroxene2 fluid1 olivine1 plagioclase1 spinel1

Delimiter: comma        ! default input delimiter is space, but .tbl files are comma-delimited

File: olivine.tbl
Columns: fayalite,forsterite

File: plagioclase.tbl
Columns: albite,anorthite,sanidine

For this example you would type:

Code Select Expand

column_pick.command col_custom.txt > aaa.csv
Or you can use the "-c col_custom.txt" switch to the run-alphamelts.command script, in which case the output will go to "alphaMELTS_tbl.txt". You would need the "Output: both" line in your .melts file to make sure the .tbl files are written.


Paula