DragonFly On-Line Manual Pages

xlcells(1)(TDH)                                                xlcells(1)(TDH)

NAME
       xlcells(1)

SYNOPSIS
       cat tabdata | xlcells options  cell1 .. cellN

DESCRIPTION
       Extract "cells" by spreadsheet location from a spreadsheet export tab-
       delimited file.  For example, it may be used to automatically retrieve
       certain fields from a collection of spreadsheet-exported files.

       Examples of cell addresses are 1A or 247AB.  The alpha portion may be
       upper or lower case.

       Output is a tab-delimited row of requested values.

OPTIONS
       -bsym

              Set the blank symbol to sym.  By default, blank cells are
              represented as a zero-length string.  This option allows blank
              cells to be represented using the given sym.  Example: -b=

LIMITATIONS
       Rows 1-5000 and cols A - JJ supported.

       Max cell length 255.

       Max input line length 5000 chars.

       Max # of requested cells is 50.

EXAMPLE
       Example: cat tabdata | xlcells 35c 32c 22b

AUTHOR
       Steve Grubb

                         19-SEP-2003   TDH scg@jax.org         xlcells(1)(TDH)