unit1.dfm

指定格式導入excel,指定格式導入excelm

object Form1: TForm1
  Left = 323
  Top = 133
  Width = 369
  Height = 287
  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 DBGrid1: TDBGrid
    Left = 8
    Top = 8
    Width = 345
    Height = 193
    DataSource = DataSource1
    TabOrder = 0
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
  end
  object Button1: TButton
    Left = 96
    Top = 224
    Width = 137
    Height = 25
    Caption = #23548#20986#20026'EXCEL'#25991#20214
    TabOrder = 1
    OnClick = Button1Click
  end
  object DataSource1: TDataSource
    DataSet = ADOQuery1
    Left = 104
    Top = 16
  end
  object ADOQuery1: TADOQuery
    Active = True
    ConnectionString = 
      'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db.mdb;Persist Secu' +
      'rity Info=False'
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from t')
    Left = 168
    Top = 24
  end
  object SaveDialog1: TSaveDialog
    Filter = 'Excel '#25991#20214'(*.xls)|*.xls|'#25152#26377#25991#20214'(*.*)|*.*'
    Left = 48
    Top = 40
  end
end