代码如下:var
oBoolean:OleVariant;
begin
try
ExcelApplication1.Connect;
except
Application.Messagebox('计算机中没有安装Excel,不能打开模板文件!','提示',MB_OK+MB_ICONEXCLAMATION);
Exit;
end; try
oBoolean:=True;
rFile:='kkk.xlt';
Excelworkbook1.ConnectTo(ExcelApplication1.Workbooks.Open(rFile,EmptyParam,oBoolean,EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,0));
ExcelWorksheet1.ConnectTo(Excelworkbook1.ActiveSheet as _worksheet);
ExcelApplication1.Visible[0]:=true;
finally
oBoolean:=Unassigned;
ExcelWorkbook1.Disconnect;
ExcelWorksheet1.Disconnect;
ExcelApplication1.Disconnect;
end;
end; 我就想打开只读的模板文件显示即可,在标题显示“[只读]”,可Excel却以这个模板给我新建了一个xls实例文档,给人的感觉是根本没打开ddd.xlt,怎么办呀?
oBoolean:OleVariant;
begin
try
ExcelApplication1.Connect;
except
Application.Messagebox('计算机中没有安装Excel,不能打开模板文件!','提示',MB_OK+MB_ICONEXCLAMATION);
Exit;
end; try
oBoolean:=True;
rFile:='kkk.xlt';
Excelworkbook1.ConnectTo(ExcelApplication1.Workbooks.Open(rFile,EmptyParam,oBoolean,EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,0));
ExcelWorksheet1.ConnectTo(Excelworkbook1.ActiveSheet as _worksheet);
ExcelApplication1.Visible[0]:=true;
finally
oBoolean:=Unassigned;
ExcelWorkbook1.Disconnect;
ExcelWorksheet1.Disconnect;
ExcelApplication1.Disconnect;
end;
end; 我就想打开只读的模板文件显示即可,在标题显示“[只读]”,可Excel却以这个模板给我新建了一个xls实例文档,给人的感觉是根本没打开ddd.xlt,怎么办呀?
解决方案 »
- 窗体中用WebBrowser显示网页,请问如何能用使javascript调用delphi中的函数
- 饭桶,YYgroup让你赶紧回来YY了!
- 有關DataSourceDataChange 事件
- 困扰多日的问题:一个hook的问题
- 请问在DELPHI应用程序重新运行时如何保存变量的值??????
- 怎么样使listbox的item处于选中状态
- 在线求教,菜鸟问题,如何在鼠标移到某个菜单项上时,在状态栏中显示出相应的提示信息,请大哥赐教!
- 怎么任意备份Access数据库里面的表?
- 跪求——如何在Delphi中创建一个圆形窗体!我向里面写完代码运行的时候,总是出来Delphi一开始运行的那个FORM1,请问怎么解决呀!!
- 程序员大本营光盘的制作?
- 怪哉,为何我这段代码不能限制鼠标移动区域?
- 我在窗体隐藏时,出现了个问题,达人来看看
ExcelWorkbook1.ConnectTo(ExcelApplication1.Workbooks.Add(EmptyParam,0));
打开已存在的工作簿:
ExcelApplication1.Workbooks.Open (c:\a.xls
EmptyParam,EmptyParam,EmptyParam,EmptyParam,
EmptyParam,EmptyParam,EmptyParam,EmptyParam,
EmptyParam,EmptyParam,EmptyParam,EmptyParam,0)
var
FPath, FName: WideString;
FPathIdx, i, j: Integer;
RowIDStr: String;
begin
try
ExcelApp.Connect;
except
Application.MessageBox('Excel 调用失败,Excel可能没有安装!', '系统提示',
Mb_IconWarning);
Abort;
end;
ExcelApp.Visible[0] := True;
ExcelApp.Caption := '数据导出'; FPathIdx := LastDelimiter('\', Application.ExeName);
FPath := Copy(Application.ExeName, 1, FPathIdx); //取得应用程序所在文件夹的目录. FName := FPath + 'REPORTS\Excel.xls';
try
ExcelApp.Workbooks.Open(FName, EmptyParam, EmptyParam, EmptyParam, EmptyParam,
EmptyParam, EmptyParam, EmptyParam, EmptyParam, EmptyParam, EmptyParam,
EmptyParam, EmptyParam, 0);
ExcelBook.ConnectTo(ExcelApp.Workbooks.Item[1]);
ExcelSheet.ConnectTo(ExcelBook.WorkSheets.Item[Sheet] as _WorkSheet); //按Excel工作表的编号写入
except ////.WorkSheets['Sheet2']按Excel工作表的名称写入
Application.MessageBox('Excel 调用失败,没有找到对应模板文件!', '系统提示',Mb_IconWarning);
exit;
end; try
with ExcelSheet do
begin
Cells.Item[2, 2] := s;
end; finally
ExcelSheet.Disconnect;
ExcelBook.Disconnect;
ExcelApp.Disconnect;
end;
end;