PHPSpreadsheet MySQL Table Creation Issue

As a PHP and MySQL expert, your task will be to fix a challenge I'm facing with PHPSpreadsheet. My Excel data is not being imported correctly into MySQL as tables are not being created. Despite no error messages alerting me to these issues, the hiccup persists. Below is a more detailed description. After login, the user uploads 4 required and 2 optional Excel files on the dashboard page. The files are uploaded to an “upload” folder on the server and the file names and other info are stored in the “files” table of the mysql database. All of the above works with no problems. Once the actions above are complete, a button at the bottom of the dashboard page is activated. When the button is pressed, PHPSpreadsheet is used to move the data from the Excel files in the “upload” folder to tables in the database. This is done in a similar way for all files and up until a couple of months ago, worked fine for all files, and then suddenly stopped working for only the largest file. Through my own tests, I’ve learned that if I remove the 30 columns prior to the last column in the problematic Excel file, it transfers fine, so it’s not a coding issue. There’s either a problem with too many columns or something in one or more of those 30 columns is causing an error when moving the data to the database. Since the website needs to be user friendly, we can’t expect the user to fix the Excel sheet. We also can’t just write code to remove the 30 columns prior to the last column, because all user files might not have the columns in the same order, so a required column might find itself in one of those locations. Based on my test results, one possible solution to the problem might be to write the code such that it only transfers the 10 columns that are needed in a subsequent mysql query. However, any solution that fixes the problem will be great. Here's what I need you to handle: - Diagnose and fix the issue. - Ensure successful creation of tables in my MySQL database from Excel data. Ideal Skills: • PHP • MySQL • Expertise with PHPSpreadsheet • Debugging • Experience with Excel-data moving projects. Informed bidding is appreciated – let's get this resolved together!