NPOI 2.2.0 try ShiftRows

Oct 13, 2015 at 8:52 AM
try read xlsx file and execute shiftrows

sheetReport.ShiftRows(sheetReport.LastRowNum-2, sheetReport.LastRowNum, 100);

result
An unhandled exception of type 'System.ArgumentOutOfRangeException' occurred in mscorlib.dll

min row when not error

sheetReport.ShiftRows(sheetReport.LastRowNum-5, sheetReport.LastRowNum, 100);
Dec 29, 2016 at 12:18 PM
Edited Dec 29, 2016 at 12:21 PM
I have the same issue with .xlsx files and .ShiftRows in 2.2.1. I saved the same file as an .xls and it didn't happen.