Build 4.5.0.20 of xlsgen makes it possible to convert dynamic ranges.

xlsgen exposes two kind of ranges : one is the most generic, actually holding a formula, and these are called dynamic ranges. They do not expose much features except an associated name (hence the name, named range) and the ability to enumerate and delete any of them. The other are regular ranges, basically holding one or more cell areas. Regular ranges expose a lot of features (almost 50) : from a regular range, you can create merged cells, outlines, tables, ...

Well it turns out, sometimes you need to use an existing dynamic range in order to create an object that typically is created from a regular range. So you need a way to convert a dynamic range to a regular range seamlessly. That's exactly what xlsgen 4.5.0.20 does. xlsgen does calculate the dynamic range and expands the output as cell areas as a regular range.

xlsgen::IXlsRangePtr regularRange = workbook->NamedRanges->DynamicRange[2]->Range;