Build 4.5.0.51 of xlsgen brings a number of improvements to all of the 4 input file formats, i.e. CSV, XML, HTML and JSON.

The improvements are :

- improved usage of # and 0 when automatically inferring the type and number format of data that appear to be numbers (integer or float)

- improved currency detection when automatically inferring the type and number format of data that appear to be currencies, that is, numbers with an accompanying currency symbol

- improved disambiguation of date, time and date+time when automatically inferring the type and number format of data that appear to be date or time related

- better import of different data types inside the same column


Overall, when you are importing a CSV file, an XML file, an HTML file or a JSON file, the automatic import engine works better at finding the actual data types and tries a lot inferring an appropriate number format, resulting in data that are imported correctly and are therefore ready for calculations and charting. Of course, any custom option that may be set before the Import statement takes precedence over what is automatically inferred, letting a client application really control how data is imported.