rt
解决方案 »
- Delphi7 FTP上传问题???
- 怎么tringgrid中导入access数据
- 救救我啊。。。关于Delphi邮件群发的问题。。。速度快死了我。。
- 如何指定多网卡机器中的其中一块网卡,又如何获取指定网卡的IP地址
- 需要一个截取活动窗口标题的Delphi空间
- 新手学delphi!请教
- Google为什么变成了服务器错误,页面可以访问但是无法查询
- 请问在ActiveX的Form中自己设置对外的属性和方法需要什么样的步骤?
- 这两条try语句有什么区别 try...finally...except 和 try...except...finally
- 如在的delphi中gride中加入CheckBox,RadioButton,下拉菜单,等等就象pb那样?
- 求教listbox 的删除方法
- 怎么样禁止输入重复记录呢?
1) 显示当前窗口:
ExcelApp.Visible := True;2) 更改 Excel 标题栏:
ExcelApp.Caption := '应用程序调用 Microsoft Excel';3) 添加新工作簿:
ExcelApp.WorkBooks.Add;4) 打开已存在的工作簿:
ExcelApp.WorkBooks.Open( 'C:\Excel\Demo.xls' );5) 工作表保存:
if not ExcelApp.ActiveWorkBook.Saved then
ExcelApp.ActiveSheet.PrintPreview;6) 关闭工作簿:
ExcelApp.WorkBooks.Close;
begin
excel := UnAssigned;
sheet := UnAssigned;
workBook := UnAssigned; curRow := 1; if reportName <> '' then
strReportName := reportName //strReportName 为全局变量
else
strReportName := '未命名';
end;
var
ExcelApplication2: TExcelApplication;
ExcelWorksheet2: TExcelWorksheet;
ExcelWorkbook2: TExcelWorkbook;
i, j: integer;
filename: string;
begin
filename := sName;// 要保存的文件名称
try
ExcelApplication2 := TExcelApplication.Create(Application);
ExcelWorksheet2 := TExcelWorksheet.Create(Application);
ExcelWorkbook2 := TExcelWorkbook.Create(Application);
ExcelApplication2.Connect;
except
Application.Messagebox('Excel 没有安装!', '警告', MB_ICONERROR + mb_Ok);
Abort;
end;
try
ExcelApplication2.Workbooks.Add(EmptyParam, 0);
ExcelWorkbook2.ConnectTo(ExcelApplication2.Workbooks[1]);
ExcelWorksheet2.ConnectTo(ExcelWorkbook2.Worksheets[1] as _worksheet);
AdsData.Close;
AdsData.Open;//
AdsData.First;
for j := 0 to AdsData.Fields.Count - 1 do
begin
ExcelWorksheet2.Cells.item[1,j+1]:=AdsData.Fields[j].DisplayLabel;
ExcelWorksheet2.Cells.item[1,j+1].font.size := '10';
end;
i:=0;
while not AdsData.Eof do
begin
for j := 0 to AdsData.Fields.Count- 1 do
begin
ExcelWorksheet2.Cells.item[i+2,j+1]:=AdsData.Fields[j].Asstring;
ExcelWorksheet2.Cells.item[i+2, j + 1].font.size :=10;
end;
AdsData.Next;
i:=i+1;
end;
ExcelWorksheet2.Columns.AutoFit;
//ExcelWorksheet2.Cells.item[1, 2] := Title;
//ExcelWorksheet2.Cells.Item[1, 2].font.size := 14;
ExcelWorksheet2.SaveAs(filename);
Application.Messagebox(pchar('数据成功导出!'), '提示', mb_Ok);
finally
ExcelApplication2.Disconnect;
ExcelApplication2.Quit;
ExcelApplication2.Free;
ExcelWorksheet2.Free;
ExcelWorkbook2.Free;
end;
flag:=1;
end;