unit_frm_rszlfromexcel.dfm

delphi实现EXCEL复杂导入导出功能的类

object frm_rszlFromExcel: Tfrm_rszlFromExcel
  Left = 370
  Top = 326
  BorderIcons = [biSystemMenu]
  BorderStyle = bsSingle
  Caption = #20174' Excel '#25991#20214#23548#20837#20154#20107#36164#26009
  ClientHeight = 165
  ClientWidth = 417
  Color = clBtnFace
  Font.Charset = GB2312_CHARSET
  Font.Color = clWindowText
  Font.Height = -12
  Font.Name = #23435#20307
  Font.Style = []
  OldCreateOrder = False
  Position = poScreenCenter
  OnClose = FormClose
  OnCloseQuery = FormCloseQuery
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 12
  object gg1: TGauge
    Left = 16
    Top = 36
    Width = 385
    Height = 20
    Progress = 0
  end
  object lbl1: TRzLabel
    Left = 16
    Top = 14
    Width = 60
    Height = 12
    Caption = #23548#20837#36827#24230#65306
  end
  object lbl2: TRzLabel
    Left = 80
    Top = 14
    Width = 321
    Height = 12
    AutoSize = False
    Caption = 'lbl2'
    Transparent = True
  end
  object lbl3: TLabel
    Left = 16
    Top = 73
    Width = 72
    Height = 12
    Caption = 'Excel '#25991#20214#65306
  end
  object lbl5: TLabel
    Left = 14
    Top = 147
    Width = 246
    Height = 12
    Caption = #25552#31034#65306#22312#23548#20837#21069#35831#23558#25152#26377#30340' EXCEL '#31383#21475#20851#38381#12290
    Font.Charset = GB2312_CHARSET
    Font.Color = clGreen
    Font.Height = -12
    Font.Name = #23435#20307
    Font.Style = []
    ParentFont = False
  end
  object bvl1: TBevel
    Left = 8
    Top = 139
    Width = 401
    Height = 2
  end
  object bbtn_excel: TRzBitBtn
    Left = 240
    Top = 104
    Caption = #23548#20837'(&L)'
    TabOrder = 0
    OnClick = bbtn_excelClick
    Glyph.Data = {
      36060000424D3606000000000000360400002800000020000000100000000100
      08000000000000020000230B0000230B00000001000000000000000000003300
      00006600000099000000CC000000FF0000000033000033330000663300009933
      0000CC330000FF33000000660000336600006666000099660000CC660000FF66
      000000990000339900006699000099990000CC990000FF99000000CC000033CC
      000066CC000099CC0000CCCC0000FFCC000000FF000033FF000066FF000099FF
      0000CCFF0000FFFF000000003300330033006600330099003300CC003300FF00
      330000333300333333006633330099333300CC333300FF333300006633003366
      33006666330099663300CC663300FF6633000099330033993300669933009999
      3300CC993300FF99330000CC330033CC330066CC330099CC3300CCCC3300FFCC
      330000FF330033FF330066FF330099FF3300CCFF3300FFFF3300000066003300
      66006600660099006600CC006600FF0066000033660033336600663366009933
      6600CC336600FF33660000666600336666006666660099666600CC666600FF66
      660000996600339966006699660099996600CC996600FF99660000CC660033CC
      660066CC660099CC6600CCCC6600FFCC660000FF660033FF660066FF660099FF
      6600CCFF6600FFFF660000009900330099006600990099009900CC009900FF00
      990000339900333399006633990099339900CC339900FF339900006699003366
      99006666990099669900CC669900FF6699000099990033999900669999009999
      9900CC999900FF99990000CC990033CC990066CC990099CC9900CCCC9900FFCC
      990000FF990033FF990066FF990099FF9900CCFF9900FFFF99000000CC003300
      CC006600CC009900CC00CC00CC00FF00CC000033CC003333CC006633CC009933
      CC00CC33CC00FF33CC000066CC003366CC006666CC009966CC00CC66CC00FF66
      CC000099CC003399CC006699CC009999CC00CC99CC00FF99CC0000CCCC0033CC
      CC0066CCCC0099CCCC00CCCCCC00FFCCCC0000FFCC0033FFCC0066FFCC0099FF
      CC00CCFFCC00FFFFCC000000FF003300FF006600FF009900FF00CC00FF00FF00
      FF000033FF003333FF006633FF009933FF00CC33FF00FF33FF000066FF003366
      FF006666FF009966FF00CC66FF00FF66FF000099FF003399FF006699FF009999
      FF00CC99FF00FF99FF0000CCFF0033CCFF0066CCFF0099CCFF00CCCCFF00FFCC
      FF0000FFFF0033FFFF0066FFFF0099FFFF00CCFFFF00FFFFFF00000080000080
      000000808000800000008000800080800000C0C0C00080808000191919004C4C
      4C00B2B2B200E5E5E500C8AC2800E0CC6600F2EABF00B59B2400D8E9EC009933
      6600D075A300ECC6D900646F710099A8AC00E2EFF10000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000E8E8A3787878
      7878787878787878E8E8E8E8818181818181818181818181E8E8E8A3CEA3D5CE
      CECECECECECEA3D578E8E881AC81E3ACACACACACACAC81E381E8E8A3CEA3D5D5
      D5D5D5D5D5D5CED578E8E881AC81E3E3E3E3E3E3E3E3ACE381E8E8A3CEA3D5D5
      0C5BD5D5D5D5CED578E8E881AC81E3E381ACE3E3E3E3ACE381E8E8A3CEA3D5D5
      7F3737D5D5D5CED578E8E881AC81E3E3AC8181E3E3E3ACE381E8E8A3CEA3D5D5
      B137615BD5D5CED578E8E881AC81E3E3E381E3ACE3E3ACE381E8E8A3CEA3D5D5
      D5368C37B1D5CED578E8E881AC81E3E3E381E381E3E3ACE381E8E8A3D5D5A3A3
      A33061615BA3A3A3A3E8E881E3E381818181E3E3AC81818181E8E8A3D5D5D5D5
      D5D9616137D578E8E8E8E881E3E3E3E3E381E3E381E381E8E8E8E8E8A3D5D5D5
      D5D9616137A3E8E8E8E8E8E881E3E3E3E381E3E38181E8E8E8E8E8E8E8A3A3A3
      A336616137E8E8E8E8E8E8E8E88181818181E3E381E8E8E8E8E8E8E8E8E80CD9
      D937616131D9D9E8E8E8E8E8E8E881818181E3E3818181E8E8E8E8E8E8E85CD9
      3D3D6161370C5CE8E8E8E8E8E8E8AC81E3E3E3E38181ACE8E8E8E8E8E8E8E831
      363D3D3631DEE8E8E8E8E8E8E8E8E88181E3E38181DEE8E8E8E8E8E8E8E8E887
      D912D980E8E8E8E8E8E8E8E8E8E8E8E3818181ACE8E8E8E8E8E8E8E8E8E8E8E8
      5C37ACE8E8E8E8E8E8E8E8E8E8E8E8E8AC81ACE8E8E8E8E8E8E8}
    NumGlyphs = 2
  end
  object bbtn_Close: TRzBitBtn
    Left = 320
    Top = 104
    Caption = #20851#38381'(&C)'
    TabOrder = 1
    OnClick = bbtn_CloseClick
    Glyph.Data = {
      36060000424D3606000000000000360400002800000020000000100000000100
      08000000000000020000730B0000730B00000001000000000000000000003300
      00006600000099000000CC000000FF0000000033000033330000663300009933
      0000CC330000FF33000000660000336600006666000099660000CC660000FF66
      000000990000339900006699000099990000CC990000FF99000000CC000033CC
      000066CC000099CC0000CCCC0000FFCC000000FF000033FF000066FF000099FF
      0000CCFF0000FFFF000000003300330033006600330099003300CC003300FF00
      330000333300333333006633330099333300CC333300FF333300006633003366
      33006666330099663300CC663300FF6633000099330033993300669933009999
      3300CC993300FF99330000CC330033CC330066CC330099CC3300CCCC3300FFCC
      330000FF330033FF330066FF330099FF3300CCFF3300FFFF3300000066003300
      66006600660099006600CC006600FF0066000033660033336600663366009933
      6600CC336600FF33660000666600336666006666660099666600CC666600FF66
      660000996600339966006699660099996600CC996600FF99660000CC660033CC
      660066CC660099CC6600CCCC6600FFCC660000FF660033FF660066FF660099FF
      6600CCFF6600FFFF660000009900330099006600990099009900CC009900FF00
      990000339900333399006633990099339900CC339900FF339900006699003366
      99006666990099669900CC669900FF6699000099990033999900669999009999
      9900CC999900FF99990000CC990033CC990066CC990099CC9900CCCC9900FFCC
      990000FF990033FF990066FF990099FF9900CCFF9900FFFF99000000CC003300
      CC006600CC009900CC00CC00CC00FF00CC000033CC003333CC006633CC009933
      CC00CC33CC00FF33CC000066CC003366CC006666CC009966CC00CC66CC00FF66
      CC000099CC003399CC006699CC009999CC00CC99CC00FF99CC0000CCCC0033CC
      CC0066CCCC0099CCCC00CCCCCC00FFCCCC0000FFCC0033FFCC0066FFCC0099FF
      CC00CCFFCC00FFFFCC000000FF003300FF006600FF009900FF00CC00FF00FF00
      FF000033FF003333FF006633FF009933FF00CC33FF00FF33FF000066FF003366
      FF006666FF009966FF00CC66FF00FF66FF000099FF003399FF006699FF009999
      FF00CC99FF00FF99FF0000CCFF0033CCFF0066CCFF0099CCFF00CCCCFF00FFCC
      FF0000FFFF0033FFFF0066FFFF0099FFFF00CCFFFF00FFFFFF00000080000080
      000000808000800000008000800080800000C0C0C00080808000191919004C4C
      4C00B2B2B200E5E5E500C8AC2800E0CC6600F2EABF00B59B2400D8E9EC009933
      6600D075A300ECC6D900646F710099A8AC00E2EFF10000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000E8E8E8E8E8E8
      EEE8E8E8E8E8E8E8E8E8E8E8E8E8E8E8EEE8E8E8E8E8E8E8E8E8E8E8E8EEE3AC
      E3EEE8E8E8E8E8E8E8E8E8E8E8EEE8ACE3EEE8E8E8E8E8E8E8E8E8EEE3E28257
      57E2ACE3EEE8E8E8E8E8E8EEE8E2818181E2ACE8EEE8E8E8E8E8E382578282D7
      578181E2E3E8E8E8E8E8E881818181D7818181E2E8E8E8E8E8E857828989ADD7
      57797979EEE8E8E8E8E88181DEDEACD781818181EEE8E8E8E8E857898989ADD7
      57AAAAA2D7ADE8E8E8E881DEDEDEACD781DEDE81D7ACE8E8E8E857898989ADD7
      57AACEA3AD10E8E8E8E881DEDEDEACD781DEAC81AC81E8E8E8E85789825EADD7
      57ABCFE21110E8E8E8E881DE8181ACD781ACACE28181E8E8E8E8578957D7ADD7
      57ABDE101010101010E881DE56D7ACD781ACDE818181818181E857898257ADD7
      57E810101010101010E881DE8156ACD781E381818181818181E857898989ADD7
      57E882101010101010E881DEDEDEACD781E381818181818181E857898989ADD7
      57ACEE821110E8E8E8E881DEDEDEACD781ACEE818181E8E8E8E857898989ADD7
      57ABE8AB8910E8E8E8E881DEDEDEACD781ACE3ACDE81E8E8E8E857828989ADD7
      57ACE8A3E889E8E8E8E88181DEDEACD781ACE381E8DEE8E8E8E8E8DE5E8288D7
      57A2A2A2E8E8E8E8E8E8E8DE8181DED781818181E8E8E8E8E8E8E8E8E8AC8257
      57E8E8E8E8E8E8E8E8E8E8E8E8AC818181E8E8E8E8E8E8E8E8E8}
    NumGlyphs = 2
  end
  object fileedt1: TLMDFileOpenEdit
    Left = 96
    Top = 69
    Width = 305
    Height = 21
    Bevel.Mode = bmWindows
    Caret.BlinkRate = 530
    TabOrder = 2
    Options = [ofHideReadOnly, ofFileMustExist]
    CustomButtonWidth = 18
    Title = #35831#36873#25321#20154#20107#36164#26009' Excel '#25991#20214
    Filter = 'Excel '#25991#20214' (*.xls)|*.xls'
    DefaultExt = '*.xls'
    FilenameOnly = False
    ReadOnly = True
  end
  object qry1: TADOQuery
    Connection = Dm1.con1
    Parameters = <>
    Left = 144
    Top = 8
  end
  object qry2: TADOQuery
    Connection = Dm1.con1
    Parameters = <>
    Left = 176
    Top = 8
  end
  object qry3: TADOQuery
    Connection = Dm1.con2
    Parameters = <>
    Left = 208
    Top = 8
  end
  object qry4: TADOQuery
    Connection = Dm1.con2
    Parameters = <>
    Left = 240
    Top = 8
  end
end