PHPExcel获取相对于给定列的列名 [英] PHPExcel get column name relative to given column

问题描述

使用PHPExcel，是否有可能获得位于X左右数列的列名?

Using PHPExcel, is it possible to get the name of a column located X number of columns to the left or right?

例如，给定列BZ，我想返回列名CB或BX. (在右侧或左侧2)

Example, given column BZ, I'd like to return column name CB or BX. (2 to the right or left)

谢谢

推荐答案

PHPExcel中已经内置了一些函数来帮助您完成此任务

There are functions already built into PHPExcel to help you do this

$adjustment = -2;
$currentColumn = 'BZ';

$columnIndex = PHPExcel_Cell::columnIndexFromString($currentColumn);
$adjustedColumnIndex = $columnIndex + $adjustment;
$adjustedColumn = PHPExcel_Cell::stringFromColumnIndex($adjustedColumnIndex - 1);

请注意(历史)差异，即columnIndexFromString()将为A列返回1，但stringFromColumnIndex期望0对应于A列

Note the (historic) discrepancy that columnIndexFromString() will return a 1 for column A, but that stringFromColumnIndex expects a 0 to correspond to column A

这篇关于PHPExcel获取相对于给定列的列名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！