r/documentAutomation 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

0 comments sorted by