2,722
社区成员
发帖
与我相关
我的任务
分享
lnRows=ExeclSheet.UsedRange.Rows.Count && 有数据的总行数
For rowNum=2 To lnRows
material_name=Allt(ExeclSheet.cells(rowNum, 1).Value)
?material_name
* WAIT "EXCEL数据处理中," + material_name+"..." WINDOW AT 689,2 NOWAIT
If Len( material_name)>0
*!* tmp=ExeclSheet.cells(rowNum, 2).value
*!* if type("tmp")=='N'
*!* vendor=allt(str(tmp))
*!* else
*!* vendor=allt(tmp)
*!* endif
*!* f_num1=ExeclSheet.cells(rowNum, 3).value
*!* f_num2=ExeclSheet.cells(rowNum, 4).value
*!* f_num3=ExeclSheet.cells(rowNum, 5).value
*!* f_char1=ExeclSheet.cells(rowNum, 6).value
*!* currency=ExeclSheet.cells(rowNum, 7).value
*!* cost=ExeclSheet.cells(rowNum, 8).value
*!* effectivedate=ExeclSheet.cells(rowNum, 9).value
*!*
*!* insert into (thisform.tblPrice) values(rowNum,material_name,vendor,f_num1,f_num2,f_num3,f_char1,currency, cost,effectivedate)
Endif
Endfor
lcFileName='c:\cost1.xls'
oExcel=Createobject('Excel.application')
oExcel.Workbooks.Open('&lcFileName') &&打开文件
For lnI=1 To 10
?Alltrim(oExcel.ActiveSheet.Cells(lnI,1).Value)
Endfor
oExcel.ActiveWorkbook.saved=.T. &&不保存当前EXCEL表
oExcel.Workbooks.Close &&关闭表
oExcel.Quit &&退出EXCEL
Release oExcel &&释放变量
Messagebox('OK!',64,'信息提示')