gotenberg VS PhpSpreadsheet

Use a server-side headless browser such as puppeteer to convert the HTML to PDF. This is the most reliable free option, but requires a server. If you need to use it in production, we recommend you use Gotenberg.

We're using Gotenberg[1] to convert a rendered web page (with Elixir/Phoenix, in our case) to PDF. Works like a charm and we can use our existing frontend code/styling (including SVG graph generators) which is a huge bonus.

1: https://gotenberg.dev/

If you also want to convert Markdown or LibreOffice formats, the self-hosted API Gotenberg is worth checking out

I found a project that does exactly that (https://github.com/gotenberg/gotenberg). It’s my best bet for now, but I still need to test GraalVM integration with JS runtimes (and test JS libraries) and the Kotlin compiler targeting Node.

Gotenberg is a Docker-based stateless API for PDF generation from HTML and Markdown files.

Think you mean https://gotenberg.dev ?

We use https://gotenberg.dev/ with handlebars templates.

We have used a PHP Script to do this https://github.com/PHPOffice/PhpSpreadsheet

If I need the data to be well-formatted in Excel, directly from the export, then I use PhpSpreadsheet. Otherwise, I'll just write to a CSV file.

here

I'm using PhpSpreadsheet to generate an Excel file. It works really well, but now I'd like to reopen the file it created downstream and assign every cell value in one specific column to a simple, flat array where, say, the 1 key of this array might be the name of the column and the values are the column's cell values? Or even just a simple array with only the values...?

For the library, there is PhpOffice

a full list of sizes is in this file, https://github.com/PHPOffice/PhpSpreadsheet/blob/master/src/PhpSpreadsheet/Worksheet/PageSetup.php

You can use phpspreadsheet. It's the library that LaravelExcel relies on. Here's samples from their git repo: https://github.com/PHPOffice/PhpSpreadsheet/blob/master/samples/Chart/33_Chart_create_pie.php