Query: runxlrd
OS: debian
Section: 1
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
RUNXLRD(1) General Commands Manual RUNXLRD(1)NAMErunxlrd - extract data from Microsoft Excel spreadsheet filesSYNOPSISrunxlrd [options] command [input-file-patterns]DESCRIPTIONThis 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.OPTIONS-h, --help Show summary of options and exit. -l logfilename Contains error messages. -v verbosity, --verbosity=verbosity Level of information and diagnostics provided. -p pickleable, --pickleable=pickleable 1: ensure Book object is pickleable (default); 0: don't bother. -m mmap, --mmap=mmap 1: use mmap; 0: don't use mmap; -1: accept heuristic. -e encoding, --encoding=encoding Encoding override. -f formatting, --formatting=formatting 0 (default): no fmt info 1: fmt info (all cells) 2: fmt info (margins trimmed). -g gc, --gc=gc 0: auto gc enabled; 1: auto gc disabled, manual collect after each file; 2: no gc. -s onesheet, --onesheet=onesheet Restrict output to this sheet (name or index).COMMANDSValid commands are o dump o count_records o version o hdr o ov o show o 2rows o 3rows o bench o names o name_dump o labels o xfc o hotshot o profile See the xlrd API documentation for the meaning of these commands.EXAMPLESTo show the first, second and last rows of each sheet in each file, run $ runxlrd 3rows *blah*.xls Run $ runxlrd -e koi8_r 3rows myfile.xls to explicitly pass the needed codepage to xlrd, e.g. if the codepage record is missing, or if it exists but is wrong.SEE ALSOThe xlrd API documentation, shipped in the file xlrd.html. The xlrd website <http://www.lexicon.net/sjmachin/xlrd.htm>.AUTHORrunxlrd was written by John Machin. This manual page was written by Joost van Baal <joostvb+debian@uvt.nl>, for the Debian project (but may be used by others). xlrd 0.6.1a4 2007-05-24 RUNXLRD(1)
Related Man Pages |
---|
docdiff(1) - debian |
pdftohtml(1) - debian |
runxlrd(1) - debian |
ssconvert(1) - centos |
pdftohtml(1) - osx |
Similar Topics in the Unix Linux Community |
---|
Opening a Unix File in Windows. |
awk and leading zeroes |
Expand cells in .xls file created in unix |
Perl syntax for formatting columns and text |
How to avoid the spaces? |