Specified column type in Excel.ReadRange

[Jorge]

When reading a range using Excel.ReadRange the empty cells are returned as Text "". It is requested a way to specify data type for the columns of the range in order to create the corresponding missing value instead of Text ""

[Jorge]

(In [3212]) closes #1099, now Excel.ReadRange accept an extra argument with de default values for every column

[Jorge]

(In [3214]) * Updating BasicExcel & FormatExcel

• Excel.ReadRange: when a columns type is specified all cells are readed as typed. refs #1099
• Excel.ReadSeries: implemented, fixes #1100

[Víctor de Buen Remiro]

The argument ColumnTypes is not explained at description.
I suposed that a set of type names was expected but is the type of each element which are set for the column.
I think that ColumnDefault was a more explicit name for this argument.

When you specifies a column of type Real and there is some empty or non numeric cell, then a warning is launched for every one. When there are hundreds or thousands of missing values this can be very slow, baffling and maddening.So, a good feature could be another optional argument that specifies the verbosity of this kind of messages. User could get all messages like now, hide all messages or get just one message with the total number of non numeric cells.

So, a good feature could be another optional argument that specifies the verbosity of this kind of messages. User could get all messages like now, hide all messages or get just one message with the total number of non numeric cells.

[Víctor de Buen Remiro]

Passing Empty in argument ColumnTypes should be the same effect that pass no argument but it shows a warning message

The number of column's types does not match the number of columns ...

[Víctor de Buen Remiro]

Here there is an example that shows a lot of irrelevant warnings.

You must compile first the package ImportExport due is not already uplodaded.

[Víctor de Buen Remiro]

We can avoid the warnings in this way

Real old.warn = Show(False,"WARNING");
...
Real Show(old.warn,"WARNING");