求教:怎么用delphi编程实现向excel插入一张图片?并控制其位置。 大家帮忙啊? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 uses ComObj;procedure TForm1.Button1Click(Sender: TObject);Var FExcel :OleVariant; //excel应用程序 FWorkBook :OleVariant; //工作表 FWorksheet:OleVariant; //工作薄 FPicture:OleVariant; TmpStr:String;begin FExcel:= CreateoleObject('excel.Application'); FWorkBook:=FExcel.WorkBooks.Add; //新的工作表 FWorksheet:=FWorkBook.Worksheets[1]; FWorksheet.Select; //插入图象并设置位置与大小 tmpstr:='f:\1.jpg'; FPicture:=FWorksheet.Pictures.Insert(tmpstr); FPicture.Left:=10; FPicture.Top:=10; FPicture.width:=200; FPicture.height:=200; FPicture:=null; FExcel.visible:=true;end; 用delphi中自带的servers怎么实现呢? unit Unit1;interfaceuses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, StdCtrls, ExcelXP, OleServer, ExtDlgs;type TForm1 = class(TForm) ExcelApplication1: TExcelApplication; ExcelWorkbook1: TExcelWorkbook; ExcelWorksheet1: TExcelWorksheet; Button1: TButton; OpenPictureDialog1: TOpenPictureDialog; procedure Button1Click(Sender: TObject); private { Private declarations } public { Public declarations } end;var Form1: TForm1;implementation{$R *.dfm}procedure TForm1.Button1Click(Sender: TObject);var aWorkBook : _Workbook; aSheet : Variant; FPicture:OleVariant;begin if OpenPictureDialog1.Execute then begin ExcelApplication1.Connect; aWorkBook := ExcelApplication1.Workbooks.Add(EmptyParam, 0); aSheet := aWorkBook.Sheets[1]; //aSheet.Range['f1'].Select;//这里是定位图片插入的位置 FPicture:=asheet.Pictures.Insert(OpenPictureDialog1.FileName); FPicture.Left:=100; FPicture.Top:=100; ExcelApplication1.Visible[0] := True; ExcelApplication1.Disconnect; end;end;end.我这里有源码,楼主如果要,可以把Email留下,待我有空时发给你。 那能否直接把DBIMAGE中的图片导到EXCEL的一个指定位置上呢?不是从某个文件夹下打开。 关于游戏自动登陆的问题,在线~~~~~~~ 如何解决将数据导入Execl中表中! 调试过DLL的兄弟们请进!苦恼死我了 请教怎么快速判断在一个表中存在,在另一个表中不存在的记录(两个表有相同的字段) 简单重要的概念问题? 关于Tquery控件的字段长度的问题 如何通过代码,令到stringgrid中的指定的单元格成为活动单元格(获得焦点) 我是刚开始学习DELPHI的MM用户,请教大家一个基本问题 如何将查询结果纵向变成横向显示 下面怎不行??? 送1000分,不够再加。在delphi中通过ADO怎样获得所有数据库名 连接access时,如何把连接设为相对路径!
Var FExcel :OleVariant; //excel应用程序
FWorkBook :OleVariant; //工作表
FWorksheet:OleVariant; //工作薄
FPicture:OleVariant;
TmpStr:String;
begin
FExcel:= CreateoleObject('excel.Application');
FWorkBook:=FExcel.WorkBooks.Add; //新的工作表
FWorksheet:=FWorkBook.Worksheets[1];
FWorksheet.Select; //插入图象并设置位置与大小
tmpstr:='f:\1.jpg';
FPicture:=FWorksheet.Pictures.Insert(tmpstr);
FPicture.Left:=10;
FPicture.Top:=10;
FPicture.width:=200;
FPicture.height:=200;
FPicture:=null;
FExcel.visible:=true;
end;
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, ExcelXP, OleServer, ExtDlgs;type
TForm1 = class(TForm)
ExcelApplication1: TExcelApplication;
ExcelWorkbook1: TExcelWorkbook;
ExcelWorksheet1: TExcelWorksheet;
Button1: TButton;
OpenPictureDialog1: TOpenPictureDialog;
procedure Button1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Form1: TForm1;implementation{$R *.dfm}procedure TForm1.Button1Click(Sender: TObject);
var
aWorkBook : _Workbook;
aSheet : Variant;
FPicture:OleVariant;
begin
if OpenPictureDialog1.Execute then
begin
ExcelApplication1.Connect;
aWorkBook := ExcelApplication1.Workbooks.Add(EmptyParam, 0);
aSheet := aWorkBook.Sheets[1];
//aSheet.Range['f1'].Select;//这里是定位图片插入的位置
FPicture:=asheet.Pictures.Insert(OpenPictureDialog1.FileName);
FPicture.Left:=100;
FPicture.Top:=100;
ExcelApplication1.Visible[0] := True;
ExcelApplication1.Disconnect;
end;
end;end.
我这里有源码,楼主如果要,可以把Email留下,待我有空时发给你。
不是从某个文件夹下打开。