runxlrd - extract data from Microsoft Excel spreadsheet files
Contents
Commands
Main commands are
• 2rows
• 3rows
• bench
• hdr
• labels
• names
• ov
• show
• version
• xfc
See the xlrd API documentation for the meaning of these commands.
Description
This manual page documents briefly the runxlrd command.
runxlrd offers a commandline interface to the Python xlrd module; it extracts data from Microsoft Excel
spreadsheet files. For a complete list of options and commands, run runxlrd with --help arguments.
Examples
To show the first, second and last rows of each sheet in each file, run
$runxlrd3rows*blah*.xls
Run
$runxlrd-ekoi8_r3rowsmyfile.xls
to explicitly pass the needed codepage to xlrd, e.g. if the codepage record is missing, or if it exists
but is wrong.
Name
runxlrd - extract data from Microsoft Excel spreadsheet files
Options
-h, --help
Show summary of options and exit.
-llogfilename
Contains error messages.
-vverbosity, --verbosity=verbosity
Level of information and diagnostics provided.
-mmmap, --mmap=mmap
1: use mmap; 0: don't use mmap; -1: accept heuristic.
-eencoding, --encoding=encoding
Encoding override.
-fformatting, --formatting=formatting
0 (default): no fmt info 1: fmt info (all cells) 2: fmt info (margins trimmed).
-ggc, --gc=gc
0: auto gc enabled; 1: auto gc disabled, manual collect after each file; 2: no gc.
-sonesheet, --onesheet=onesheet
Restrict output to this sheet (name or index).
See Also
The xlrd API documentation, shipped in the file xlrd.html.
The xlrd website ⟨http://www.python-excel.org⟩.
Synopsis
runxlrd[options]command[input-file-patterns]
