delphi FireDAC TFDDataMove 导出csv
var
fld: TField;
lst: TStringList;
wasActive: Boolean;
writer: TTextWriter;
begin
writer := TStreamWriter.Create(FileName);
try
lst := TStringList.Create;
try
lst.QuoteChar := '"';
lst.Delimiter := ';';
wasActive := DataSet.Active;
try
DataSet.Active := true;
DataSet.GetFieldNames(lst);
writer.WriteLine(lst.DelimitedText);
DataSet.First;
while not DataSet.Eof do begin
lst.Clear;
for fld in DataSet.Fields do
lst.Add(fld.Text);
writer.WriteLine(lst.DelimitedText);
DataSet.Next;
end;
finally
DataSet.Active := wasActive;
end;
finally
lst.Free;
end;
finally
writer.Free;
end;
end;
推荐分享
图文皆来源于网络，内容仅做公益性分享，版权归原作者所有，如有侵权请告知删除！
Copyright © 2014 DelphiW.com 开发 源码 文档 技巧 All Rights Reserved
晋ICP备14006235号-8 晋公网安备 14108102000087号
执行时间: 0.044242858886719 seconds