PHPOffice/PhpSpreadsheet get cell column index as integer

php excel phpspreadsheet phpoffice
Jona picture Jona · Apr 18, 2018 · Viewed 7.8k times · Source

How can I get cell column index as integer? I have searched the documentation but I didn't found anything.

Answer

saeed yadgari picture saeed yadgari · Feb 7, 2019

please see Accessing cells

$ColumnIndex = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::columnIndexFromString($Column);

Related questions

Composer require phpoffice/phpspreadsheet doesn't work

I want to write a Script using the package Phpspreadsheet. I am not experience in php. I am trying to add the reference to my script through sudo composer require phpoffice/phpspreadsheet. But it doesn't work. I am getting the …

Read More
Write data from array to sheet using phpspreadsheet library

How can I create excel sheet column headers from array using phpspreadsheet library? Below is the code I am trying but it's not working: // $header is an array containing column headers $header = array("Customer Number", "Customer Name", "Address", "City", "State", "…

Read More
PHPSpreadsheet: how to get the number of loaded rows?

How do I find out how many rows I have loaded using PHPSpreadsheet\Reader\Xlsx::load() method? I cannot find methods (or properties) for getting row count in Spreadsheet or Worksheet classes either. BTW I am using following code: $filename = …

Read More