如何用Delphi新建一个xls文件? 如何用Delphi新建一个xls文件,如果该文件已经存在,就覆盖它? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 用数据库生成xls还是用SERVER组件生成? 用server建立一个xls文件,要是这个文件已经存在,就覆盖掉它或判断这个文件是否存在,存在就先删除它,在用server建立! var i,j,k,l,m,n:integer;ColumnRange,qzw,qzw1,QZW2: Variant;beginexcelapplication1.Connect;excelapplication1.Caption:='123';excelapplication1.Visible[0]:=true;excelapplication1.Workbooks.Add(null,0);excelworkbook1.ConnectTo(excelapplication1.Workbooks[1]);excelworksheet1.ConnectTo(excelworkbook1.Worksheets[1] as _worksheet);excelworksheet2.ConnectTo(excelworkbook1.Worksheets[2] as _worksheet);excelworksheet3.ConnectTo(excelworkbook1.Worksheets[3] as _worksheet);excelworksheet2.Activate;excelworksheet3.Name:='zwtlzr3';excelworksheet2.Name:='zwtlzr2';excelworksheet1.Name:='zwtlzr1';excelworksheet2.Columns.Font.Name:='黑体';ColumnRange:= excelworksheet2.Columns;ColumnRange.Columns[3].ColumnWidth:=30;ColumnRange.Columns[3].font.name:='隶书';ColumnRange.Columns[3].font.color:=clblue;j:=2;k:=3;excelworksheet2.Cells.Item[2,1]:='123';excelworksheet2.Cells.Item[2,2]:='456';excelworksheet2.SaveAs('d:\zz\123.xls',XLEXCEL9795,' '); 覆盖不行,只有删除,IF FILEEXISTS('C:\123.XLS')THEN DELETEFILE('C:\123.XLS'); 谢谢你WWWWA(aaaa) ( )上面的代码会在exl里弹出一个是否覆盖的对话框,我不想要!判断这个文件是否存在,存在就先删除它,在用server建立?谢谢解决马上给分! 上面的操作可不可以不打开exl? excelworksheet2.DisplayAlerts := false excelworksheet2.DisplayAlerts:=false;加在那,我加上后,就不让我编译了 excelworksheet2没有DisplayAlerts这个属性呀?我就是不想启动exl! excelapplication1.DisplayAlerts[1]:= false; IF FILEEXISTS('C:\123.XLS')THEN DELETEFILE('C:\123.XLS');excelapplication1.DisplayAlerts[0]:= false;//不启动exlexcelapplication1.Connect;excelapplication1.Caption:='123';excelapplication1.Visible[0]:=true;excelapplication1.Workbooks.Add(null,0);excelworkbook1.ConnectTo(excelapplication1.Workbooks[1]);excelworksheet1.ConnectTo(excelworkbook1.Worksheets[1] as _worksheet);excelworksheet2.ConnectTo(excelworkbook1.Worksheets[2] as _worksheet);excelworksheet3.ConnectTo(excelworkbook1.Worksheets[3] as _worksheet);excelworksheet2.SaveAs('c:\123.xls',XLEXCEL9795,' ');//excelapplication1.Quit;可是还是启动exl 用SERVER组件创建XLS文件,必须启动EXCEL,如不想启动EXCEL,只有用数据库生成XLS文件,当然表中无记录。 可以覆盖,设定对话框为默认按钮DisplayAlerts := false; 如何才能用delphi复制IE缓存里面的文件 delphi如何得到文件扩展名 Delphi中Flash播放ActiveX控件ShockwaveFlash的问题![急] 怎样在按钮上加图片? DELPHI能不能调用VB写的控件(*.OCX)?如果能要如何调用? 几个始终没有回答的问题 delphi 如何压缩视频 硬盘容量吃不消啊 问dll中显示窗体 文件拷贝 如何取到并修改文件夹的时间? 怎样让fsMDIChild型的Form显示在WebBrowser1的上面,而不是被WebBrowser1遮住? 关于filelistbox的很菜的问题?filelisttbox.filename返回值???
或判断这个文件是否存在,存在就先删除它,在用server建立!
excelapplication1.Connect;
excelapplication1.Caption:='123';
excelapplication1.Visible[0]:=true;
excelapplication1.Workbooks.Add(null,0);
excelworkbook1.ConnectTo(excelapplication1.Workbooks[1]);
excelworksheet1.ConnectTo(excelworkbook1.Worksheets[1] as _worksheet);
excelworksheet2.ConnectTo(excelworkbook1.Worksheets[2] as _worksheet);
excelworksheet3.ConnectTo(excelworkbook1.Worksheets[3] as _worksheet);
excelworksheet2.Activate;
excelworksheet3.Name:='zwtlzr3';
excelworksheet2.Name:='zwtlzr2';
excelworksheet1.Name:='zwtlzr1';
excelworksheet2.Columns.Font.Name:='黑体';
ColumnRange:= excelworksheet2.Columns;
ColumnRange.Columns[3].ColumnWidth:=30;
ColumnRange.Columns[3].font.name:='隶书';
ColumnRange.Columns[3].font.color:=clblue;
j:=2;
k:=3;
excelworksheet2.Cells.Item[2,1]:='123';
excelworksheet2.Cells.Item[2,2]:='456';
excelworksheet2.SaveAs('d:\zz\123.xls',XLEXCEL9795,' ');
IF FILEEXISTS('C:\123.XLS')THEN DELETEFILE('C:\123.XLS');
上面的代码会在exl里弹出一个是否覆盖的对话框,我不想要!
判断这个文件是否存在,存在就先删除它,在用server建立?
谢谢解决马上给分!
加在那,我加上后,就不让我编译了
我就是不想启动exl!
excelapplication1.DisplayAlerts[0]:= false;//不启动exl
excelapplication1.Connect;
excelapplication1.Caption:='123';
excelapplication1.Visible[0]:=true;
excelapplication1.Workbooks.Add(null,0);
excelworkbook1.ConnectTo(excelapplication1.Workbooks[1]);
excelworksheet1.ConnectTo(excelworkbook1.Worksheets[1] as _worksheet);
excelworksheet2.ConnectTo(excelworkbook1.Worksheets[2] as _worksheet);
excelworksheet3.ConnectTo(excelworkbook1.Worksheets[3] as _worksheet);
excelworksheet2.SaveAs('c:\123.xls',XLEXCEL9795,' ');
//excelapplication1.Quit;
可是还是启动exl
只有用数据库生成XLS文件,当然表中无记录。
DisplayAlerts := false;