There are hundreds of excel files in different formats in PHP. What if you upload and save them to the database?

in PHP, there are hundreds of excel files in different formats. If you upload and save them to the database, thank you very much.
I tried to read the first line first, then modified to determine the location of each column, but will report illegal file uploads, and then I deleted

.
May.03,2022

read the data out of columns and rows and serialize serialize and store it in a field in the database. When you use it, you can deserialize unserialize


if you only consider saving, you can convert the excel file to binary first and save it using mysql's binary field types binary and varbinary.

Menu