unit1.dfm

一个用DELPHI做的对Excel的操作 可以通过本程序对EXCEL进行导入 导出操作 附上源码

object Form1: TForm1
  Left = 365
  Top = 163
  Width = 384
  Height = 202
  Caption = 'Form1'
  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 Label1: TLabel
    Left = 72
    Top = 40
    Width = 60
    Height = 13
    Caption = #23548#20986#25991#20214#21517
  end
  object SpeedButton1: TSpeedButton
    Left = 264
    Top = 40
    Width = 23
    Height = 22
    Caption = '...'
    OnClick = SpeedButton1Click
  end
  object EditPath: TEdit
    Left = 136
    Top = 40
    Width = 121
    Height = 21
    ImeName = #20013#25991' ('#31616#20307') - '#24494#36719#25340#38899
    TabOrder = 0
  end
  object Button1: TButton
    Left = 96
    Top = 104
    Width = 75
    Height = 25
    Caption = #23548#20986
    TabOrder = 1
    OnClick = Button1Click
  end
  object Button2: TButton
    Left = 208
    Top = 104
    Width = 75
    Height = 25
    Caption = #20851#38381
    TabOrder = 2
    OnClick = Button2Click
  end
  object ADOConnExcel: TADOConnection
    ConnectionString = 
      'Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security In' +
      'fo=False;Initial Catalog=cjh;Data Source=127.0.0.1'
    Provider = 'SQLOLEDB.1'
    Left = 32
    Top = 64
  end
  object OpenDiaEX: TOpenDialog
    Left = 32
    Top = 24
  end
  object query2: TADOQuery
    Connection = ADOConnExcel
    Parameters = <>
    Left = 80
    Top = 64
  end
end