unit1.dfm

本实例Delphi实现了一个自动化控制器对EXCEl的控制

object Form1: TForm1
  Left = 830
  Top = 156
  Width = 540
  Height = 423
  Caption = 'EXCEL'#33258#21160#21270#25511#21046#22120
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  PixelsPerInch = 96
  TextHeight = 13
  object DBGrid1: TDBGrid
    Left = 16
    Top = 16
    Width = 497
    Height = 305
    DataSource = DataSource1
    TabOrder = 0
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
  end
  object BitBtn1: TBitBtn
    Left = 24
    Top = 339
    Width = 81
    Height = 25
    Caption = #20445#23384#21040'EXCEL'
    TabOrder = 1
    OnClick = BitBtn1Click
  end
  object BitBtn2: TBitBtn
    Left = 152
    Top = 339
    Width = 75
    Height = 25
    Caption = #20851#38381'EXCEL'
    TabOrder = 2
    OnClick = BitBtn2Click
  end
  object BitBtn3: TBitBtn
    Left = 288
    Top = 339
    Width = 75
    Height = 25
    Caption = #25171#21360#39044#35272
    TabOrder = 3
    OnClick = BitBtn3Click
  end
  object BitBtn4: TBitBtn
    Left = 424
    Top = 339
    Width = 75
    Height = 25
    Caption = #25171#21360
    TabOrder = 4
    OnClick = BitBtn4Click
  end
  object Table1: TTable
    DatabaseName = 'DBDEMOS'
    TableName = 'country.db'
    Left = 320
    Top = 112
  end
  object DataSource1: TDataSource
    DataSet = Table1
    Left = 216
    Top = 112
  end
  object ExcelApplication1: TExcelApplication
    AutoConnect = False
    ConnectKind = ckRunningOrNew
    AutoQuit = False
    Left = 80
    Top = 88
  end
  object ExcelWorksheet1: TExcelWorksheet
    AutoConnect = False
    ConnectKind = ckRunningOrNew
    Left = 136
    Top = 80
  end
  object ExcelWorkbook1: TExcelWorkbook
    AutoConnect = False
    ConnectKind = ckRunningOrNew
    Left = 192
    Top = 72
  end
end