php - How do I get data from specific cells and then all the rows starting from a specific row during XSLX import in laravel using Laravel Excel?
one text
I have a excel file with multiple sheets.
Other sheets have the same format as the first one. I am using laravel excel. I am using php 8 and laravel 9. I want to get the Staff Name first and then get the rows from 19th row, which is the supposed starting point of the row heading. How am I supposed to do this?
I tried to use the WithMultipleSheets concern and then for each sheet, I tried to use WithMappedCells to access the specific cell. But this would return only the specific cell. Then for the rows I used the WithHeadingRow concern, and set the starting point to 19th row. This returned all the rows from the 19th row, but I want to get the specific cell data as well which is the staff name. I found out that WithMappedCells and WithHeadingRow will not work together. So, how am I supposed to solve this problem?
Source