Gitee
\
Adbar
AlibabaCloud
Tea
Exception
FileForm
FileForm
Tests
Alipay
EasySDK
Base
Image
Models
OAuth
Models
Qrcode
Models
Video
Models
Kernel
Exceptions
Util
Marketing
OpenLife
Models
Pass
Models
TemplateMessage
Models
Member
Identification
Models
Payment
App
Models
Common
Models
FaceToFace
Models
Huabei
Models
Page
Models
Wap
Models
Security
TextRisk
Models
Test
base
image
oauth
video
Base
marketing
openlife
pass
templatemessage
member
identification
multipleFactory
payment
common
facetoface
huabei
security
textrisk
util
generic
Util
AES
Generic
Models
app
controller
middleware
model
validate
BaconQrCode
Common
Encoder
Exception
Renderer
Color
Eye
Image
Module
EdgeIterator
Path
RendererStyle
BaconQrCodeTest
Common
Encoder
BarcodeBakery
Barcode
Common
Drawer
BigintTest
BugHonorFileTimeTest
Complex
Composer
Autoload
DASPRiD
Enum
Exception
EnumTest
Endroid
QrCode
Exception
Factory
Tests
Writer
GuzzleHttp
Cookie
Exception
Handler
Promise
Psr7
JmesPath
Khanamiryan
QrCodeTests
League
Flysystem
Adapter
Polyfill
Cached
Storage
Plugin
Util
MimeTypeDetection
Matrix
Decomposition
Operators
MyCLabs
Enum
PHPUnit
org
PhpOffice
PhpSpreadsheet
Calculation
Database
Engine
Engineering
Internal
Logical
MathTrig
Statistical
Token
Cell
Chart
Renderer
Collection
Document
Helper
Reader
Gnumeric
Ods
Security
Xls
Color
Style
Xlsx
Xml
RichText
Shared
Escher
DgContainer
SpgrContainer
DggContainer
BstoreContainer
BSE
JAMA
OLE
PPS
Trend
Style
ConditionalFormatting
Worksheet
AutoFilter
Column
Drawing
Writer
Ods
Cell
Pdf
Xls
Xlsx
Pimple
Exception
Psr11
Tests
Fixtures
Psr11
Psr
Cache
Container
Http
Client
Message
Log
Test
SimpleCache
Songshenzong
Support
Test
Core
Traits
spec
League
Flysystem
Cached
Stringy
Symfony
Component
OptionsResolver
Debug
Exception
PropertyAccess
Exception
PropertyInfo
DependencyInjection
Extractor
Util
String
Exception
Inflector
Slugger
VarDumper
Caster
Cloner
Command
Descriptor
Dumper
ContextProvider
Exception
Server
Test
Polyfill
Ctype
Intl
Grapheme
Normalizer
Mbstring
Php72
Php73
Php80
think
cache
driver
console
command
make
optimize
input
output
descriptor
driver
formatter
question
contract
db
builder
concern
connector
exception
event
exception
facade
file
filesystem
driver
helper
initializer
log
driver
middleware
model
concern
relation
paginator
driver
response
route
dispatch
service
session
driver
template
driver
exception
taglib
tests
trace
validate
view
driver
ZipStream
Exception
Option
ZipStreamTest
Zxing
Common
Detector
Reedsolomon
Qrcode
Decoder
Detector

\PhpOffice\PhpSpreadsheet\CellAddressHelper

Summary

Methods
Properties
Constants
convertToA1()
convertFormulaToA1()
convertToR1C1()
No public properties found
No constants found
No protected methods found
No protected properties found
N/A
No private methods found
No private properties found
N/A

Methods

convertToA1()

convertToA1(string  $address, int  $currentRowNumber = 1, int  $currentColumnNumber = 1) : string

Converts an R1C1 format cell address to an A1 format cell address.

Parameters

string $address
int $currentRowNumber
int $currentColumnNumber

Returns

string —

convertFormulaToA1()

convertFormulaToA1(string  $formula, int  $currentRowNumber = 1, int  $currentColumnNumber = 1) : string

Converts a formula that uses R1C1 format cell address to an A1 format cell address.

Parameters

string $formula
int $currentRowNumber
int $currentColumnNumber

Returns

string —

convertToR1C1()

convertToR1C1(string  $address, ?int  $currentRowNumber = null, ?int  $currentColumnNumber = null) : string

Converts an A1 format cell address to an R1C1 format cell address.

If $currentRowNumber or $currentColumnNumber are provided, then the R1C1 address will be formatted as a relative address.

Parameters

string $address
?int $currentRowNumber
?int $currentColumnNumber

Returns

string —