unit Unit1;
interface
uses
Printers,Windows, Messages, SysUtils, Variants, Classes,
Graphics, Controls, Forms,
Dialogs, ExcelXP, OleServer, StdCtrls, Grids,
Mask, RzEdit,frxDesgn,
frxClass, frxExportRTF, frxDBSet, frxExportPDF;
type papgxy=record
l,t,r,b:Extended;
end;
type bktype =record // 边框
line:boolean;
color:integer;
width:Extended;
end;
type txttpye =record
text:string;
fontcolor, fontSize:integer;
FontBold,FontItalic:boolean;
thi,tvi:integer;//文字排列位置
fontstyle, fontname:string;
fontun,fontstr:boolean;
bcolor:integer;
end;
type cell= record
t,L,h,w :Extended ;
row,col,row2:integer;
txt:txttpye;
leftb,topb,Bottomb,Rightb:bktype;// 边框
k:integer;
end;
type
TForm1 = class(TForm)
Button1: TButton;
Button2: TButton;
Ea1: TExcelApplication;
Es1: TExcelWorksheet;
fr1: TfrxReport;
Memo1: TMemo;
Button4: TButton;
Button5: TButton;
Ed2: TEdit;
Ed1: TEdit;
Od1: TOpenDialog;
sd1: TSaveDialog;
Button6: TButton;
ed3: TEdit;
Button7: TButton;
Button8: TButton;
Cs1: TComboBox;
Button9: TButton;
fd3: TfrxDBDataset;
fd2: TfrxDBDataset;
fd1: TfrxDBDataset;
Button3: TButton;
frxPDFExport1: TfrxPDFExport;
procedure FormCreate(Sender: TObject);
procedure Button4Click(Sender: TObject);
procedure Button5Click(Sender: TObject);
procedure Button8Click(Sender: TObject);
procedure Button9Click(Sender: TObject);
procedure FormClose(Sender: TObject; var Action: TCloseAction);
procedure Button7Click(Sender: TObject);
procedure Button2Click(Sender: TObject);
procedure Button1Click(Sender: TObject);
procedure Button3Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var Form1: TForm1;
implementation
{$R *.dfm}
function color_i(i:integer):tcolor; //颜色转换
var c1: tcolor;
begin
case i of
1 : c1:=$000000;
2 : c1:=$FFFFFF;
3 : c1:=$0000FF;
4 : c1:=$00FF00;
5 : c1:=$FF0000;
6 : c1:=$00FFFF;
7 : c1:=$FF00FF;
8 : c1:=$FFFF00;
9 : c1:=$000080;
10 : c1:=$008000;
11 : c1:=$800000;
12 : c1:=$008080;
13 : c1:=$800080;
14 : c1:=$808000;
15 : c1:=$C0C0C0;
16 : c1:=$808080;
17 : c1:=$FF9999;
18 : c1:=$663399;
19 : c1:=$CCFFFF;
20 : c1:=$FFFFCC;
21 : c1:=$660066;
22 : c1:=$8080FF;
23 : c1:=$CC6600;
24 : c1:=$FFCCCC;
25 : c1:=$800000;
26 : c1:=$FF00FF;
27 : c1:=$00FFFF;
28 : c1:=$FFFF00;
29 : c1:=$800080;
30 : c1:=$000080;
31 : c1:=$808000;
32 : c1:=$FF0000;
33 : c1:=$FFCC00;
34 : c1:=$FFFFCC;
35 : c1:=$CCFFCC;
36 : c1:=$99FFFF;
37 : c1:=$FFCC99;
38 : c1:=$CC99FF;
39 : c1:=$FF99CC;
40 : c1:=$99CCFF;
41 : c1:=$FF6633;
42 : c1:=$CCCC33;
43 : c1:=$00CC99;
44 : c1:=$00CCFF;
45 : c1:=$0099FF;
46 : c1:=$0066FF;
47 : c1:=$996666;
48 : c1:=$969696;
49 : c1:=$663300;
50 : c1:=$669933;
51 : c1:=$003300;
52 : c1:=$003333;
53 : c1:=$003399;
54 : c1:=$663399;
55 : c1:=$993333;
56 : c1:=$333333;
end;
Result:=c1;
end;
function cd(i:Extended):Extended;
begin
Result:=1.34*i;
end;
procedure papg_set(PageSet:Variant;P:Tfrxreportpage);
var a:integer;
begin
p.LeftMargin :=PageSet.LeftMargin/2.8348;
p.TopMargin :=PageSet.topMargin/2.8348;
p.RightMargin :=PageSet.RightMargin/2.8348;
p.BottomMargin :=PageSet.BottomMargin/2.8348;
p.PrintOnPreviousPage:=True ; //合并打印
if PageSet.Orientation=2
then p.Orientation:=poLandscape
else p.Orientation:=poPortrait;
p.PaperSize:=PageSet.PaperSize;
{
if PageSet.PaperSize=xlPaperA3 then p.PaperSize:=DMPAPER_A3;
if PageSet.PaperSize=xlPaperA4 then p.PaperSize:=DMPAPER_A4;
if PageSet.PaperSize=xlPaperA5 then p.PaperSize:=DMPAPER_A5;
}
end;
function cell_du(row,col:integer;o1:integer;row2:integer):cell;
var mm:cell;
ms :boolean;
fontsyle1:string;
r2,c2:integer;
begin
with form1.Es1 do
begin
mm.txt.text :=Cells.Item[row,col]; // 内容
mm.t := Cells.Item[row,col].top; //顶
mm.l := cells.Item[row,col].left; //左
mm.k:=0;
r2:= Cells.Item[row,col].MergeArea.Rows.Count;
mm.row2 :=R2;
if (o1>=1) and (col>=1) then
mm.l:= cells.Item[row,col].left-cells.Item[row,2].left; //左
if (o1>=1) and (row>1)and (row>=row2) then
mm.t:= cells.Item[row,col].top-cells.Item[row2,1].top; //顶
ms:= cells.Item[row,col].MergeCells; //检查是否为 合并单位
if ms then
begin
r2:= Cells.Item[row,col].MergeArea.Rows.Count;
c2:= Cells.Item[row,col].MergeArea.Columns.Count;
mm.h := Cells.Item[row+r2,col].top-Cells.Item[row,col].top; //高度
mm.w := Cells.Item[row,col+c2].left-Cells.Item[row,col].left;//宽度
end else
begin
mm.h:= Cells.Item[row,col].height; //高度
mm.w:= Cells.Item[row,col].width; //宽度
end;
if o1=3 then
begin
mm.txt .FontBold := Cells.Item[row,col].font.Bold;
mm.txt .FontItalic:= Cells.Item[row,col].Font.Italic;
mm.txt .thi:=Cells.Item[row,col].HorizontalAlignment;
mm.txt .tvi:=Cells.Item[row,col].VerticalAlignment;
mm.txt.fontname := Cells.Item[row,col].font.name; // 字名称
mm.txt.fontSize := Cells.Item[row,col].font.Size; // 字大小
mm.txt.fontcolor:= Cells.Item[row,col].font.ColorIndex;// 字颜色
if mm.txt.fontcolor<=0 then mm.txt.fontcolor :=1;
//mm.fontstyle:= cells.Item[row,col].FontStyle; //字格式
mm.txt.bcolor:= Cells.Item[row,col].Interior.ColorIndex;// 底颜色
if mm.txt.bcolor<=0 then mm.txt.bcolor :=2;
//左1
If cells.Item[row,col].Borders[xlEdgeLeft].LineStyle = xlContinuous
Then mm.k := 1 ;
// 右2
If cells.Item[row,col].Borders[xlEdgeRight].LineStyle = xlContinuous
Then mm.k := mm.k + 2 ;
// 上4
If cells.Item[row,col].Borders[xlEdgeTop].LineStyle = xlContinuous
Then mm.k := mm.k + 4 ;
// '下8
If cells.Item[row,col].Borders[xlEdgeBottom].LineStyle = xlContinuous
Then mm.k := mm.k + 8 ;
end;
Result:=mm;
end;
end;
procedure txt_xie(j,i:integer;mm:cell);
var e:TfrxMemoView; //text
begin
e:= TfrxMemoView.Create(form1.fr1.Pages[1]);
e.Left:=cd(mm.L);
e.top:=cd(mm.t);
e.Height:=cd(mm.h);
e.Width :=cd(mm.w);
e.Name :='c'+ inttostr(j)+'r'+inttostr(i);
e.Text :=mm.txt.text;//+' * '+ e.Name ;
e.Font.Size :=mm.txt.fontSize ;
e.Font.Name :=mm.txt.fontname ;
e.Font.Color:= color_i(mm.txt.fontcolor);
e.Color := color_i(mm.txt.bcolor);
e.Frame.Typ:=[ftLeft,ftRight,ftTop,ftBottom];
end;
procedure pic2_xie(j,i:integer;mm:cell;pic:TfrxPictureView);
begin
pic.Left:=cd(mm.L);
pic.top:=cd(mm.t);
pic.Height:=cd(mm.h);
pic.Width :=cd(mm.w);
pic.Name :=pic.Parent.Name+inttostr(j)+'_'+inttostr(i);
//e.Text :=mm.txt.text ;//+' * '+ e.Name;
case mm.k of
1:pic.Frame.Typ :=[ftLeft ];
2:pic.Frame.Typ :=[ftRight ];
3:pic.Frame.Typ :=[ftLeft,ftRight ];
4:pic.Frame.Typ :=[ftTop ];
5:pic.Frame.Typ :=[ftLeft,ftTop ];
6:pic.Frame.Typ :=[ftRight,ftTop ];
7:pic.Frame.Typ :=[ftLeft,ftRight,ftTop ];
8:pic.Frame.Typ :=[ftBottom ];
9:pic.Frame.Typ :=[ftLeft,ftBottom ];
10:pic.Frame.Typ :=[ftRight,ftBottom ];
11:pic.Frame.Typ :=[ftLeft,ftRight,ftBottom
];
12:pic.Frame.Typ :=[ftTop,ftBottom ];
13:pic.Frame.Typ :=[ftLeft,ftTop,ftBottom
];
14:pic.Frame.Typ :=[ftRight,ftTop,ftBottom
];
15:pic.Frame.Typ :=[ftLeft,ftRight,ftTop,ftBottom];
else
pic.Frame.Typ :=[];
end;
end;
procedure txt2_xie(j,i:integer;mm:cell;e:TfrxMemoView);
begin
e.Left:=cd(mm.L);
e.top:=cd(mm.t);
e.Height:=cd(mm.h);
e.Width :=cd(mm.w);
e.Name :=E.Parent.Name+inttostr(j)+'_'+inttostr(i);
e.Text :=mm.txt.text ;//+' * '+ e.Name ;
e.Font.Size :=mm.txt.fontSize ;
e.Font.Name :=mm.txt.fontname ;
e.Font.Style :=[];
if mm.txt.FontBold
then e.Font.Style:= [fsBold];
if mm.txt.FontItalic
then e.Font.Style:=e.Font.Style + [fsItalic];
case mm.txt.tvi of //垂直排版
-4108:e.VAlign:=vaCenter;
-4107:e.VAlign:=vaBottom ;
else
e.VAlign:=vatop ;
end;
case mm.txt.thi of //水平排版
-4108:e.HAlign := haCenter;
-4152:e.HAlign := haRight;
1 :e.HAlign := haRight;
else
e.HAlign := haLeft;
end;
e.Font.Color:= color_i(mm.txt.fontcolor); //字颜色
e.Color := color_i(mm.txt.bcolor); //背景颜色
case mm.k of
1:e.Frame.Typ:=[ ftLeft];
2:e.Frame.Typ:=[ ftRight];
3:e.Frame.Typ:=[ ftLeft,ftRight];
4:e.Frame.Typ:=[ ftTop];
5:e.Frame.Typ:=[ ftLeft,ftTop];
6:e.Frame.Typ:=[ ftRight,ftTop];
7:e.Frame.Typ:=[ ftLeft,ftRight,ftTop];
8:e.Frame.Typ:=[ ftBottom];
9:e.Frame.Typ:=[ ftLeft,ftBottom];
10:e.Frame.Typ:=[ ftRight,ftBottom];
11:e.Frame.Typ:=[ ftLeft,ftRight,ftBottom];
12:e.Frame.Typ:=[ ftTop,ftBottom];
13:e.Frame.Typ:=[ ftLeft,ftTop,ftBottom];
14:e.Frame.Typ:=[ ftRight,ftTop,ftBottom];
15:e.Frame.Typ:=[ ftLeft,ftRight,ftTop,ftBottom];
else
e.Frame.Typ :=[];
end;
end;
procedure TForm1.FormCreate(Sender: TObject);
begin
ed1.Text :=ExtractFilePath(ParamStr(0))+'模板.xls';
ed2.text:=ExtractFilePath(ParamStr(0));
ed3.Text :='ont.fr3';
end;
procedure TForm1.Button4Click(Sender: TObject);
begin
if od1.Execute then
begin
ed1.Text := od1.FileName ;
Button8.Click ;
end;
end;
procedure TForm1.Button5Click(Sender: TObject);
begin
if sd1.Execute then
begin
ed2.Text:=ExtractFilePath(sd1.FileName) ;
if pos('.fr3',sd1.FileName)>0
then
ed3.Text :=ExtractFileName(sd1.FileName)
else
ed3.Text :=ExtractFileName(sd1.FileName)+'.fr3';
end;
end;
{ vba
XlPaperSize 可为下面 XlPaperSize 常量之中的一个。
xlPaper11x17. 11 in. x 17 in.
xlPaperA4. A4 (210 mm x 297 mm)
xlPaperA5. A5 (148 mm x 210 mm)
xlPaperB5. A5 (148 mm x 210 mm)
xlPaperDsheet. D size sheet
xlPaperEnvelope11. Envelope #11 (4-1/2 in. x 10-3/8 in.)
xlPaperEnvelope14. Envelope #14 (5 in. x 11-1/2 in.)
xlPaperEnvelopeB4. Envelope B4 (250 mm x 353 mm)
xlPaperEnvelopeB6. Envelope B6 (176 mm x 125 mm)
xlPaperEnvelopeC4. Envelope C4 (229 mm x 324 mm)
xlPaperEnvelopeC6. Envelope C6 (114 mm x 162 mm)
xlPaperEnvelopeDL. Envelope DL (110 mm x 220 mm)
xlPaperEnvelopeMonarch. Envelope Monarch (3-7/8 in. x 7-1/2 in.)
xlPaperEsheet. E size sheet
xlPaperFanfoldLegalGerman. German Legal Fanfold (8-1/2 in. x 13 in.)
xlPaperFanfoldUS. U.S. Standard Fanfold (14-7/8 in. x 11 in.)
xlPaperLedger. Ledger (17 in. x 11 in.)
xlPaperLetter. Letter (8-1/2 in. x 11 in.)
xlPaperNote. Note (8-1/2 in. x 11 in.)
xlPaperStatement. Statement (5-1/2 in. x 8-1/2 in.)
xlPaperUser. 用户自己定义
xlPaper10x14. 25.40 cm. x 35.56 cm.
xlPaperA3. A3 (297 mm x 420 mm)
xlPaperA4Small. A4 Small (210 mm x 297 mm)
xlPaperB4. B4 (250 mm x 354 mm)
xlPaperCsheet. C size sheet
xlPaperEnvelope10. Envelope #10 (4-1/8 in. x 9-1/2 in.)
xlPaperEnvelope12. Envelope #12 (4-1/2 in. x 11 in.)
xlPaperEnvelope9. Envelope #9 (3-7/8 in. x 8-7/8 in.)
xlPaperEnvelopeB5. Envelope B5 (176 mm x 250 mm)
xlPaperEnvelopeC3. Envelope C3 (324 mm x 458 mm)
xlPaperEnvelopeC5. Envelope C5 (162 mm x 229 mm)
xlPaperEnvelopeC65. Envelope C65 (114 mm x 229 mm)
xlPaperEnvelopeItaly. Envelope (110 mm x 230 mm)
xlPaperEnvelopePersonal. Envelope (3-5/8 in. x 6-1/2 in.)
xlPaperExecutive. Executive (7-1/2 in. x 10-1/2 in.)
xlPaperFanfoldStdGerman. German Legal Fanfold (8-1/2 in. x 13 in.)
xlPaperFolio. Folio (8-1/2 in. x 13 in.)
xlPaperLegal. Legal (8-1/2 in. x 14 in.)
xlPaperLetterSmall. Letter Small (8-1/2 in. x 11 in.)
xlPaperQuarto. Quarto (215 mm x 275 mm)
xlPaperTabloid. Tabloid (11 in. x 17 in.)
}
procedure TForm1.Button8Click(Sender: TObject);
var b,a:string;
i,j,k,n:integer;
begin
ea1.Connect;
ea1.Workbooks.Open(ed1.Text ,null,null,null,null,
null,null,null,null,null,null,null,null,null,null,0);
cs1.Items.Clear ;
k:=ea1.Workbooks[ExtractFileName(ed1.Text)].Sheets.Count;
for j:=1 to k do
begin
es1.ConnectTo(ea1.Workbooks[ExtractFileName(ed1.Text)].Worksheets[j] as ExcelWorksheet);
b:=es1.Name;
cs1.Items.Add(b);
end;
cs1.Text :=cs1.Items.Strings[0];
Button9.Enabled:=true;
end;
procedure TForm1.Button9Click(Sender: TObject);
var
PageSet:OLEVariant;
i,j,k :integer;
frtemp: TfrxReport;
mm1,mm:cell;
r11,c11,r1:integer;
row,col:integer;
e :TfrxMemoView; // text 文字框
pic:TfrxPictureView; // 图片框
pt:TfrxReportTitle;
pf:TfrxReportSummary;
ht:TfrxPageHeader;
hf:TfrxPageFooter;
md:TfrxMasterData;
Mxd:TfrxDetailData;
sd:TfrxSubdetailData;
P:Tfrxreportpage;
tempage:TfrxReportPage;
kk:integer;
Designer: TfrxDesignerForm;//
begin
frtemp:=TfrxReport.Create(form1);
// frtemp.DataSets.Add(fd1);
// frtemp.DataSets.Add(fd2);
// frtemp.DataSets.Add(fd3);
tempage:=TfrxReportPage.Create(frtemp);
tempage.NAME:='page1';
P:=Tfrxreportpage(tempage);
es1.ConnectTo(ea1.Workbooks
[ExtractFileName(ed1.Text)].Worksheets[cs1.text ] as ExcelWorksheet);
PAGESET:=ES1.PageSetup;
papg_set(PAGESET,p);
PAGESET:=UnAssigned;
col :=es1.UsedRange[1].Columns.Count ; //excel 的列
row :=es1.UsedRange[1].Rows.Count; //excel 的行
for k:=1 to row do
begin
r1:= es1.Cells.Item[k,1].MergeArea.Row;//s.Count;
if r1=k then
begin
mm:= cell_du(k,1,0,0);
if mm.txt.text ='表头'
then begin
pt:= TfrxReportTitle.Create(tempage);
pt.Height:=cd(mm.h);
pt.Name :='pt';//'ban'+inttostr(k);
for i:=k to k+mm.row2-1 do //行
for j:=2 to col do //列
begin
r11:= es1.Cells.Item[i,j].MergeArea.Row;//s.Count;
c11:= es1.Cells.Item[i,j].MergeArea.Column;//s.Count;
if (r11=I) and (c11=J) then
begin
mm1:= cell_du(i,j,3,k);
if mm1.txt.text='{[图片]}'
then begin
pic:= TfrxPictureView.Create(pt);
pic2_xie(i,j,mm1,pic);
end else
begin
e:= TfrxMemoView.Create(pt);
txt2_xie(i,j,mm1,e);
end;
end;
end;
end;
if mm.txt.text ='页头'
then begin
ht:= TfrxPageHeader.Create(tempage);
ht.Height:=cd(mm.h);
ht.Name :='HT';
for i:=k to k+mm.row2-1 do //行
for j:=2 to col do //列
begin
r11:= es1.Cells.Item[i,j].MergeArea.Row;//s.Count;
c11:= es1.Cells.Item[i,j].MergeArea.Column;//s.Count;
if (r11=I) and (c11=J) then
begin
mm1:= cell_du(i,j,3,k); //读 excel cell的文字
if mm1.txt.text='{[图片]}'
then begin
pic:= TfrxPictureView.Create(HT);
pic2_xie(i,j,mm1,pic);
end else
begin
e:= TfrxMemoView.Create(HT);
txt2_xie(i,j,mm1,e);
end;
// e:= TfrxMemoView.Create(HT);
// txt2_xie(i,j,mm1,e);
end;
end;
end;
if mm.txt.text ='页脚'
then begin
hf:=TfrxPageFooter.Create(tempage);
hf.Height:=cd(mm.h);
hf.Name :='HF';
for i:=k to k+mm.row2-1 do //行
for j:=2 to col do //列
begin
r11:= es1.Cells.Item[i,j].MergeArea.Row;//s.Count;
c11:= es1.Cells.Item[i,j].MergeArea.Column;//s.Count;
if (r11=I) and (c11=J) then
begin
mm1:= cell_du(i,j,3,k);
if mm1.txt.text='{[图片]}'
then begin
pic:= TfrxPictureView.Create(HF);
pic2_xie(i,j,mm1,pic);
end else
begin
e:= TfrxMemoView.Create(HF);
txt2_xie(i,j,mm1,e);
end;
//e:= TfrxMemoView.Create(HF);
//txt2_xie(i,j,mm1,e);
end;
end;
end;
TRY
if mm.txt.text ='主数据'
then begin
md:=TfrxMasterData.Create(tempage);
md.Height:=cd(mm.h);
frtemp.DataSets.Add(fd1);
md.Name :='MD';
md.DataSet:=fd1;
MD.TOP:=MM.T;
//md.DataSetName :='mda';
memo1.Lines.Text := tempage.DataSetName;
//.DataSet.
for i:=k to k+mm.row2-1 do //行
for j:=2 to col do //列
begin
r11:= es1.Cells.Item[i,j].MergeArea.Row;//s.Count;
c11:= es1.Cells.Item[i,j].MergeArea.Column;//s.Count;
if (r11=I) and (c11=J) then
begin
mm1:= cell_du(i,j,3,k);
if mm1.txt.text='{[图片]}'
then begin
pic:= TfrxPictureView.Create(MD);
pic2_xie(i,j,mm1,pic);
end else
begin
e:= TfrxMemoView.Create(MD);
txt2_xie(i,j,mm1,e);
end;
// e:= TfrxMemoView.Create(MD);
//txt2_xie(i,j,mm1,e);
end;
end;
end;
if mm.txt.text ='明细数据'
then begin
Mxd:=TfrxDetailData.Create(tempage);
Mxd.Height:=cd(mm.h);
Mxd.Name :='MXD';
frtemp.DataSets.Add(fd2);
MXD.TOP:=MM.T;
mxd.DataSet:=fd2;
for i:=k to k+mm.row2-1 do //行
for j:=2 to col do //列
begin
r11:= es1.Cells.Item[i,j].MergeArea.Row;//s.Count;
c11:= es1.Cells.Item[i,j].MergeArea.Column;//s.Count;
if (r11=I) and (c11=J) then
begin
mm1:= cell_du(i,j,3,k);
if mm1.txt.text='{[图片]}'
then begin
pic:= TfrxPictureView.Create(MXD);
pic2_xie(i,j,mm1,pic);
end else
begin
e:= TfrxMemoView.Create(MXD);
txt2_xie(i,j,mm1,e);
end;
// e:= TfrxMemoView.Create(MXD);
// txt2_xie(i,j,mm1,e);
end;
end;
end;
if mm.txt.text ='子数据'
then begin
sd:=TfrxSubdetailData.Create(tempage);
sd.Height:=cd(mm.h);
sd.Name :='SD';
frtemp.DataSets.Add(fd3);
sd.DataSet:=fd3;
SD.TOP:=MM.T;
for i:=k to k+mm.row2-1 do //行
for j:=2 to col do //列
begin
r11:= es1.Cells.Item[i,j].MergeArea.Row;//s.Count;
c11:= es1.Cells.Item[i,j].MergeArea.Column;//s.Count;
if (r11=I) and (c11=J) then
begin
mm1:= cell_du(i,j,3,k);
if mm1.txt.text='{[图片]}'
then
begin
pic:= TfrxPictureView.Create(SD);
pic2_xie(i,j,mm1,pic);
end
else
begin
e:= TfrxMemoView.Create(SD);
txt2_xie(i,j,mm1,e);
end;
//e:= TfrxMemoView.Create(SD);
//txt2_xie(i,j,mm1,e);
end;
end;
end;
if mm.txt.text ='表合计' then
begin
pf:=TfrxReportSummary.Create(tempage);
pf.Height:=cd(mm.h);
pf.Name :='PF';
for i:=k to k+mm.row2-1 do //行
for j:=2 to col do //列
begin
r11:= es1.Cells.Item[i,j].MergeArea.Row;//s.Count;
c11:= es1.Cells.Item[i,j].MergeArea.Column;//s.Count;
if (r11=I) and (c11=J) then
begin
mm1:= cell_du(i,j,3,k);
if mm1.txt.text='{[图片]}'
then begin
pic:= TfrxPictureView.Create(PF);
pic2_xie(i,j,mm1,pic);
end else
begin
e:= TfrxMemoView.Create(PF);
txt2_xie(i,j,mm1,e);
end;
//e:= TfrxMemoView.Create(pF);
//txt2_xie(i,j,mm1,e);
end;
end;
end;
except
SHOWMESSAGE('错误出如今 K='+INTTOSTR(K)+' I='+INTTOSTR(I)+ ' JC='+INTTOSTR(I) )
END;
end;
end;
// frtemp.SetProperty()
//.setpr
frtemp.DesignReport();
frtemp.SaveToFile(ed2.Text +ed3.Text);
frtemp.Free;
fr1.LoadFromFile(ed2.Text +ed3.Text);
//fr1.DesignPreviewPage;
end;
{
ver:
aaaa:OLEVariant
ExcelApp.activeworkbook.close;
ExcelApp.Quit;
ExcelApp:=UnAssigned;
}
procedure TForm1.FormClose(Sender: TObject; var Action: TCloseAction);
begin
es1.Disconnect;
ea1.Quit ;
ea1.Disconnect ;
end;
procedure TForm1.Button7Click(Sender: TObject);
var i:Integer;
begin
fr1.DesignReport();
end;
procedure TForm1.Button2Click(Sender: TObject); //连续打印2个报表
begin
// fr1.LoadFromFile(ed2.Text +ed3.Text);
fr1.LoadFromFile('D:\excel\新建目录 (2)\1.fr3');
fr1.PrepareReport(True );
fr1.LoadFromFile('D:\excel\新建目录 (2)\3.fr3');
fr1.PrepareReport(False );
fr1.ShowPreparedReport ;
end;
procedure TForm1.Button1Click(Sender: TObject);
begin
fr1.ShowReport(True );
end;
procedure TForm1.Button3Click(Sender: TObject);
var i:Integer ;
p : TfrxReportPage;
begin //3个报表连续 合并
fr1.LoadFromFile('D:\excel\新建目录 (2)\4.fr3');
fr1.PrepareReport(True);
fr1.LoadFromFile('D:\excel\新建目录 (2)\1.fr3');
fr1.PrepareReport(false);
p := TfrxReportPage(fr1.Objects[1]);
p.PrintOnPreviousPage :=True;
fr1.DesignReport();
fr1.LoadFromFile('D:\excel\新建目录 (2)\3.fr3');
fr1.PrepareReport(False);
p := TfrxReportPage(fr1.Objects[1]);
p.PrintOnPreviousPage :=True;
fr1.DesignReport();
{ i:= fr1.PreviewPages.Count;
ShowMessage(IntToStr(i));
fr1.PreviewPages.Page[0].PrintOnPreviousPage:=True;
}
fr1.DesignReport();
p := TfrxReportPage(fr1.Objects[1]);
p.PrintOnPreviousPage :=True;
p := TfrxReportPage(fr1.Objects[1]);
p.PrintOnPreviousPage :=True;
fr1.ShowPreparedReport ;
end;
end.
