RUNXLRD(1)

πŸ“¦
version 2.0.2 Β· 2 versions
, in debian trixie, ubuntu noble, ubuntu questing, ubuntu resolute, ubuntu stonking

πŸ’– 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 πŸ’…
  • -l logfilename β€” this is where the error messages go. your receipts, basically 🧾
  • -v verbosity, --verbosity=verbosity β€” how much information and diagnostics you want. dial the yapping up or down πŸ—£οΈ
  • -m mmap, --mmap=mmap β€” 1: use mmap; 0: don't use mmap; -1: accept heuristic. pick your fighter πŸ₯Š
  • -e encoding, --encoding=encoding β€” encoding override. when the vibes are wrong, you fix the vibes πŸ› οΈ
  • -f formatting, --formatting=formatting β€” 0 (default): no fmt info Β· 1: fmt info (all cells) Β· 2: fmt info (margins trimmed). the glow-up levels ✨
  • -g gc, --gc=gc β€” 0: auto gc enabled; 1: auto gc disabled, manual collect after each file; 2: no gc. spring cleaning, but for memory 🧹
  • -s onesheet, --onesheet=onesheet β€” restrict output to this sheet (name or index). monogamy, but for spreadsheets πŸ’œ

🌈 COMMANDS 🌈

The main commands are:

  • 2rows
  • 3rows
  • bench
  • hdr
  • labels
  • names
  • ov
  • show
  • version
  • xfc
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 πŸ¦‹


πŸŽ€ 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