How to repair the excel file in the program?

when you import data from an excel file, there are errors when you open the file (as shown below), and you can"t read the data correctly, so you need to manually "Save as" to read the data correctly, but this is too inefficient and troublesome, what can you do to automatically realize "Save as" through the program?

the technology stack I use is: the package imported into excel by PHP+Laravel, is maatwebsite/excel

.

clipboard.png

Mar.20,2021

try to use the popular excel package phpoffice/phpexcel


try to modify the config file:

'import'     => array(
     'to_ascii'  => false, //false
)
Menu