Forum


    Reply
    Replies: 1   Views: 331
    Conversion of numeric cell coordinates to excel style coordinates
    Topic closed:
    Please note this is an old forum thread. Information in this post may be out-to-date and/or erroneous.
    Every phpxlsx version includes new features and improvements. Previously unsupported features may have been added to newer releases, or past issues may have been corrected.
    We encourage you to download the current phpxlsx version and check the Documentation available.

    Posted by jeroen8087  · 02-02-2023 - 15:49

    Is there a utility to convert numeric cell coordinates to Excel-style coordinates? For instance, an (x,y) position (4,2) can be converted to D2 and (28,74) can be converted to AB74. I can use getCellPositions, but that is not useful if I want to put data in a field that has no data yet.

    This functionality is useful when I have to put information in a cell, where the exact position is variable. This can be the case when using different Excel templates.

    I created my own basic base26 converter, but I think it should be present in the phpxlsx library.