I am trying to use HSSFSheet.shiftRows(int startRow, int endRow, int n);
public void shiftRows(int startRow,
Shifts rows between startRow and endRow n number of rows. If you use a negative number, it will shift rows up. Code ensures that rows don't wrap around. Calls shiftRows(startRow, endRow, n, false, false);
Additionally shifts merged regions that are completely defined in these rows (ie. merged 2 cells on a row to be shifted).
shiftRows in interface Sheet
startRow - the row to start shifting
endRow - the row to end shifting
n - the number of rows to shift
So far no luck, I think I am close. Any hints will be appreciated.