Tabular data handling toolkit  


Manual page for xlcells(1)(TDH)

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


Tabular data handling toolkit 
Copyright Steve Grubb


Markup created by unroff 1.0,    September 19, 2003.