perl-utils

Custom Perl based utilities

1. Apply rich text formatting into a spreadsheet (xlsx)

   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.

   1. Requirements

      Excel::Writer::XLSX

   2. Usage

      perl table-to-spreadsheet.pl <input table delimited file> <output directory <output file prefix>

   Input

   

   Output