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 15 years ago

Closed 15 years ago

#964 closed defect (duplicate)

ReadRange excel function error

Reported by: jgarcia Owned by: Jorge
Priority: highest Milestone: TOL Packages
Component: Excel API Version: 2.0.1
Severity: blocker Keywords: excel
Cc:

Description

ReadRange function return an error if data in selected range has a DIV!0 value.

Set Tcl_Eval("source [file join "+PathSADD+"/common/gui/tcl/excel.tcl]");

Text path = "C:\\";
Text file = "Div0.xls";
Text fileXls = path+file;
Text XLSOpenExcel(fileXls, 0); 
Text XLSSelectWorksheetIndex(1);    

Set sOk = XLSReadRange("A1", "B1");
Set sError = XLSReadRange("A2", "B2");

Attachments (1)

Div0.xls​ (18.0 KB) - added by jgarcia 15 years ago.

Download all attachments as: .zip

Change History (3)

Changed 15 years ago by jgarcia

Attachment: Div0.xls​ added

comment:1 Changed 15 years ago by Jorge

Keywords: excel added
Milestone: → TOL Packages
Status: new → accepted

comment:2 Changed 15 years ago by Jorge

Resolution: → duplicate
Status: accepted → closed

There is no way to intersect the exception raised in tcom package. A new ticket has being created (#965) to implement ReadRange based on ExcelBasic.

Note: See TracTickets for help on using tickets.