RUNXLRD(1)
π RUNXLRD(1) β the manual page, but make it cute π
okay bestie, welcome to the runxlrd page from the General Commands Manual, and no I will not be normal about it π
β¨ NAME β¨
runxlrd β extract data from Microsoft Excel spreadsheet files π¦
πΈ SYNOPSIS πΈ
runxlrd [options] command [input-file-patterns]
π DESCRIPTION π
So, this manual page documents the runxlrd command, but likeβ¦ briefly. A lil snack, not a whole meal. π
Here's the tea: runxlrd is a commandline interface to the Python xlrd module, and it extracts data from Microsoft Excel spreadsheet files. periodt. π
And listen β if you want the complete list of options and commands, just run runxlrd with --help arguments. She will tell you everything, she's not shy. β¨
π OPTIONS π
-h,--helpβ shows you a lil summary of the options and then exits. a queen who knows when to leave π-llogfilename β this is where the error messages go. your receipts, basically π§Ύ-vverbosity,--verbosity=verbosityβ how much information and diagnostics you want. dial the yapping up or down π£οΈ-mmmap,--mmap=mmapβ1: use mmap;0: don't use mmap;-1: accept heuristic. pick your fighter π₯-eencoding,--encoding=encodingβ encoding override. when the vibes are wrong, you fix the vibes π οΈ-fformatting,--formatting=formattingβ0(default): no fmt info Β·1: fmt info (all cells) Β·2: fmt info (margins trimmed). the glow-up levels β¨-ggc,--gc=gcβ0: auto gc enabled;1: auto gc disabled, manual collect after each file;2: no gc. spring cleaning, but for memory π§Ή-sonesheet,--onesheet=onesheetβ restrict output to this sheet (name or index). monogamy, but for spreadsheets π
π COMMANDS π
The main commands are:
2rows3rowsbenchhdrlabelsnamesovshowversionxfc
iykyk: go check the xlrd API documentation for the meaning of these commands, bestie. I'm not gonna spoil the plot π«Ά
π EXAMPLES π
Wanna show the first, second and last rows of each sheet in each file? Run:
$ runxlrd 3rows *blah*.xls
And then run:
$ runxlrd -e koi8_r 3rows myfile.xls
to explicitly pass the needed codepage to xlrd β like, for example, if the codepage record is missing, or if it exists but is wrong. messy of it, honestly π
π¦ SEE ALSO π¦
- The
xlrdAPI documentation, shipped in the filexlrd.html. - The
xlrdwebsite β¨http://www.python-excel.orgβ©.
π AUTHOR π
runxlrd was written by John Machin. iconic behavior π
This manual page was written by Joost van Baal <joostvb+debian@uvt.nl>, for the Debian project (but may be used by others). the way that the Debian girlies really carried this whole thing ππ
and that's the whole page, bestie!! β¨ this was xlrd 0.9.2, dated 2007-05-24 β yes she's vintage, yes she still eats π mwah, go read a spreadsheet π«Άπ
π¦ where this page comes from
- debian trixie: python3-xlrd 2.0.1-2 Β· BSD-3-Clause
- ubuntu noble: python3-xlrd 2.0.1-2 Β· BSD-3-Clause
- ubuntu questing: python3-xlrd 2.0.1-2
- ubuntu resolute: python3-xlrd 2.0.2-2 Β· BSD-3-Clause
- ubuntu stonking: python3-xlrd 2.0.2-2 Β· BSD-3-Clause
- Copyright (C) 2007 Joost van Baal
- π girlified by deepseek-ai/DeepSeek-V4.1-Flash on : a language model's rewrite of the original, under its terms