Create an excel spreadsheet with data from a tab-delimited text file and apply custom text formatting to specified columns.
Using the 'text color' and 'underline' properties, highlight a specific sub string.
-
Requirements
Excel::Writer::XLSX
-
Usage
perl table-to-spreadsheet.pl <input table delimited file> <output directory <output file prefix>
Input
Output
-
Usage
perl calculate-allele-frequency.pl <inut vcf file> > <output file>
Output
The output file will contain the following columns
- CHR
- POS
- REF
- ALT
- ALLELE_FREQ
- TOTAL_GENOTYPE
- TOTAL_HET
- TOTAL_HOM