jetstream VS PhpSpreadsheet

For writing models I would suggest using Action Closes. One example of them can be found in Jetstream's sourcecode. Actions are great to test in isolation and link to user stories.

While I prefer python for everything else, I'd go with Laravel Jetstream[1] for an MVP, just like I did with the last one I had to build. It's laravel, you can use Vue (React or Svelte) for your views instead of the blade templating language that comes with the framework. Jetstream also comes with Auth, user login and subscription and other useful stuff.

And for the flavor, I'd just go with DaisyUI[2] again, since it's based on tailwindcss and it's what I've been using lately.

In my experience, I can build MVPs real fast with the stack described above.

[1] https://jetstream.laravel.com

A well-implemented example of this would be in Laravel Jetstream, where an Actions namespace is defined for performing user-oriented tasks in Laravel Fortify — such as updating the user profile.

This legacy package is a very simple authentication scaffolding built on the Bootstrap CSS framework. While it continues to work with the latest version of Laravel, you should consider using Laravel Breeze for new projects. Or, for something more robust, consider Laravel Jetstream.

Laravel provide us with robust solutions and starter kits for authentication so let's start by creating a new Laravel 9 project and install Jetstram

In terms off bullet points you added, I've made something pretty similar using Laravel with : Laravel Jetstream(application starter kit with inertia + vue stack) https://jetstream.laravel.com/

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