TolExcel Sheet selection functions behave imporperly

[jmdedios]

ActivateWS and ActivateNamedWS functions allways return 'True' value, even when the number or name of worksheet doesn't exist. If the worksheet doesn't exist, they print an error message like: 'ActivateNamedWS: no se ha posido establecer la hoja activa Alto Valor', but return 'True' instead of 'False'.

[jmdedios]

In addition to the previous comment, there are excel documents that cannot be read with these functions. The excel attached is impossible to be read because the functions ActivateWS and ActivateNamedWS can only activate the first sheet. The following code opens the excel attached an activates the first sheet ("Resumen Tráfico") but it returns an error when trying to activate another one.
However, the code using the old version of the functions, activates all the sheets of the excel book.

#Require TolExcel;
TolExcel::@WorkBook wb = TolExcel::@WorkBook::Open( "c:/Temp/Capacidades_20100701.xls" );
Real resSelHoj = wb::ActivateNamedWS("Resumen Tráfico");
wb::ActivateNamedWS("Desarrollo");
Real resSelHoj = wb::ActivateWS(1);
wb::ActivateWS(2);
Real wb::Close(?);

Text XLSOpenExcel("c:/Temp/Capacidades_20100701.xls", 0);
Text XLSSelectWorksheetIndex(3);
Text XLSSelectWorksheetByName("Desarrollo");
Text XLSQuit(?);

[Jorge]

The second part of this ticket has being move to #1216

[Jorge]

(In [3568]) fix #1215