IF li_FileNum <> 1 THEN
messagebox("选择文件","请选择表!")
return 0
end if
if pos(upper(filename),'XLS') > 0 then
SetPointer(hourglass!)
ole_excel = CREATE oleobject
if ole_excel.ConnectToObject(pathname) = 0 THEN // 连接OLE
以下代码写在行和列的循环里:
if not IsNull(ole_excel.Application.workbooks(1).worksheets(1).cells(ll_i,1).Value) THEN
ls_s=ole_excel.Application.workbooks(1).worksheets(1).cells(ll_i,1).Value
此处也可用下面两句获取单元格的值:
ole_excel.Application.workbooks(1).worksheets(1).cells(ll_i,ll_j).Copy()
ls_temp = Clipboard()
end if
end if