unit1.dfm

该源码程序使用DELPHI连接EXCEL数据表并查询生成新的表单及一些EXCEL调用函数

object Form1: TForm1
  Left = 378
  Top = 109
  BiDiMode = bdLeftToRight
  BorderIcons = [biSystemMenu, biMinimize]
  BorderStyle = bsSingle
  Caption = #26597#35810'Excel-----'#38081#29983#24037#20316#23460
  ClientHeight = 565
  ClientWidth = 531
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clMaroon
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Pitch = fpFixed
  Font.Style = []
  Icon.Data = {
    0000010001002020100000000000E80200001600000028000000200000004000
    0000010004000000000080020000000000000000000000000000000000000000
    0000000080000080000000808000800000008000800080800000C0C0C0008080
    80000000FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF000000
    0000000000000000000000000000007777777777777777777777777777000777
    7777777777077777777777777770077777000877778077777777777777700777
    7007778777700877777777777770077700877777777090877777777777700777
    0077777777770D07777777777770077700777777777709108000087777700777
    00777777777770D0777780077770077770877777777800910777780077700777
    770077777000770D077777007770077777780000087777091077770077700777
    7777777777777770D07777087770077777777777777777709107708777700777
    77777777777777770D0777777770077777777777777077770910777777700777
    00070077777C000000D0777777700777CC07C000077CCCCCC091077777700777
    CC0CCCCC0777CC07770D077777700777CC0C07CC077C0CC07709D07777700777
    CC0CCC7C077CCCCC07709077777007C0C07C0CCC07C00CC077780877777007C0
    C07CCC077CCCCCC077777777777007CCC0CCC0CC07C0CCC000777777777007CC
    C00CCCCC07C07CCCC0777777777007777CC0C077777777CC0777777777700777
    7CC0CC07777777C077777777777007777C077C07777777C07777777777700777
    7C07C077777777C0777777777770077777777777777777777777777777700077
    777777777777777777777777770000000000000000000000000000000000C000
    0003800000010000000000000000000000000000000000000000000000000000
    0000000000000000000000000000000000000000000000000000000000000000
    0000000000000000000000000000000000000000000000000000000000000000
    0000000000000000000000000000000000000000000080000001C0000003}
  OldCreateOrder = False
  ParentBiDiMode = False
  Scaled = False
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 13
  object Label1: TLabel
    Left = 8
    Top = 78
    Width = 137
    Height = 13
    AutoSize = False
    Caption = #35831#36873#25321#35201#26597#35810#30340#39033#65306
    Font.Charset = GB2312_CHARSET
    Font.Color = clMaroon
    Font.Height = -16
    Font.Name = #38582#20070
    Font.Pitch = fpFixed
    Font.Style = []
    ParentFont = False
  end
  object Label2: TLabel
    Left = 280
    Top = 78
    Width = 128
    Height = 16
    Caption = #35831#36755#20837#26597#35810#26465#20214#65306
    Font.Charset = GB2312_CHARSET
    Font.Color = clMaroon
    Font.Height = -16
    Font.Name = #38582#20070
    Font.Pitch = fpFixed
    Font.Style = []
    ParentFont = False
  end
  object Label3: TLabel
    Left = 8
    Top = 47
    Width = 144
    Height = 16
    Caption = #35831#36873#25321#35201#26597#35810#30340#34920#65306
    Font.Charset = GB2312_CHARSET
    Font.Color = clMaroon
    Font.Height = -16
    Font.Name = #38582#20070
    Font.Pitch = fpFixed
    Font.Style = []
    ParentFont = False
  end
  object Label4: TLabel
    Left = 280
    Top = 47
    Width = 128
    Height = 16
    Caption = #36873#25321#35201#23548#20837#30340#34920#65306
    Font.Charset = GB2312_CHARSET
    Font.Color = clMaroon
    Font.Height = -16
    Font.Name = #38582#20070
    Font.Pitch = fpFixed
    Font.Style = []
    ParentFont = False
  end
  object DBGrid1: TDBGrid
    Left = 5
    Top = 104
    Width = 521
    Height = 441
    Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
    TabOrder = 0
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clMaroon
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Pitch = fpFixed
    TitleFont.Style = []
    OnCellClick = DBGrid1CellClick
    OnKeyPress = DBGrid1KeyPress
  end
  object BitBtn1: TBitBtn
    Left = 8
    Top = 8
    Width = 75
    Height = 25
    Caption = #36830#25509#25968#25454#24211
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clBlack
    Font.Height = -11
    Font.Name = 'MS Sans Serif'
    Font.Pitch = fpFixed
    Font.Style = []
    ParentFont = False
    TabOrder = 1
    OnClick = BitBtn1Click
  end
  object Edit1: TEdit
    Left = 400
    Top = 75
    Width = 121
    Height = 21
    CharCase = ecUpperCase
    Font.Charset = ANSI_CHARSET
    Font.Color = clMaroon
    Font.Height = -13
    Font.Name = #23435#20307
    Font.Pitch = fpFixed
    Font.Style = []
    ParentFont = False
    TabOrder = 2
    OnKeyPress = Edit1KeyPress
  end
  object Button1: TButton
    Left = 232
    Top = 8
    Width = 75
    Height = 25
    Caption = #26597#35810
    Enabled = False
    TabOrder = 3
    OnClick = Button1Click
  end
  object Button2: TButton
    Left = 96
    Top = 8
    Width = 75
    Height = 25
    Caption = #25152#26377#25968#25454
    Enabled = False
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clBlack
    Font.Height = -11
    Font.Name = 'MS Sans Serif'
    Font.Pitch = fpFixed
    Font.Style = []
    ParentFont = False
    TabOrder = 4
    OnClick = Button2Click
  end
  object ComboBox1: TComboBox
    Left = 144
    Top = 75
    Width = 129
    Height = 21
    ItemHeight = 13
    TabOrder = 5
    Text = 'ComboBox1'
  end
  object Button4: TButton
    Left = 448
    Top = 8
    Width = 75
    Height = 25
    Caption = #25171#24320'Excel'
    Enabled = False
    TabOrder = 6
    OnClick = Button4Click
  end
  object Button3: TButton
    Left = 360
    Top = 8
    Width = 75
    Height = 25
    Caption = #26032#24314'Excel'
    Enabled = False
    TabOrder = 7
    OnClick = Button3Click
  end
  object StatusBar1: TStatusBar
    Left = 0
    Top = 546
    Width = 531
    Height = 19
    Panels = <
      item
        Width = 300
      end
      item
        Width = 80
      end
      item
        Width = 60
      end
      item
        Width = 50
      end>
  end
  object ComboBox2: TComboBox
    Left = 144
    Top = 45
    Width = 129
    Height = 21
    ItemHeight = 13
    TabOrder = 9
    Text = 'ComboBox2'
  end
  object ComboBox3: TComboBox
    Left = 400
    Top = 45
    Width = 121
    Height = 21
    ItemHeight = 13
    TabOrder = 10
    OnChange = ComboBox3Change
  end
  object ADOConnection1: TADOConnection
    LoginPrompt = False
    Mode = cmShareDenyNone
    Provider = 'Microsoft.Jet.OLEDB.4.0'
    Left = 472
    Top = 512
  end
  object DataSource1: TDataSource
    DataSet = ADOQuery1
    Left = 408
    Top = 512
  end
  object ADOQuery1: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Filtered = True
    Parameters = <>
    SQL.Strings = (
      'select * from [sheet1$]')
    Left = 440
    Top = 512
  end
  object OpenDialog1: TOpenDialog
    DefaultExt = '*.xls'
    Filter = '*.xls|*.xls'
    Left = 376
    Top = 512
  end
  object SaveDialog1: TSaveDialog
    Left = 504
    Top = 512
  end
  object XPManifest1: TXPManifest
    Left = 8
    Top = 512
  end
end