English 中文(简体)
php PHPExcel split Excel cell coordinate
原标题:

currently, I used PHPExcel to import excel file, there is a function $cell->getCoordinate();

I would like to ask any solution for split the cell coordinate alphabet and integer?

e.g A1, A2,

I need to know currently which row, and until which column.

I do some research about split, but not luck for it. Any idea?

最佳回答

This:

$coord =  AF13 ;
preg_match_all( ~[A-Z]+|d+~ , $coord, $split);
print_r($split);

Will produce:

Array (
  [0] => Array (
    [0] => AF
    [1] => 13
  )
)
问题回答
$coordinate = PHPExcel_Cell::coordinateFromString( A1 );
var_dump($coordinate);




相关问题
Brute-force/DoS prevention in PHP [closed]

I am trying to write a script to prevent brute-force login attempts in a website I m building. The logic goes something like this: User sends login information. Check if username and password is ...

please can anyone check this while loop and if condition

<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...

定值美元

如何确认来自正确来源的数字。

Generating a drop down list of timezones with PHP

Most sites need some way to show the dates on the site in the users preferred timezone. Below are two lists that I found and then one method using the built in PHP DateTime class in PHP 5. I need ...

Text as watermarking in PHP

I want to create text as a watermark for an image. the water mark should have the following properties front: Impact color: white opacity: 31% Font style: regular, bold Bevel and Emboss size: 30 ...

How does php cast boolean variables?

How does php cast boolean variables? I was trying to save a boolean value to an array: $result["Users"]["is_login"] = true; but when I use debug the is_login value is blank. and when I do ...

热门标签