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

delphi ÐÂÔösheetÎÊÌâ - Delphi / VCL×é¼þ¿ª·¢¼°Ó¦ÓÃ

ÈçºÎʹÐÂÔöµÄsheetÔÚǰһ¸ösheetºó£¬excelĬÈÏÓÐ3¸ösheet,ÈçÎÒÐÂÔöÒ»¸ösheet4,ÔõÑùʹËüÊDzåÔÚsheet3ºóÄØ£¬¶ø²»ÊDzåÔÚsheet1ǰ£¿
ÓÒ¼ü²»ÐÐÂð£¿

Worksheets.Add ·½·¨ 

¸Ã·½·¨ÓÃÓÚн¨¹¤×÷±í¡£

Function Add([Before As VARIANT], [After As VARIANT], [Count As VARIANT], [Type As VARIANT]) As LPDISPATCH 
²ÎÊý˵Ã÷
Before 
Variant ÀàÐÍ£¬¿ÉÑ¡¡£Ö¸¶¨¹¤×÷±í¶ÔÏó£¬Ð½¨µÄ¹¤×÷±í½«ÖÃÓڴ˹¤×÷±í֮ǰ¡£

After 
Variant ÀàÐÍ£¬¿ÉÑ¡¡£Ö¸¶¨¹¤×÷±í¶ÔÏó£¬Ð½¨µÄ¹¤×÷±í½«ÖÃÓڴ˹¤×÷±íÖ®ºó¡£

Count 
Variant ÀàÐÍ£¬¿ÉÑ¡¡£ÒªÐ½¨µÄ¹¤×÷±íµÄÊýÄ¿¡£Ä¬ÈÏֵΪ 1¡£

·µ»ØÖµ

Object ÀàÐÍ


˵Ã÷
Èç¹û Before ºÍ After Á½Õß¾ùÊ¡ÂÔ£¬Ôòн¨µÄ¹¤×÷±í½«²åÈëµ½»î¶¯¹¤×÷±í֮ǰ¡£

ÑùÀý

' ±¾Ê¾ÀýÏò¹¤×÷²¾ÖÐÌí¼ÓÁ½¸ö¹¤×÷±í¡£
Sub Worksheets_Add()
  ThisWorkbook.Worksheets.Add Count:=2
End Sub



´óÌå´úÂëÈçÏ£º
Delphi(Pascal) code:

try
Self.ExcelApplication1:=TExcelApplication.Create(Self);
Self.ExcelApplication1.Connect;
except
messagebox(application.Handle,'ÎÞ·¨Éú³ÉExcel±¨±í£¬ÇëÈ·¶¨°²×°ÁËExcelºóÖØÊÔ','ÐÅÏ¢',mb_ok or mb_iconinformation);
exit;
end;

Self.ExcelApplication1.Visible[0]:=False;
Self.ExcelApplication1.DisplayAlerts[0]:=False;
self.ExcelApplic


Ïà¹ØÎÊ´ð£º

DELPHIÕâÖÖÇé¿öÔõô°ì£¿ - Delphi / Windows SDK/API

¾ÍÊÇÒ»¸ö·þÎñ¶ËºÍÒ»¸ö¿Í»§¶Ë£¬Àï±ßÓÐһЩ¹²Óõ¥Ôª £¬ÎÒÔÚ ¹¤³ÌµÄSEARCH PATHÀïÉèÖõÄ·¾¶£¬
Àï±ßÓиö½á¹¹Ì壬ÎÒÔÚ·þÎñ¶Ë´ò¿ª£¬¼ÓÁ˳ÉÔ±£¬µ«ÊÇÎÒÔÚ¿Í»§¶ËÆäËûµ¥Ôª·ÃÎʲ»µ½ÎÒмӵģ¬ÎÒÔÚ¿Í»§¶Ë´ò¿ªÄǸöµ¥Ôª£¬È·Êµ¼ÓÁ ......

delphiÊéд¸ñÔò? - Delphi / ·Ç¼¼ÊõÇø

ÔÚÍøÉÏ¿´µ½ºÜ¶àÈËд³ÌÐò´úÂë,дµÄ´úÂëÿһÐж¼ÊÇҪô¾Í¿ÕÒ»¸ö¿Õ¸ñ,Ҫô¾Í¿ÕºÃ¼¸¸ö,Õâ¸öÓй涨Âð?Ôõô¿´?
ÒÔÏÂÊÇÎÒÔÚÍøÉÏÕÒµÄÒ»¶Î³ÌÐò´úÂë
===================================================================== ......

delphiµ÷ÓÃocx - Delphi / ÍøÂçͨÐÅ/·Ö²¼Ê½¿ª·¢

СµÜÏëÓÃdelphi×öÒ»¸ö²¦ºÅ³ÌÐò£¬½«µçÐŵÄÒÆ¶¯¹Ì»°ÓÃUSBÁ¬µ½µçÄÔÉÏ£¬Í¨¹ý±àдµÄ²¦ºÅ³ÌÐòÔÚµçÄÔÉϲ¦´òµç»°¡£
ÏÖÔÚÓÐÖÐÐ˵ÄocxºÍdll²å¼þ£¬½Ó¿Ú˵Ã÷Ò²¸øÁË¡£µ«ÊÇÒòΪûÓÐÕâ·½ÃæµÄ¾­Ñ飬Çë¸÷λ´óÏÀ¸øÓèÖ¸µã¡£Íò·Ö¸Ðл¡£¾ ......

delphi ûÓÐÖ´ÐнçÃæ²»ÏÔʾ - Delphi / ·Ç¼¼ÊõÇø

ÎÒÔÚÖ´ÐÐDelphi2010µÄʱºò£¬Ã»ÓгöÏÖÖ´ÐеĽçÃæ£¬Çó¸ßÊÖ°ïæ£¬Ð»Ð»


End_rbody_65722921//-->
¸Ã»Ø¸´ÓÚ2010-05-26 08:24:26±»°æÖ÷ɾ³ý


¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TO ......

¹ØÓÚÓÃdelphiÖÐadoÁ¬½ÓoracleµÄÎÊÌâ - Oracle / ¿ª·¢

ÈçÌâ¡£
ÓÃadoconnectionÁ¬½Óoracle,²âÊÔÁ¬½Ó³É¹¦  
  ÓÃÒ»adotable¿Ø¼þ£¬ÉèÖÃÆäconnectionΪ¸Õ¸ÕÁ¬½Ó³É¹¦µÄadoconnection  
  µ«ÊÇÑ¡ÔñtablenameÊôÐÔµÄʱºòÌáʾ£¬Êý¾ÝÌṩÕß»òÆäËü·þÎñ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ