一下是我的代码:
ExcelApplication1:=TExcelApplication.Create(self);
ExcelWorkbook1:=TExcelWorkbook.Create(self);
ExcelWorksheet1:=TExcelWorksheet.Create(self);
Screen.Cursor:=crHourGlass;
ExcelApplication1.Connect;
ExcelApplication1.Workbooks.Add(null,0);
ExcelWorkBook1.ConnectTo(ExcelApplication1.Workbooks[1]);
ExcelWorkSheet1.ConnectTo(ExcelWorkBook1.Sheets[1] as _WorkSheet);
ExcelFileName:=OpenDialog1.FileName;
ExcelApplication1.Workbooks.Open(ExcelFileName);
最后一句出错ExcelApplication1.Workbooks.Open(ExcelFileName);,参数不足,但看帮助后边的参数一堆,该写怎么写?
ExcelApplication1:=TExcelApplication.Create(self);
ExcelWorkbook1:=TExcelWorkbook.Create(self);
ExcelWorksheet1:=TExcelWorksheet.Create(self);
Screen.Cursor:=crHourGlass;
ExcelApplication1.Connect;
ExcelApplication1.Workbooks.Add(null,0);
ExcelWorkBook1.ConnectTo(ExcelApplication1.Workbooks[1]);
ExcelWorkSheet1.ConnectTo(ExcelWorkBook1.Sheets[1] as _WorkSheet);
ExcelFileName:=OpenDialog1.FileName;
ExcelApplication1.Workbooks.Open(ExcelFileName);
最后一句出错ExcelApplication1.Workbooks.Open(ExcelFileName);,参数不足,但看帮助后边的参数一堆,该写怎么写?
解决方案 »
- 2009,大吉大利
- 怎样将日期转化成国际日期“FEB 24,2006”格式?
- intraweb的IWDBGrid已设置好DataSource,为什么执行时IWDBGrid没有数据输出?
- 怎么监视打印机是否缺纸?缺纸时候程序给个提示然后跳出等待???
- 怎样获取一个日期类型数据是星期几?怎样截取月份,是几号,是第几周?
- 救命啊!!!!!!! 删除padaox数据库文件问题.
- FastRepot中的Memo显示数据的格式
- 如何将EXCELL中的数据导入到ACCESS中去。
- 关于BCB或其他环境正确调用Delphi编写的Dll问题。100分
- dbchart显示节点值得问题
- 初学delphi,请教treeview技巧
- 大伙可知道控件F1BOOK 6.01的免费版在哪有下载的?
EmptyParam,EmptyParam,EmptyParam,EmptyParam,
EmptyParam,EmptyParam,EmptyParam,EmptyParam,0)
var
i,j: integer;
iIndex: integer;
strTemp,strSQL,strForm: string;
ExcelApp,MyWorkBook :Variant;
begin
try
ExcelApp:=CreateOleObject('Excel.Application');
MyWorkBook:=CreateOleobject('Excel.Sheet');
except
on Exception do raise exception.Create('Can not open *.xls files. Please Confirm Microsoft Excel 2000 has been installed.')
end; ExcelApp.Visible := false;
try
MyWorkBook:=ExcelApp.workbooks.open('c:\xyz.xls');
except
on Exception do raise exception.Create('c:\xyz not found.')
end;
MyWorkBook.WorkSheets[1].Activate;
EmptyParam,EmptyParam,EmptyParam,EmptyParam,
EmptyParam,EmptyParam,EmptyParam,EmptyParam,0)
但结果还是出错啊
[Error] U_basic2.pas(79): Not enough actual parameters
以后你会发现。
最好的办法是用CreateOleObject的方法
打开Excel
Try
V:=CreateOleObject('Excel.Application');
V.WorkBooks.Open(打开的Excel的路径);
V.WorkBooks.Add;
Sheet:=V.WorkBooks[1].WorkSheets[1];
Except
ShowMessage('初始化Excel失败,可能没有装Excel或者其他错误,请重起再试');
V.DisplayAlerts:=False;
V.Quit;
Exit;
end;对Excel单元格子操作
Sheet.Cells[行,列]:='';关闭Excel
if not VarIsEmpty(V) then
begin
V.DisplayAlerts:=True;
V.Workbooks[1].Close;
V.Quit;
V:=Unassigned;
Sheet:=Unassigned;
end;
对于你的问题打开Excel因该为
excelapplication1.Workbooks.Open(OpenDialogExcel.FileName,null,null,null,null,null,null,null,null,null,null,null,null,0)
1。做多次导出的时候会有错误,提示你Excel没有安装
2。在没有退出程序的时候不能查看刚导出的Excel文件
Var
V,Sheet:variant;
excel表和数据库的相互导入导出!~~