Documentation read from 04/17/2019 22:07:28 version of /vol/public-pseed/FIGdisk/FIG/bin/svr_spreadsheet_to_file.

svr_spreadsheet_to_file -f filename -x coordinates

svr_spreadsheet_to_file -f filename -x coordinates

Writes the contents of the spreadsheet given in filename to a tab separated file on STDOUT.

If given, the coordinates delimit the cells to be written.

The output is a file of tab separated cells, one row per line.

Example: svr_spreadsheet_to_file -f test.xls > test.txt

Command-Line Options

-f

The file name of an xls or xlsx format spreadsheet.

-x

Coordinates to be displayed. These are given in the form (minx, miny, maxx, maxy) That is, 1,1,20,20 will choose cells starting in the leftmost corner of the spreadsheet to cell 20,20.

1,2,5,3 will start at row 1, column 2, and go to row 5, column 3.

Output Format

The standard output is a file to STDOUT where each line contains the contents of all the selected cells, separated by tabs.