用SQL语句创建一个Excel文件的小问题
oConnection:= goPackage.Connections.New('Microsoft.Jet.OLEDB.4.0');
建立连接后
oTask := goPackage.Tasks.New('DTSExecuteSQLTask');
oCustomTask1 := oTask.CustomTask;
oCustomTask1.Name := '创建表 temp 任务';
oCustomTask1.Description := '创建表 temp 任务';
oCustomTask1.SQLStatement := 'CREATE TABLE temp (' + vbCrLf;
oCustomTask1.SQLStatement := oCustomTask1.SQLStatement + '[a] VarChar (10), ' + vbCrLf;
oCustomTask1.SQLStatement := oCustomTask1.SQLStatement + '[b] VarChar (10), ' + vbCrLf;
oCustomTask1.SQLStatement := oCustomTask1.SQLStatement + ')';
在VB中使用Create Table 'Temp'可正常执行，不知Delphi中如何改动
问题点数：30、回复次数：2Top
1 楼delphi_xizhousheng（西周生）回复于 2003-09-03 15:17:08 得分 15
用一个ADODATASET与指定的EXCEL数据源相连接
ADODATASET.COMMANDTEXT:='CREATE TABLE TABLENAME ()'Top
2 楼newsofter（横空出世小霸王）回复于 2003-09-03 17:13:22 得分 15
转贴：
unit EXCELA;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, Excel2000, OleServer, DB, DBTables, ComCtrls, Buttons,
ExtCtrls, jpeg;
type
TForm1 = class(TForm)
ExcelApplication1: TExcelApplication;
ExcelWorksheet1: TExcelWorksheet;
ExcelWorkbook1: TExcelWorkbook;
Button1: TButton;
Table1: TTable;
StatusBar1: TStatusBar;
BitBtn1: TBitBtn;
Shape1: TShape;
Bevel1: TBevel;
DateTimePicker1: TDateTimePicker;
Image1: TImage;
ExcelWorksheet2: TExcelWorksheet;
ExcelWorksheet3: TExcelWorksheet;
procedure Button1Click(Sender: TObject);
procedure FormClose(Sender: TObject; var Action: TCloseAction);
procedure FormCreate(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var
Form1: TForm1;
implementation
{$R *.dfm}
procedure TForm1.Button1Click(Sender: TObject);
var i,j,k,l,m,n:integer;ColumnRange,qzw,qzw1,QZW2: Variant;
begin
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:='黑体';
//excelworksheet2.Cells.Item[1,1]:='zw';
//excelworksheet2.Cells.Item[1,2]:='zw1';
qzw:=excelworksheet2.rows;
QZW1:=excelworksheet2.Range['A1','e1'];
QZW1.MERGE;
qzw1:=excelworksheet2.Range['A2','a10'];
qzw1.Merge;
qzw1:=excelworksheet2.Range['A2','a1'];
qzw1.Interior.ColorIndex:=3;
qzw.rows[1].rowheight:=30;
qzw.rows[1].font.color:=clblue;
qzw.rows[1].font.bold:=true;
qzw.rows[1].font.underline:=true;
QZW.ROWS[11].PAGEBREAK:=1;
excelworksheet2.PageSetup.PrintTitleRows:='$12:$12';
ColumnRange:= excelworksheet2.Columns;
ColumnRange.Columns[3].ColumnWidth:=30;
ColumnRange.Columns[3].font.name:='隶书';
ColumnRange.Columns[3].font.color:=clblue;
excelworksheet2.PageSetup.PrintGridlines:=true;
excelworksheet2.PageSetup.PaperSize:=XLPAPERA4;
//excelworksheet2.PageSetup.PaperSize:=XLPAPERuser;
excelworksheet2.PageSetup.CenterFooter:='第abc&P页共&N页&d&t&f&a';
excelworksheet2.PageSetup.PrintTitleRows:='$1:$2';
excelworksheet2.PageSetup.Orientation:=XLLANDSCAPE;
//ColumnRange.Columns[1].numberformatlocal:='G/通用格式';
//ColumnRange.Columns[1].numberformatlocal:='@';
excelworksheet2.PageSetup.CenterHeader:= '&"隶书"报表演示'#13+'1213';
table1.Close;
table1.DatabaseName:='e:\gzkd';
table1.TableName:='jzg.dbf';
table1.TableType:=ttfoxpro;
table1.Open;
j:=2;
k:=3;
excelworksheet2.Cells.Item[2,1]:='11';
excelworksheet2.Cells.Item[2,1].Orientation:= xlVertical;
excelworksheet2.Cells.Item[2,1].VerticalAlignment:= xlVAlignCenter;
excelworksheet2.Cells.Item[2,2]:='22';
excelworksheet2.Cells.Item[2,3]:='33';
excelworksheet2.Cells.Item[2,4]:='44';
excelworksheet2.Cells.Item[2,5]:='55';
for i:=1 to 100 do
begin
excelworksheet2.Cells.Item[k,2]:=table1.Fields[0].AsString;
excelworksheet2.Cells.Item[k,3]:=table1.Fields[1].AsString;
excelworksheet2.Cells.Item[k,4].numberformatlocal:='0.00';
excelworksheet2.Cells.Item[k,4]:=table1.Fieldbyname('11').AsFloat;
excelworksheet2.Cells.Item[k,5]:=table1.Fieldbyname('22').AsFloat;
excelworksheet2.Cells.Item[k,5].numberformatlocal:='0.00';
//excelworksheet2.Cells.Item[k,1].numberformatlocal:='0';
if i=10 then excelworksheet2.PageSetup.PrintTitleRows:='$12:$12';
k:=k+1;
table1.Next;
end;
excelworksheet2.Cells.Item[k+1,2]:='合 计';
excelworksheet2.Cells.Item[k+1,4]:='=sum(d1:d100)';
excelworksheet2.Cells.Item[k+1,5]:='=sum(e1:e100)';
excelworksheet2.Cells.Item[k+1,4].numberformatlocal:='0.00';
excelworksheet2.Cells.Item[k+1,5].numberformatlocal:='0.00';
excelworksheet2.Cells.Item[1,2].font.name:='黑体';
excelworksheet2.Cells.Item[1,1]:='123';
excelworksheet2.Cells.Item[1,1].HorizontalAlignment := xlCenter;
excelworksheet2.Cells.Item[1,1].font.size:=20;
ColumnRange.Columns[4].numberformatlocal:='#,##0.00';
excelworksheet2.Cells.Item[105,3]:=excelworksheet2.PageSetup.CenterHeader;
excelworksheet2.Cells.Item[105,4]:=Pos(#13,excelworksheet2.PageSetup.CenterHeader);
excelworksheet2.Cells.Item[105,5]:='&p';
excelworksheet2.Protect('123',true,true,true,true);
excelworksheet2.PrintPreview;
excelworkBOOK1.Saved[1]:=TRUE;
QZW2:='12345';
//excelworksheet2.SaveAs('e:\txt\123.xls',XLEXCEL9795,'789');
//QZW1.UNMERGE;
end;
procedure TForm1.FormClose(Sender: TObject; var Action: TCloseAction);
begin
excelapplication1.Quit;
excelapplication1.Disconnect;
end;
procedure TForm1.FormCreate(Sender: TObject);
begin
table1.Open;
statusbar1.Panels[0].Text:=table1.TableName;
statusbar1.Panels[1].Text:=inttostr(table1.RecordCount);
end;
end.
Top
相关问题
关键词
得分解答快速导航
相关链接
广告也精彩
反馈
