logo
Free, unlimited AI code reviews that run on commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt

runxlrd - extract data from Microsoft Excel spreadsheet files

Author

       runxlrd 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.9.2                                         2007-05-24                                         RUNXLRD(1)

Commands

       Main commands are

       • 2rows3rowsbenchhdrlabelsnamesovshowversionxfc

       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]

See Also