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