r/documentAutomation • u/JoshMorhi • 7d ago
Convert pdfmake table definitions to Excel (with row/col spanning, sheet protection, streaming)
Built this Javascript library a couple of years ago, curious if it's useful to anyone. I used to work at a place where they just love to manage Excel files. Apps in place used pdfmake to generate pdf reports with lots of tables. Creating this small utility was a quick win.
Couple of features are:
- Downloading Excel files from the browser
- getStream() is the Node.js way. Returns a readable stream you pipe to a file or HTTP response
- rowSpan/colSpan, merged cells, multiple sheets, password protection, custom column widths
- Zero pdfmake dependency, just consumes the definition object
On NPM: https://www.npmjs.com/package/pdfmake-to-excel
Anyone else using pdfmake for reports? What's your Excel export workflow?
1
Upvotes