PSWriteExcel

0.0.14

Public/Set-ExcelTranslateFromR1C1.ps1

                                function Set-ExcelTranslateFromR1C1 {

    [CmdletBinding()]

    param(

        [int]$Row,

        [int]$Column = 1

    )

    $Range = [OfficeOpenXml.ExcelAddress]::TranslateFromR1C1("R[$Row]C[$Column]", 0, 0)

    return $Range

}