给你点代码,自己看吧!!
var
MyExcel, WorkBook, Sheet: OleVariant;
Row,Cow,i:integer;
begin
//create excel object
MyExcel := CreateOleObject('Excel.Application');
Excel.Visible := Visible ;
WorkBook := Excel.Workbooks.Add ;
Sheet:= WorkBook.Sheets[1];
//control the cells
DataSet.First;
while Not DataSet.Eof do
begin
Row:=Row+1;
Col:=1;
for i:=0 to DataSet.FieldCount-1 do
begin
Sheet.Cells(Row,Col):=DataSet.Fields[i].AsString;
Inc(Col);
end;
DataSet.Next;
end;
//你可不要照抄啊,大意如此,呵呵,拿大家都会的骗点分*_@
var
MyExcel, WorkBook, Sheet: OleVariant;
Row,Cow,i:integer;
begin
//create excel object
MyExcel := CreateOleObject('Excel.Application');
Excel.Visible := Visible ;
WorkBook := Excel.Workbooks.Add ;
Sheet:= WorkBook.Sheets[1];
//control the cells
DataSet.First;
while Not DataSet.Eof do
begin
Row:=Row+1;
Col:=1;
for i:=0 to DataSet.FieldCount-1 do
begin
Sheet.Cells(Row,Col):=DataSet.Fields[i].AsString;
Inc(Col);
end;
DataSet.Next;
end;
//你可不要照抄啊,大意如此,呵呵,拿大家都会的骗点分*_@
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货