private function _writeBIFF8CellRangeAddressFixed($range = 'A1')
	{
		$explodes = explode(':', $range);

		// extract first cell, e.g. 'A1'
		$firstCell = $explodes[0];

		// extract last cell, e.g. 'B6'
		if (count($explodes) == 1) {
			$lastCell = $firstCell;
		} else {
			$lastCell = $explodes[1];
		}

		$firstCellCoordinates = PHPExcel_Cell::coordinateFromString($firstCell); // e.g. array(0, 1)
		$lastCellCoordinates  = PHPExcel_Cell::coordinateFromString($lastCell);  // e.g. array(1, 6)

		return(pack('vvvv',
			$firstCellCoordinates[1] - 1,
			$lastCellCoordinates[1] - 1,
			PHPExcel_Cell::columnIndexFromString($firstCellCoordinates[0]) - 1,
			PHPExcel_Cell::columnIndexFromString($lastCellCoordinates[0]) - 1
		));
	}
private function _writeBIFF8CellRangeAddressFixed($range = 'A1')
	{
		$explodes = explode(':', $range);

		// extract first cell, e.g. 'A1'
		$firstCell = $explodes[0];

		// extract last cell, e.g. 'B6'
		if (count($explodes) == 1) {
			$lastCell = $firstCell;
		} else {
			$lastCell = $explodes[1];
		}

		$firstCellCoordinates = PHPExcel_Cell::coordinateFromString($firstCell); // e.g. array(0, 1)
		$lastCellCoordinates  = PHPExcel_Cell::coordinateFromString($lastCell);  // e.g. array(1, 6)

		return(pack('vvvv',
			$firstCellCoordinates[1] - 1,
			$lastCellCoordinates[1] - 1,
			PHPExcel_Cell::columnIndexFromString($firstCellCoordinates[0]) - 1,
			PHPExcel_Cell::columnIndexFromString($lastCellCoordinates[0]) - 1
		));
	}
private function _writeBIFF8CellRangeAddressFixed ( $ range = 'A1' ) { $ explodes = explode ( ':' , $ range ) ; // extract first cell, e.g. 'A1' $ firstCell = $ explodes [ 0 ] ; // extract last cell, e.g. 'B6' if ( count ( $ explodes ) == 1 ) { $ lastCell = $ firstCell ; } else { $ lastCell = $ explodes [ 1 ] ; } $ firstCellCoordinates = PHPExcel_Cell :: coordinateFromString ( $ firstCell ) ; // e.g. array(0, 1) $ lastCellCoordinates = PHPExcel_Cell :: coordinateFromString ( $ lastCell ) ; // e.g. array(1, 6) return ( pack ( 'vvvv' , $ firstCellCoordinates [ 1 ] - 1 , $ lastCellCoordinates [ 1 ] - 1 , PHPExcel_Cell :: columnIndexFromString ( $ firstCellCoordinates [ 0 ] ) - 1 , PHPExcel_Cell :: columnIndexFromString ( $ lastCellCoordinates [ 0 ] ) - 1 ) ) ; }
Write a cell range address in BIFF8
always fixed range
See section 2.5.14 in OpenOffice.org's Documentation of the Microsoft Excel File Format

@param string $range E.g. 'A1' or 'A1:B6'
@return string Binary data
Write a cell range address in BIFF8 always fixed range See section 2 . 5 . 14 in OpenOffice . org s Documentation of the Microsoft Excel File Format