while not df.adoquery1.eof do //赋明细值
begin
inc(i);
for j:=2 to df.adoquery1.fieldcount-2 do
worksheet.cells[i,j]:=df.adoquery1.fields[j+1].asstring;
df.adoquery1.next;
lastline:=i+1; //获得累计的行号
end ;
worksheet.cells(lastline,2):='累计';
df.ADOQuery2.Close;
df.ADOQuery2.SQL.Clear;
df.ADOQuery2.SQL.Add(Query2Str);
df.ADOQuery2.Open;
df.adoquery2.first;
for j:=0 to df.adoquery2.fieldcount-1 do //赋累计值
begin
worksheet.cells[lastline,j+4]:=df.adoquery2.fields[j].asstring;
df.adoquery2.next;
end;
tt1:='h'+inttostr(lastline); //画表
tt2:='h'+inttostr(lastline+1);
worksheet.Range[ 'a2',tt1 ].Borders[2].Weight :=2;
worksheet.Range[ 'b2',tt2 ].Borders[3].Weight :=2;
lastline:=lastline+1; //确定制表人的行号
worksheet.cells(lastline,6):='制表人:';
worksheet.cells(lastline,7):=NameLinkStr;
end;