Skip to content

When using -RowStart, you get that many extra empty rows on the end #52

@geoffross

Description

@geoffross

Due to line 132 in Import-XLSX.ps1
$RowEnd = $Rows + $RowStart - 1
when using -RowStart the $RowEnd variable gets incremented by the number of rows to skip.

If i have a total of 10 rows and want to skip the first 5 i will use -RowStart 6

But I still want to only import until row 10, so $RowEnd should still be 10 and not 15 (10 + 6 -1)

Otherwise I get my 5 rows as desired and then another 5 objects in the output array with every value as a $null.

Same deal with -ColStart

Updated code in Pull Request #51

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions