PhpSpreadsheet VS Tabulator

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

Coded mainly in Perl and Gnuplot, recently extended by Python Pandas and JavaScript Tabulator and ECharts

We use Tabulator for a similar use case at my job, it has a virtual DOM to support thousands of rows pretty well. It's not React based, it's a vanilla JS library. There is a React wrapper here but I don't have experience with that.

If you familiar with programming, then defiantly it way to go, tabulator as a CRUD for frontend and simplest sqlite backend. The reason such type of apps not broadly exists is that because any business has it's own workflow, so all-in-one common apps became overloaded with useless features but doesn't have feature a client needs

as well to have a choice for theme with detailed info page (size/modefied-time) with sorting capability (by utilizing something like tabulator)

I am a mostly backend dev using python and only know enough JS to be dangerous. I am doing some simple front-end work for my job, and I am using tabulator.js which creates a column with an x in it. When that x is clicked, this function runs.

Yeah. NaiveUI is good. Also check tabulator. http://tabulator.info/