Build 3.5.0.95 of xlsgen adds support for the wellknown UsedRange helper.
Traditional VBA programmers often rely on UsedRange in order to find the extent of cells in a given sheet, and use the range object capabilities to act on it, for instance deleting formulas in that range.
This is exactly what xlsgen supports. For instance,
worksheet.UsedRange.DeleteFormulas()
is a very handy mechanism for deleting formulas in the used range of the worksheet without having to build the cell range yourself.
The range object supports no less than 42 methods which means this is an effective mechanism. Just wish this was part of xlsgen long time ago already.