There are hundreds of Excel tables with different style styles. Each different Excel table uploads, in addition to the table header, to get the data of the indeterminate row, the code to write is not all the same? Write a different code for each Excel table?
Oh, yes, not at the same time import ...
(It seems a bit around ...) )
Reply content:
There are hundreds of Excel tables with different style styles. Each different Excel table uploads, in addition to the table header, to get the data of the indeterminate row, the code to write is not all the same? Write a different code for each Excel table?
Oh, yes, not at the same time import ...
(It seems a bit around ...) )
Phpexcel just follow the ranks to get the content. If you have a variable content, you can make a dynamic operation. For example:
Load the Excel content first, and then list it. Then manually select which column corresponds to which data you need and then import it ~ ~
Of course, certain specific rules can be automatically imported, such as phone numbers, names and other specific characteristics of the field can be judged.
or fixed header content, etc.
You can refer to the GUI program import method, first import the first row header, manually specify which column corresponds to which field and then perform the import