Help ~~ PHP: how to modify the second worksheet of excel now has an excel file & nbsp; you need to search the database data and add it to the second worksheet. The first worksheet is the distribution chart & nbsp; bar chart generated based on the data of the second worksheet... Therefore, you cannot generate new excel documents & nbsp; you can only modify them for help ~~ How does PHP modify the second excel worksheet?
Now there is an excel document that needs to retrieve the database data and add it to the second worksheet.
The first worksheet is a distribution chart column chart generated based on the data of the second worksheet...
Therefore, new excel documents cannot be generated and can only be modified.
Thank you for your support.
Share: More
------ Solution --------------------
The getActiveSheet method is used to obtain an active worksheet, that is, the worksheet that is displayed when an excel file is opened.
The getSheet method is used to obtain the worksheet with the specified serial number. it should be useful to you.
