You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
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
The text was updated successfully, but these errors were encountered: