unit1.dfm

此程序是可以将数据库表中的数据导出转为EXCEL、也可将EXCEL中的数据导入至数据库的表中。

object Form1: TForm1
  Left = -4
  Top = -4
  Width = 1032
  Height = 746
  Caption = 'EXCEL'#19982'SQL'#25968#25454#24211#23548#20837#23548#20986#24037#20855
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 13
  object Panel1: TPanel
    Left = 0
    Top = 0
    Width = 1024
    Height = 49
    Align = alTop
    Font.Charset = GB2312_CHARSET
    Font.Color = clWindowText
    Font.Height = -11
    Font.Name = #23435#20307
    Font.Style = [fsBold]
    ParentFont = False
    TabOrder = 0
    object TLabel
      Left = 24
      Top = 16
      Width = 7
      Height = 11
    end
    object Label2: TLabel
      Left = 213
      Top = 8
      Width = 75
      Height = 15
      Caption = #36873#25321#25968#25454#34920
      Font.Charset = GB2312_CHARSET
      Font.Color = clWindowText
      Font.Height = -15
      Font.Name = #23435#20307
      Font.Style = []
      ParentFont = False
    end
    object Label1: TLabel
      Left = 13
      Top = 8
      Width = 65
      Height = 13
      Caption = #36873#25321#25968#25454#24211
      Font.Charset = GB2312_CHARSET
      Font.Color = clWindowText
      Font.Height = -13
      Font.Name = #23435#20307
      Font.Style = []
      ParentFont = False
    end
    object C_table: TComboBox
      Left = 216
      Top = 23
      Width = 169
      Height = 21
      Style = csDropDownList
      Color = clBtnFace
      Font.Charset = GB2312_CHARSET
      Font.Color = clTeal
      Font.Height = -13
      Font.Name = #23435#20307
      Font.Style = [fsBold]
      ItemHeight = 13
      ParentFont = False
      TabOrder = 0
      OnChange = C_tableChange
    end
    object C_data: TComboBox
      Left = 16
      Top = 22
      Width = 169
      Height = 21
      Style = csDropDownList
      Color = clBtnFace
      Font.Charset = GB2312_CHARSET
      Font.Color = clTeal
      Font.Height = -13
      Font.Name = #23435#20307
      Font.Style = [fsBold]
      ItemHeight = 13
      ParentFont = False
      TabOrder = 1
      OnChange = C_dataChange
    end
    object Button1: TButton
      Left = 658
      Top = 15
      Width = 50
      Height = 25
      Caption = #23548' '#20986
      Enabled = False
      Font.Charset = GB2312_CHARSET
      Font.Color = clWindowText
      Font.Height = -13
      Font.Name = #23435#20307
      Font.Style = []
      ParentFont = False
      TabOrder = 2
      OnClick = Button1Click
    end
    object Button2: TButton
      Left = 866
      Top = 15
      Width = 82
      Height = 25
      Caption = #36830#25509#23548#20837#25968#25454
      Font.Charset = GB2312_CHARSET
      Font.Color = clWindowText
      Font.Height = -13
      Font.Name = #23435#20307
      Font.Style = []
      ParentFont = False
      TabOrder = 3
      OnClick = Button2Click
    end
    object Button3: TButton
      Left = 947
      Top = 15
      Width = 68
      Height = 25
      Caption = #36830#25509#25968#25454#24211
      Font.Charset = GB2312_CHARSET
      Font.Color = clWindowText
      Font.Height = -13
      Font.Name = #23435#20307
      Font.Style = []
      ParentFont = False
      TabOrder = 4
      OnClick = Button3Click
    end
    object Edit1: TEdit
      Left = 808
      Top = 16
      Width = 33
      Height = 19
      TabOrder = 5
      Visible = False
    end
    object BitBtn1: TBitBtn
      Left = 459
      Top = 15
      Width = 50
      Height = 25
      Enabled = False
      TabOrder = 6
      OnClick = BitBtn1Click
      Glyph.Data = {
        F6000000424DF600000000000000760000002800000010000000100000000100
        0400000000008000000000000000000000001000000000000000000000000000
        8000008000000080800080000000800080008080000080808000C0C0C0000000
        FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00888888888888
        8888888888888888888888888888888888888888448888818888888844888811
        8888888844888111888888884488111188888888448111118888888844881111
        8888888844888111888888884488881188888888448888818888888888888888
        8888888888888888888888888888888888888888888888888888}
    end
    object BitBtn2: TBitBtn
      Left = 508
      Top = 15
      Width = 50
      Height = 25
      Enabled = False
      TabOrder = 7
      OnClick = BitBtn2Click
      Glyph.Data = {
        F6000000424DF600000000000000760000002800000010000000100000000100
        0400000000008000000000000000000000001000000000000000000000000000
        8000008000000080800080000000800080008080000080808000C0C0C0000000
        FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00888888888888
        8888888888888888888888888888888888888888888881888888888888881188
        8888888888811188888888888811118888888888811111888888888888111188
        8888888888811188888888888888118888888888888881888888888888888888
        8888888888888888888888888888888888888888888888888888}
    end
    object BitBtn3: TBitBtn
      Left = 558
      Top = 15
      Width = 50
      Height = 25
      Enabled = False
      TabOrder = 8
      OnClick = BitBtn3Click
      Glyph.Data = {
        F6000000424DF600000000000000760000002800000010000000100000000100
        0400000000008000000000000000000000001000000000000000000000000000
        8000008000000080800080000000800080008080000080808000C0C0C0000000
        FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00888888888888
        8888888888888888888888888888888888888888881888888888888888118888
        8888888888111888888888888811118888888888881111188888888888111188
        8888888888111888888888888811888888888888881888888888888888888888
        8888888888888888888888888888888888888888888888888888}
    end
    object BitBtn4: TBitBtn
      Left = 608
      Top = 15
      Width = 50
      Height = 25
      Enabled = False
      TabOrder = 9
      OnClick = BitBtn4Click
      Glyph.Data = {
        F6000000424DF600000000000000760000002800000010000000100000000100
        0400000000008000000000000000000000001000000000000000000000000000
        8000008000000080800080000000800080008080000080808000C0C0C0000000
        FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00888888888888
        8888888888888888888888888888888888888888188888448888888811888844
        8888888811188844888888881111884488888888111118448888888811118844
        8888888811188844888888881188884488888888188888448888888888888888
        8888888888888888888888888888888888888888888888888888}
    end
  end
  object Panel2: TPanel
    Left = 0
    Top = 49
    Width = 1024
    Height = 663
    Align = alClient
    BevelInner = bvLowered
    BorderStyle = bsSingle
    TabOrder = 1
    object L_field: TListBox
      Left = 2
      Top = 2
      Width = 199
      Height = 655
      Align = alLeft
      Color = clBtnFace
      Font.Charset = GB2312_CHARSET
      Font.Color = clTeal
      Font.Height = -12
      Font.Name = #23435#20307
      Font.Style = [fsBold]
      ItemHeight = 12
      MultiSelect = True
      ParentFont = False
      TabOrder = 0
      OnClick = L_fieldClick
    end
    object DBGrid1: TDBGrid
      Left = 201
      Top = 2
      Width = 817
      Height = 655
      Align = alClient
      Color = clBtnFace
      DataSource = DataSource1
      FixedColor = clTeal
      Font.Charset = GB2312_CHARSET
      Font.Color = clTeal
      Font.Height = -11
      Font.Name = #23435#20307
      Font.Style = [fsBold]
      Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
      ParentFont = False
      ReadOnly = True
      TabOrder = 1
      TitleFont.Charset = GB2312_CHARSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -11
      TitleFont.Name = #23435#20307
      TitleFont.Style = [fsBold]
    end
  end
  object B_view: TButton
    Left = 410
    Top = 15
    Width = 50
    Height = 25
    Caption = #26174' '#31034
    Enabled = False
    TabOrder = 2
    OnClick = B_viewClick
  end
  object B_close: TButton
    Left = 709
    Top = 15
    Width = 50
    Height = 25
    Caption = #36864' '#20986
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clWindowText
    Font.Height = -11
    Font.Name = 'MS Sans Serif'
    Font.Style = [fsBold]
    ParentFont = False
    TabOrder = 3
    OnClick = B_closeClick
  end
  object Table1: TTable
    Left = 97
    Top = 105
  end
  object DataSource1: TDataSource
    DataSet = Query1
    Left = 136
    Top = 145
  end
  object Query1: TQuery
    Left = 96
    Top = 145
  end
  object ExcelApplication1: TExcelApplication
    AutoConnect = False
    ConnectKind = ckRunningOrNew
    AutoQuit = False
    Left = 272
    Top = 105
  end
  object ExcelWorksheet1: TExcelWorksheet
    AutoConnect = False
    ConnectKind = ckRunningOrNew
    Left = 384
    Top = 121
  end
  object ExcelWorkbook1: TExcelWorkbook
    AutoConnect = False
    ConnectKind = ckRunningOrNew
    Left = 480
    Top = 113
  end
end