How do I get the value of a cell through the title? Non-numeric index (PHPExcel)

currently, I can only get cell values through getCell ("A4")-> getValue () , but there is a problem. Sometimes I want to delete or add a column, which destroys other values I want to save (because the data on xlsx tables A to Z has changed), so I have to reorder the data.
I want to know if there is a function that can mark my cell with title, for example, If I want to get the value of A4, I don"t need to use "A4", but through things like $title ["first"] [4], "B5" is $title"second", so as long as I judge isset ($title [" first"]) in the background of php, I can easily get the value, and I don"t have to worry about whether it has been deleted.
I don"t seem to find such a method in the manual at present. I would like to ask you if you have any thoughts

Phpexcel php

Mar.30,2021

Previous: The swiper plug-in cannot be initialized in vue?

Next: A doubt in some promise polyfill

How does Thinkphp5 store the exported excel table in the specified directory of the project directory on the server?
* excel table export @ param string $fileName file name @ param array $headArr header name @ param array $data data to be exported @ author static7 * function excelExport ($fileName = , $headArr = [], $data = []) { $fileName .= &quo...

Bash thinkphp5 phpexcel php

Jun.01,2021
PHPExcel how to batch data validation / entire column can be dropped down
PHPExcel can only set one cell to drop-down at a time. I want to set the whole column to drop-down effect. Is it possible? related codes Please paste the code text below (do not replace the code with pictures) $objExcel = new PHPExcel (); $ob...

Phpexcel php

Aug.05,2021
The calculation result of phpexcel read formula is-sharpVALUE!
first of all, the imported table is calculated with the formula (the values of many columns are calculated by the formula). There is no problem, but after import, it is found that the value of some columns is-sharpVALUE! (not all the columns calculated ...

Phpexcel php

Aug.24,2021

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b32c13-2be44.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b32c13-2be44.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?