main.dfm

delphi 操作excel的例程

object FrmMain: TFrmMain
  Left = 188
  Top = 74
  Width = 1014
  Height = 651
  Caption = #22788#29702'Excel'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  Position = poDesktopCenter
  WindowState = wsMaximized
  PixelsPerInch = 96
  TextHeight = 13
  object Splitter1: TSplitter
    Left = 0
    Top = 289
    Width = 1006
    Height = 13
    Cursor = crVSplit
    Align = alTop
  end
  object Panel1: TPanel
    Left = 0
    Top = 41
    Width = 1006
    Height = 248
    Align = alTop
    BevelOuter = bvNone
    TabOrder = 0
    object Splitter2: TSplitter
      Left = 553
      Top = 0
      Width = 13
      Height = 248
    end
    object DBGridEh2: TDBGrid
      Left = 566
      Top = 0
      Width = 440
      Height = 248
      Align = alClient
      DataSource = DataSource2
      Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
      TabOrder = 0
      TitleFont.Charset = DEFAULT_CHARSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -11
      TitleFont.Name = 'MS Sans Serif'
      TitleFont.Style = []
    end
    object DBGridEh1: TDBGrid
      Left = 0
      Top = 0
      Width = 553
      Height = 248
      Align = alLeft
      DataSource = DataSource1
      Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
      TabOrder = 1
      TitleFont.Charset = DEFAULT_CHARSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -11
      TitleFont.Name = 'MS Sans Serif'
      TitleFont.Style = []
    end
  end
  object Panel2: TPanel
    Left = 0
    Top = 302
    Width = 1006
    Height = 322
    Align = alClient
    BevelOuter = bvNone
    TabOrder = 1
    object DBGridEh3: TDBGrid
      Left = 0
      Top = 0
      Width = 1006
      Height = 322
      Align = alClient
      DataSource = DataSource3
      Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
      TabOrder = 0
      TitleFont.Charset = DEFAULT_CHARSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -11
      TitleFont.Name = 'MS Sans Serif'
      TitleFont.Style = []
    end
  end
  object Panel3: TPanel
    Left = 0
    Top = 0
    Width = 1006
    Height = 41
    Align = alTop
    BevelOuter = bvNone
    TabOrder = 2
    object Button1: TButton
      Left = 32
      Top = 8
      Width = 75
      Height = 25
      Caption = 'Excel 1'
      TabOrder = 0
      OnClick = Button1Click
    end
    object Button2: TButton
      Left = 120
      Top = 8
      Width = 75
      Height = 25
      Caption = 'Excel 2'
      TabOrder = 1
      OnClick = Button2Click
    end
    object Button3: TButton
      Left = 208
      Top = 8
      Width = 75
      Height = 25
      Caption = #22788#29702
      TabOrder = 2
      OnClick = Button3Click
    end
    object Button4: TButton
      Left = 296
      Top = 8
      Width = 75
      Height = 25
      Caption = #23548#20986
      TabOrder = 3
      OnClick = Button4Click
    end
  end
  object OpenDialog1: TOpenDialog
    Filter = 'EXCEL|*.XLS'
    Left = 608
    Top = 8
  end
  object ADOConnection1: TADOConnection
    KeepConnection = False
    LoginPrompt = False
    Left = 64
    Top = 72
  end
  object ADOQuery1: TADOQuery
    Connection = ADOConnection1
    Parameters = <>
    Left = 160
    Top = 73
  end
  object DataSource1: TDataSource
    DataSet = ADOQuery1
    Left = 96
    Top = 73
  end
  object ADOConnection2: TADOConnection
    KeepConnection = False
    LoginPrompt = False
    Left = 448
    Top = 96
  end
  object DataSource2: TDataSource
    DataSet = ADOQuery2
    Left = 480
    Top = 97
  end
  object ADOQuery2: TADOQuery
    Connection = ADOConnection2
    Parameters = <>
    Left = 544
    Top = 97
  end
  object DataSource3: TDataSource
    DataSet = ADOQuery3
    Left = 248
    Top = 449
  end
  object ADOQuery3: TADOQuery
    Connection = ADOConnection1
    Parameters = <>
    Left = 312
    Top = 449
  end
  object SaveDialog1: TSaveDialog
    Filter = 'EXCEL|*.XLS'
    Left = 656
  end
end