CurcunaForum.Org

CurcunaForum.Org (https://www.curcunaforum.org/)
-   Delphi , Visual basic , C , C++ (https://www.curcunaforum.org/delphi-visual-basic-c-c/)
-   -   Delphi de Excel e veri aktarımı (https://www.curcunaforum.org/delphi-visual-basic-c-c/50198-delphi-de-excel-e-veri-aktarimi.html)

FİЯАЯi 10-28-2007 09:57

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.