Build 4.5.0.52 of xlsgen improves the import of all 4 input file formats namely CSV, XML, HTML and JSON.

When custom data mapping was introduced in build 4.5.0.4, meaning that you can pass a number format for any given column of data being imported, we said that chances are that we would, in the long run, end up having some kind of AI or intelligent automatic inference that would figure it the data it is importing, and would therefore infer the number format itself. That's what build 4.5.0.52 brings to the table. Not a single line of code is needed.

Let's say in the data you import, there is a "length" column with a number of kilometers to it, ie :

12 kms
15 kms
50 kms
75 kms
...

Since build 4.5.0.4, if you want this data to be imported as numbers and retain this "kms" suffix, you would pass it like this to the import engine : options.ColumnDataMappingFormatByName[L"length"] = "0 \"kms\"";

With build 4.5.0.52, this line of code is not needed anymore. It is magically inferred. And it works the same for all CSV, XML, HTML and JSON files.