close Warning: Can't synchronize with repository "(default)" (/var/svn/tolp does not appear to be a Subversion repository.). Look in the Trac log for more information.

Opened 14 years ago

Last modified 14 years ago

#1216 accepted defect

ActivateWS and ActivateNamedWS only activate the first sheet

Reported by: Jorge Owned by: Jorge
Priority: high Milestone: TOL Packages
Component: Excel API Version: 2.0.1
Severity: critical Keywords:
Cc: jmdedios@…

Description

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(?);

Attachments (1)

Capacidades_20100601.xls​ (4.1 MB) - added by Jorge 14 years ago.

Change History (2)

Changed 14 years ago by Jorge

Attachment: Capacidades_20100601.xls​ added

comment:1 Changed 14 years ago by Jorge

Status: new → accepted

This ticket comes from #1215.

Note: See TracTickets for help on using tickets.