Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
geoffross opened this issue Mar 22, 2017 · 0 comments
Open

Comments

@geoffross
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant