David,
I tried the example that you sent as:
m_xlsfile = getfile('xls')
oExcel = createobject( "excel.application" )
oExcel.Visible = .t.
oWorkbook = oExcel.Workbooks
oWorkbook.Open( m_xlsfile )
oSheet = oExcel.ActiveSheet
for each oRow in oSheet.Rows
?? '.'
with oRow
for each oCol in oRow.Cloumns
? oCol.Value
endwith
endwith
endfor
oWorkbook.Close()
oExcel.Quit()
I get a nesting error on the row
for each oRow in oRow.columns
It dows open Excel and show the data
Am I missing something obvious?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only