procedure TFrmQryO3ByTime.BitBtn3Click(Sender: TObject);
Var
MyExcel,myworkbook,mysheet,myrange,myrange1,myrange2:variant;
Str,strRow,strYear,strMon,strDay:string;
Arow,Acol,Num,i:integer;
begin
{Initialize the tile of the cexcel table}
{Create new Excel Application}
ADOQryYearO3.First;
For i := 1 To ADOQryYearO3.RecordCount do begin
MySheet.Cells[i+1,1]:= ADOQryYearO3.FieldByName('站点编号').AsString;
MySheet.Cells[i+1,2]:= ADOQryYearO3.FieldByName('日期').AsString;
MySheet.Cells[i+1,3]:= ADOQryYearO3.FieldByName('小时').AsString;
MySheet.Cells[i+1,4]:= ADOQryYearO3.FieldByName('ccc').AsString;
ADOQryYearO3.next;
end;
var
i: Integer;
s: String;
slTmp: TStrings;
begin
//你自己的查询
ADOQuery1.Open;
slTmp := TStringList.Create;
try
ADOQuery1.First;
while not ADOQuery1.Eof do
begin
s := '';
for i:=0 to ADOQuery1.FieldCount-1 do
s := s + ADOQuery1.Fields[i].AsString + ',';
s := Copy(s, 0, Length(s)-1);
slTmp.Add(s);