delphi批量导入数据.docVIP

  • 7
  • 0
  • 约3.1万字
  • 约 25页
  • 2017-05-31 发布于北京
  • 举报
delphi批量导入数据?? 从Excel中导入数据到Access中: procedure TForm5.Button3Click(Sender: TObject); //excel导入 var ? EXLfile:string; ?? sheet,XLApp,workbook : variant; ?? iRow,MaxRow:integer; begin ? if opendialog1.Execute then ? begin ??? EXLfile:=opendialog1.FileName; ??? screen.Cursor:=crHourGlass; ??? try ???? //创建对象 ????? XLApp:=createOleObject(Excel.Application); ????? XLApp.displayAlerts:=false;?? //运行宏时是否显示警告和消息 ????? XLApp.ScreenUpdating:=false;???? //屏幕更新功能,提高速度; ????? XLApp.WorkBooks.Add(EXLfile); ????? workbook := XLApp.workbooks[1]; ????? sheet:=workbook.worksheets[1]; ???? //sheet:=XLApp.WorkBoo

文档评论(0)

1亿VIP精品文档

相关文档