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 ÊÖ¶¯×°ÔØÇý¶¯ÎļþÌáʾ£º
RROR (1058): The driver is marked as disabled (Start=4) in its service database entry.
ÊDz»ÊÇÕâ¸öÇý¶¯±ØÐèÒªÓÃINFÀ´°²×°¡£¡£ÓÃ×Ô´øµÄINFÀ´×°ÊÇÕý³£µÄ¡£ÓÃÊÖ¶¯×°ÔؾÍÌáʾÈçÉÏ¡ ......
³ÌÐòʹÓõÄÊÇOrcalÊý¾Ý¿â£¬Ï붨ÆÚ£¨Ã¿¼¾¶È£©¶ÔÊý¾Ý¿â½øÐб¸·Ý£¬Ã»É¶Í·Ð÷£¬ÇëÎÊÓ¦¸ÃÔõôŪ£¿
ÓÐʲôÌØÊâÒªÇóÂ𣬱ÈÈçҪǰ¶Ë½çÃ棿
Ò»°ãÓÃÊý¾Ý¿â×Ô´øµÄ¡°¼Æ»®ÈÎÎñ¡±ÅäÖÃһϾ͹»ÁË
ûÓÐʲôÌØÊâÒªÇó¡£ÀýÈ磬ֻҪµ ......
ÎÒÊÇDELPHIµÄ³õѧÕߣ¬µ«ÀÏʦҪÇóÎÒÃÇ×ö¿Î³ÌÉè¼Æ£¬´ÓÊé±¾ÀïÃ濽ÁË´úÂë×Ô¼ºÑо¿£¬µ«ÀÏÊdzöÎÊÌ⣬ÓÐËÊÇÕâ·½ÃæµÄ¸ßÊÖ°¡£¬ÄÜ·ñÁôϸöÁªÏµµÄ·½Ê½°ï°ïæ°¡
³öʲôÎÊÌ⣬Çë¾ßÌå˵Ã÷
·¢ÏÖ¡¢½â¾öÎÊÌâµÄ¹ý³Ì¾ÍÊÇѧϰµÄ¹ý³Ì
......
1.ÎÒ²»»áÓ¢Óï,ÏÂÔØÁ˸ödelphi2010,´ò¿ªÒÔºóÀïÃæÈ«²¿ÊÇÓ¢Óï,Á¬°ïÖúÎļþÒ²ÊÇÓ¢Óï,ÓÐûÓкº»¯°æµÄ?
2.ÏÂÃæÊÇ×°delphi2010µÄʱºò×°½øÀ´µÄ,Âé·³½âÊÍÕâЩÊÂʲô
Embarcadero Delphi and C++ Builder 2010 Database Pack ......
ÎÒÊÇÐÂÊÖÏ£Íû´ó¼ÒôÅç¡£¡£
¾ÍÊÇÏëÎÊһϠ¹ØÓÚIDEµÄÎÊÌâ··
ÕÒÁ˺þ㬾ÍÊÇûÕÒÈ«¡£
Ï£Íû´ó¸çÃÇÌṩһϹþ¡£¡£¡£¡£
лл··
ÄãÏëÎÊIDEµÄʲôÎÊÌâ
¿ÉÒÔ¾ßÌ嵽ʲôÎÊÌâÂï
ÏÖÔÚµÄͬѧÌáÎ ......