Build 4.5.0.22 of xlsgen adds support for shifting cells in a range.



Shift cells (before on the left, after on the right)

xlsgen shifts cells if a client application deletes entire rows or entire columns. But the client application may need such shift for an arbitrary cell range. When this occurs, the client application must choose to ask xlsgen to fill the blank by shifting cells to the left, or shifting cells up.

Here is how it works :

worksheet.NewRange("D5:E7").ShiftCellsLeft();

or

worksheet.NewRange("D5:E7").ShiftCellsUp();