Use COM. Here is some barely tested code ...
// Open Excel via OLE
oExcel is object OLE dynamic
oExcel = new object OLE "Excel.Application"
oExcel>>Visible = OLEFalse
// open the workbook
l_sXLSFile is string = "I:\MyDocs\TheXLSFile.xls"
oExcel>>Workbooks>>Open(l_sXLSFile)
//The CONSTANT con_xlLastCell = 11
oExcel>>ActiveCell>>SpecialCells(con_xlLastCell)>>Select
Info(oExcel>>ActiveCell>>Row)
oExcel>>ActiveWorkbook>>Close
oExcel>>Application>>Quit
David Martin
Ivy League Software LLC
Edited 2 time(s). Last edit at 11/21/2008 01:56PM by David Martin.