我用以下代码实现将数据导出到excel文件中的,在xp下没问题,但是在98下系统提示“interface not support” or "类没有注册",怎么回事啊?急! ****************************************************************** var i,j,row:integer; begin if SaveDialog1.Execute then begin ExcelApplication1.Connect ExcelApplication1.Workbooks.Add(Null,0); ExcelWorkBook1.ConnectTo(ExcelApplication1.Workbooks[1]); ExcelWorkSheet1.ConnectTo(ExcelWorkBook1.Sheets[1] as _WorkSheet); if not Query1.Active then begin QUERY1.Open; end; for i:=0 to QUERY1.Fields.Count-1 do begin ExcelWorkSheet1.Cells.Item[1,i+1]:=dbgrid1.Columns.Items[i].Title.Caption; row:=2; query1.First; while not QUERY1.Eof do begin for j:=0 to QUERY1.Fields.Count-1 do begin ExcelWorkSheet1.Cells.Item[row,j+1]:=QUERY1.Fields[j].AsString; end; row:=row+1; QUERY1.Next; end; end; ExcelWorkBook1.SaveCopyAs(SaveDialog1.FileName); ExcelWorkBook1.Close(false); ExcelApplication1.Disconnect; ExcelApplication1.Quit; Screen.Cursor:=crDefault; Application.MessageBox('成功导出所有数据!','提示',0); end; end;
procedure Tfmprorep.Button5Click(Sender: TObject); var i,j,row:integer; begin if SaveDialog1.Execute then begin ExcelApplication1.Connect ExcelApplication1.Workbooks.Add(Null,0); ExcelWorkBook1.ConnectTo(ExcelApplication1.Workbooks[1]); ExcelWorkSheet1.ConnectTo(ExcelWorkBook1.Sheets[1] as _WorkSheet); if not Query1.Active then begin QUERY1.Open; end; for i:=0 to QUERY1.Fields.Count-1 do begin ExcelWorkSheet1.Cells.Item[1,i+1]:=dbgrid1.Columns.Items[i].Title.Caption; row:=2; query1.First; while not QUERY1.Eof do begin for j:=0 to QUERY1.Fields.Count-1 do begin ExcelWorkSheet1.Cells.Item[row,j+1]:=QUERY1.Fields[j].AsString; end; row:=row+1; QUERY1.Next; end; end; ExcelWorkBook1.SaveCopyAs(SaveDialog1.FileName); ExcelWorkBook1.Close(false); ExcelApplication1.Disconnect; ExcelApplication1.Quit; Screen.Cursor:=crDefault; Application.MessageBox('成功导出所有数据!','提示',0); end; end;
----------------------------------------------
-