如何实现在Excel中打印报表.
解决方案 »
- AlphaControls,怎样实现定时改变皮肤
- 关于adoquery.next的问题,
- sql的image字段的图片如何修改
- TSQLConnection连接interbase的速度由那些属性决定?
- 我想做一个reallink软件的好友消息群发,请问如何下手啊?
- Expected '=' but '(' found 是什么错误?急,在线等!
- activeform生成ocx后的注册问题
- 帮忙看看这段代码?多谢了,
- 怎么将Treeview某个节点及其下的所有子节点复制到另外一棵树上呢?
- 难道真的没人知道吗???难道真的没人知道吗???难道真的没人知道吗???难道真的没人知道吗???难道真的没人知道吗???
- 专科生不能做程序员?
- 发送WM_NEXTDLGCTL可以使焦点由Edit控件自动按Taborder跳到下一个Edit控件,如果跳上去呢??
把EXCEL调动后,与程序脱离关系.
var
aSheet:Variant;
i,j:integer;
begin
if not CarQuery.Active then exit;
//显示Ms-excel的执行过程
ExcelApplication1.Visible[0]:=True;
ExcelApplication1.WorkBooks.Add(xlWBATWorksheet,1);
aSheet:=ExcelApplication1.Worksheets.Item[1]; with CarQuery do
begin
first;
for i := 0 to FieldCount - 1 do
aSheet.Cells[2,i+1].Value := Fields.Fields[i].DisplayLabel; for i := 0 to RecordCount-1 do
begin
for j := 0 to FieldCount - 1 do
aSheet.Cells[i+3,j+1].value :=Fields.Fields[j].AsString;
next;
end;
end;
end;
excelapplication1.Caption:='123';
//excelapplication1.Visible[0]:=true;
excelapplication1.Workbooks.Add(null,0);
excelworkbook1.ConnectTo(excelapplication1.Workbooks[1]);
excelworksheet1.ConnectTo(excelworkbook1.Worksheets[1] as _worksheet);
excelworksheet1.Name:='zwtlzr1';
excelworksheet1.Activate;
excelworksheet1.PageSetup.PrintGridlines:=true;
excelworksheet1.PageSetup.PaperSize:=XLPAPERA4;
excelworksheet1.PageSetup.CenterFooter:='第&P页共&N页';
excelworksheet1.PageSetup.PrintTitleRows:='$1:$3';
excelworksheet1.PageSetup.Orientation:=XLLANDSCAPE;
celworksheet1.Cells.item[2,2].font.Name:='黑体';
excelworksheet1.Cells.item[2,2].font.Size:=10;
excelworksheet1.Cells.Item[2,2].HorizontalAlignment := xlCenter;
标题: 粗体,居中,底色为灰色.