注册 登录
编程论坛 Delphi论坛

[求助]如何导出多表头

kitty0261 发布于 2006-11-08 11:21, 675 次点击
用delphi 导出excel 时,在控件GBDridEh 中连接的表是多表头的,请问如何导出多表头呢?!

请指教!!!
1 回复
#2
形影随从2006-11-13 10:35
procedure TForm1.Button1Click(Sender: TObject);
var
i: integer;
begin
OraQuery1.Close;
OraQuery1.SQL.Clear;
OraQuery1.SQL.Add('select a.isn, a.mo, b.item, b.itemnm from isn a, item b where a.item=b.item and a.isn=''MACHAEL20Y''');
OraQuery1.Open;
for i := 0 to DBGrid1.FieldCount - 1 do
begin
memo1.Lines.Add(DBGrid1.Fields[i].FieldName); //這可改成你導出EXCEL格式
end;
end;
1