读书人

使用“EHlib”导出数据(下面有段代

发布时间: 2012-05-20 16:03:12 作者: rapoo

使用“EHlib”导出数据,(下面有段代码,请达人帮我使用Ehlib导出数据)
-----------------------------------------------
unit Unit1;

interface

uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, DB, ADODB, Grids, DBGridEh, StdCtrls;

type
TForm1 = class(TForm)
DBGridEh1: TDBGridEh;
ADOConnection1: TADOConnection;
ADOQuery1: TADOQuery;
DataSource1: TDataSource;
Button1: TButton;
procedure Button1Click(Sender: TObject);


private
{ Private declarations }
public
{ Public declarations }
end;

var
Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
begin
close;
end;

end.


---------------------------------------

[解决办法]
引用DBGridEhImpExp单元
然后
procedure TFrmQuery.BtnExportClick(Sender: TObject);
var
exp: TDBGridEhExportAsXLS;
begin
if dlgSave1.Execute then
begin
try
exp:=TDBGridEhExportAsXLS.Create;
exp.DBGridEh:=DBGridEh1;
exp.ExportToFile(dlgSave1.FileName,True);
finally
exp.Free;
end;
end;
end;
[解决办法]
uses DBGridEhImpExp {引用此单元}

procedure TForm1.Button1Click(Sender: TObject);
var
ExpClass:TDBGridEhExportClass;
begin
{ SaveDialog1.Filter:='Excel文件 (*.xls)|*.xls';
SaveDialog1.DefaultExt:='xls'; [del][/del] }
if SaveDialog1.Execute then
begin
ExpClass:=TDBGridEhExportAsXLS;
SaveDBGridEhToExportFile(ExpClass,dbgrideh1,SaveDialog1.FileName,true); {TRUE表示保存DBgrideh显示的所有记录,FALSE仅保存选择的记录}
end;
end;

读书人网 >.NET

热点推荐