Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Excel ÈçºÎµ÷Óà Delphi ±àÒëµÄ Dll Öеĺ¯Êý£¿

ÎÒÏëÓà Delphi ±àд°üº¬º¯ÊýµÄ Dll£¬È»ºóÔÚ Excel VBA µ÷Óá£ÊÔÁ˺ܶà´Î¶¼ÎÞ·¨·µ»ØÕýÈ·µÄ½á¹û¡£
¾ßÌåÈçÏ£º

Delphi7 ÖеIJâÊÔÔ´Â룺

//********************************************************************************************
library XlsExt;
{±È½ÏÁ½ÊýµÄ´óС£¬²¢·µ»Ø½Ï´óÕß}

uses
  SysUtils,
  Classes;

{$R *.res}

var
  SaveExit:Pointer;
procedure LibExit;              //ΪÁ˲»Ê¹Í˳öExcelʱ³öÏÖÒì³£
begin
  ExitProc:=SaveExit;          //»Ö¸´Í˳ö¹ý³ÌÁ´±í
end;

function MyMax(X,Y:SmallInt):SmallInt;stdcall;  //¶¨Ò庯Êý
begin
  try
    if X>Y then MyMax:=X else MyMax:=Y;
  except
    MyMax:=333;                                  //²âÊÔÒì³£´¦Àí£¬¿ÉÊǺÃÏñûÓп´µ½Õâ¸ö½á¹û¡£
  end;
end;

exports                              //º¯ÊýÊä³ö
  MyMax;

begin
  SaveExit:=ExitProc;                //±£´æÍ˳ö¹ý³ÌÁ´±í
  ExitProc:=@LibExit;                //ÉèÖÃLibExitΪÍ˳ö¹ý³Ì


Ïà¹ØÎÊ´ð£º

ÇëÎÊ[Ò»Ö§Î÷Î÷],vbÈçºÎµ÷ÓÃdll(delphi)

ʹÓÃDll Export Viewer¿´µ½dllÓÐ2¸öµ¼³öº¯Êý
º¯ÊýÃû            µØÖ·              Ïà¶ÔÆ«ÒÆµØÖ·      ÐòºÅ    Î ......

ÐèÒª°Ñvb´úÂëת³Édelphi»òVC++µÄ´úÂë¡£

ÔõôʵÏÖdosÏÂrunas×Ô¶¯ÊäÈëÃÜÂë
http://bbs.pfan.cn/post-278076.html
´úÂëÈçÏÂ:
VB code:

Option Explicit
Private Const LOGON_WITH_PROFILE = &H1&
Private Const CREATE_DEFAULT_ERRO ......

delphiÖÐÈçºÎ½«Ò»¸öaccess±íµÄÊý¾Ýµ¼Èëµ½ÁíÒ»¸ö±íÖУ¿

ллÁË¡£×îºÃÓдúÂë
Insert into Table2(field1,field2,...) select value1,value2,... from Table1

insert into ±íÒ» select * from ±í¶þ

Èç¹û×ֶβ»Ò»Ö£¬ÒªÖ¸¶¨×Ö¶Î

insert into ±íÒ»(A,B) se ......

Çë½ÌdelphiÖÐʹÓÃaccessÊý¾Ý¿â½øÐÐÊý¾Ýµ¼ÈëµÄÎÊÌâ

Ïò¸÷λ¸ßÊÖÇóÖú¡£
ÎÒÓÃdelphi2009±àдÁËÒ»¸ö¹ÜÀíϵͳ£¬Ê¹ÓõÄÊÇaccessÊý¾Ý¿â¡£ÏÖÔÚÏëͨ¹ý¶àÈËÒ»Æð¼ÈëÊý¾Ýºó£¬½«Êý¾Ýµ¼³ö£¬µ¼³öµÄÊý¾Ý¿â°üº¬¶à¸öÏàͬµÄ±í¡£ÔÙ½«µ¼³öµÄÊý¾ÝÒÀ´Îµ¼È뵽ͬһ¸öÊý¾Ý¿âµÄÏàͬ±íÖУ¬µ¼Èë ......

is not a valid integer value delphiÎÊÌâ

ÎÒ³¢ÊÔÒ»¸ö idhttp ·ÃÎÊÍøÕ¾Á´½ÓµÄ³ÌÐò
ÔÚÉèÖôúÀí¶Ë¿ÚµÄʱºò³ö´í
±àÒëûÓдíÎó
¾ÍÊÇÔÚÔËÐеÄʱºò ³öÏÖÁË
80 is not a valid integer value µÄÎÊÌâ
ÎÒÒѾ­°Ñ º¯Êý·ÖÀà³öÀ´µÄ port ת»»Îª integer ÁË ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ