![]() |
Delphi de Excel e veri aktarımı
procedure TOGRENCILISTESI.BitBtn3Click(Sender: TObject);
var aralik:ExcelRange; I,satir:integer; bookmark:TBookmarkStr; begin //Excel Uygulaması oluşturma ExcelApplication1.Visible[0]:=true; ExcelApplication1.Workbooks.Add(null,0); //Hücreleri doldur aralik:=ExcelApplication1.ActiveCell; for I:=0 to Table1.Fields.Count-1 do begin aralik.Value2:=Table1.Fields[i].DisplayLabel; aralik:=aralik.Next; end; //Alanları Satırlara ekle try bookmark:=Table1.Bookmark; try Table1.First; satir:=3; //3.satırdan itibaren while not Table1.Eof do begin aralik:=ExcelApplication1.Range['A'+IntToStr(satir),'A'+Inttostr(satir)]; for I:=0 to table1.Fields.Count-1 do begin aralik.Value2:=table1.Fields[i].AsString; aralik:=aralik.Next; end; table1.Next; Inc(satir); end; finally table1.Bookmark:=bookmark; end; finally end; end; |
Tüm Zamanlar GMT +3 Olarak Ayarlanmış. Şuanki Zaman: 12:57. |
Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.