ExcelFast

0.0.1-alpha07

Formats/XLWorksheet.Types.ps1xml

                                <?xml version="1.0" encoding="utf-8"?>

<Types>

    <Type>

        <Name>ClosedXML.Excel.XLWorksheet</Name>

        <Members>

            <ScriptProperty>

                <Name>RowCount</Name>

                <GetScriptBlock>

                    $this.RowCount()

                </GetScriptBlock>

            </ScriptProperty>

            <ScriptProperty>

                <Name>ColumnCount</Name>

                <GetScriptBlock>

                    $this.ColumnCount()

                </GetScriptBlock>

            </ScriptProperty>

            <ScriptProperty>

                <Name>IsProtected</Name>

                <GetScriptBlock>

                    $this.Protection.IsProtected

                </GetScriptBlock>

            </ScriptProperty>

            <ScriptProperty>

                <Name>FirstRowUsed</Name>

                <GetScriptBlock>

                    $firstRow = $this.FirstRowUsed()

                    if ($null -ne $firstRow) { $firstRow.RowNumber() }

                </GetScriptBlock>

            </ScriptProperty>

            <ScriptProperty>

                <Name>LastRowUsed</Name>

                <GetScriptBlock>

                    $lastRow = $this.LastRowUsed()

                    if ($null -ne $lastRow) { $lastRow.RowNumber() }

                </GetScriptBlock>

            </ScriptProperty>

            <ScriptProperty>

                <Name>FirstColumnUsed</Name>

                <GetScriptBlock>

                    $firstColumn = $this.FirstColumnUsed()

                    if ($null -ne $firstColumn) { $firstColumn.ColumnNumber() }

                </GetScriptBlock>

            </ScriptProperty>

            <ScriptProperty>

                <Name>LastColumnUsed</Name>

                <GetScriptBlock>

                    $lastColumn = $this.LastColumnUsed()

                    if ($null -ne $lastColumn) { $lastColumn.ColumnNumber() }

                </GetScriptBlock>

            </ScriptProperty>

        </Members>

    </Type>

</Types>