Data::...adsheet(3pm)

📦
version 0.021 · 3 versions
, in debian trixie, ubuntu resolute, ubuntu stonking

💖 Data::TableReader::Decoder::Spreadsheet — the manual, but make it cute 💖

okay bestie, so this is a perl manual page, section 3pm, from User Contributed Perl Documentation, and the module is Data::TableReader::Decoder::Spreadsheet. Yes, the title got chopped to Data::...adsheet(3pm) up in the header, but we both know what it really is. 🎀

✨ NAME ✨

Data::TableReader::Decoder::Spreadsheet — it's the base class for implementing spreadsheet decoders. literally the blueprint, the mother of all spreadsheet-reading children. 👑

🌸 VERSION 🌸

version 0.021 — that's the one, bestie, that's the version. 💅

🦋 DESCRIPTION 🦋

So here's the vibe: this is a base class for any file format that exposes a spreadsheet API compatible with Spreadsheet::ParseExcel. That's it, that's the whole assignment. If your thing acts like Spreadsheet::ParseExcel, it can hang out here. 🫶

🌈 ATTRIBUTES 🌈

fr fr, before you look at these, go peek at the attributes from the parent class: Data::TableReader::Decoder. The family tree matters, iykyk. 🌳

📊 workbook

This is an instance of Spreadsheet::ParseExcel, Spreadsheet::ParseXLSX, or Spreadsheet::XLSX — and the gag is that all three happen to have the same API. iconic coincidence, no cap. ✨

Subclasses can lazy-build this from the file_handle. Not me procrastinating until someone actually asks for it 😭 — but yes, lazy. Delulu? No. Efficient.

📄 sheet

This one is flexible in the most main-character way. It's either:

  • a sheet name,
  • a regex for matching a sheet name, or
  • a parser's worksheet object.

And she's also optional — if you don't set it, all sheets will be iterated. All of them. Every single one. go off, queen 👑

🎀 xls_formatter

An optional object that gets passed to the Excel parsers Spreadsheet::ParseXLSX and Spreadsheet::ParseExcel. It governs how raw data in cells is formatted into values, depending on the type of the cell. 💅

The parsers create one of their own if none is provided — usually Spreadsheet::ParseExcel::FmtDefault. so if you show up empty-handed, they got you, bestie. 🫶

⚠️ not me warning you: note that it does not work for Spreadsheet::XLSX, which hardcodes the formatter as Spreadsheet::XLSX::Fmt2007. So like, that one's not listening to you. periodt. 💀

👑 AUTHOR 👑

Michael Conrad <mike@nrdvana.net> — shoutout to the author, the moment, the legend. 🌟

This software is copyright (c) 2024 by Michael Conrad.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself. slay. free software ate and left no crumbs. 🍓

aaaand that's the whole page, bestie!! 🧚 this was generated with perl v5.38.2, dated 2024-06-21, and the manual page itself is Data::...adsheet(3pm). mwah, love u, go decode some spreadsheets 💖✨🌸

📦 where this page comes from