¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD |
µoªí¤H |
¤º®e |
±i¯qºa
µù¥U®É¶¡: 2005-01-04 ¤å³¹: 2
²Ä 1 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤@¤ë 04, 2005 5:36 pm ¤å³¹¥DÃD: ½Ð°Ý¦p¦óקïFormùرªºMicrosoft Excel¹Ïªíªº¸ê®Æ |
|
|
§Ú¼g¤@ÓForm,±NMicrosoft Excel¹Ïªí¥[¤JForm¤¤,
¦ý«oµLªk§ïÅÜ¸Ó¹Ïªí¤ºªº¼ÆÈ,
½Ð¦U¦ìÀ°À°¦£...
·PÁÂ~~~ |
|
¦^³»ºÝ |
|
|
horace
µù¥U®É¶¡: 2004-11-25 ¤å³¹: 36 ¨Ó¦Û: ·s¦Ë
²Ä 2 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤@¤ë 10, 2005 10:35 am ¤å³¹¥DÃD: |
|
|
°²³]±±¨î¶µªº¦WºÙ¬O oleExcel
±±¨î¶µªºExcelªº°Ñ·Ó»Pªk¬OoleExcel.object
¦Ü©óExcelªº¦U¯ÅÄÝ©Ê ½Ð°Ñ¾\ExcelªºVBA®ÑÄy |
|
¦^³»ºÝ |
|
|
±i¯qºa
µù¥U®É¶¡: 2005-01-04 ¤å³¹: 2
²Ä 3 ¼Ó
|
µoªí©ó: ¬P´Á¤T ¤@¤ë 12, 2005 12:18 pm ¤å³¹¥DÃD: |
|
|
·PÁÂ~~~
Á`ºâ¦¨¥\¤F..
´£¨Ñ¥H¤Uªº¤è¦¡:
*** קïEXCEL ¤u§@ªíªºÈ ***
thisform.olecontrol1.worksheets("sheet1").cells(2,2) = 100
*** Åܧó¹Ï§Î ***
thisform.olecontrol1.activechart.charttype = 5 |
|
¦^³»ºÝ |
|
|
214152
µù¥U®É¶¡: 2005-08-24 ¤å³¹: 19 ¨Ó¦Û: ¥x«n
²Ä 4 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤T¤ë 21, 2006 11:53 am ¤å³¹¥DÃD: |
|
|
DEAR ±i¯qºa:
§Ú·Ó§Aªº¤èªk: thisform.olecontrol1.worksheets("sheet1").cells(2,2) = 100
½T¥X²{ .....UNKNOW NAME.
¥i¥H§i¶D§Ú¬°¦ó¶Ü?
TKS.
amigo.rdchang@gmail.com _________________ scott |
|
¦^³»ºÝ |
|
|
ù´ÂÙy
µù¥U®É¶¡: 2003-06-21 ¤å³¹: 20 ¨Ó¦Û: ªá½¬
²Ä 5 ¼Ó
|
µoªí©ó: ¬P´Á¤é ¤T¤ë 04, 2007 12:28 pm ¤å³¹¥DÃD: Microsoft Excel¹Ïªí¦p¦ó§ïÅÜ¹Ïªí¤§¸ê®Æ½d³ò,¦A«·s¨q¹Ïªí!! |
|
|
Microsoft Excel¹Ïªí¥i¥H§ïÅÜ¹Ïªí¤ºªº¼ÆȤΨq¹Ïªí,¦ý¦p¦ó
¨Ì¶·»Ý¨D¥iÀH®É«ü©w¹Ïªí¤§¸ê®Æ½d³ò,Åý¹Ïªí«·s²Îp?
½Ð¥ý¶iÌÀ°¦£,·PÁÂ!! |
|
¦^³»ºÝ |
|
|
garfield Site Admin
µù¥U®É¶¡: 2003-01-30 ¤å³¹: 2157
²Ä 6 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤T¤ë 06, 2007 8:38 am ¤å³¹¥DÃD: |
|
|
³q±`excelªºµ{¦¡¥\¯à°ÝÃD³£¥u»Ýn¦bExcel¸Ì¿ý¥¨¶°,
¦A±N¥¦Âনvfp»yªk§Y¥i,
"§A¤µ¤Ñ¿ý¤F¨S" . _________________ §Q¥Î>>·j´M<<ªº¥\¯à·|¤ñ°ÝªºÁÙn§Ö±o¨ìµª®×. |
|
¦^³»ºÝ |
|
|
ezpos
µù¥U®É¶¡: 2011-04-20 ¤å³¹: 323
²Ä 7 ¼Ó
|
µoªí©ó: ¬P´Á¤» ¤C¤ë 18, 2015 10:20 am ¤å³¹¥DÃD: |
|
|
§Ú¤]¹J¨ì¬Û¦P°ÝÃD
¦p¦óÀH®É«ü©w¹Ïªí¤§¸ê®Æ½d³ò,Åý¹Ïªí«·s²Îp?
thisform.ole1.Range("A4:H23").Select
³o¬qµ{¦¡½X·|¥X¿ù
³o¬qµ{¦¡½X,¬O§Ú ¬Ý excel¥¨¶° ªº¨Óªº _________________ ezPos¦¬»È¾÷ ²³æ¦n¥Î§C¦¨¥» http://www.ezpos.info
¥þ·s¬üÆ[ªºPOS¦¬»È¾÷.POS³nµwÅé¯Ó§÷.
³nÅé«È¨î¤Æ.ºô¯¸³W¹º....¯àÁÈ¿úªº³£¥i¥H§ä§Ú
http://www.twelife.com ¥xÆW¥Í¬¡ºô |
|
¦^³»ºÝ |
|
|
perry
µù¥U®É¶¡: 2014-07-20 ¤å³¹: 203
²Ä 8 ¼Ó
|
µoªí©ó: ¬P´Á¤» ¤C¤ë 18, 2015 11:07 am ¤å³¹¥DÃD: |
|
|
1.Y²Õ¼Æ¤£ÅÜ,½Õ¾ã x ¶b ³Ì¤jÈ 20 = 20 µ§¸ê®Æ
¥D¨è«×¤Î¦¸¨è«×§¡³] 1
2.chartobjects(1).chart.setsourcedata(range('a4:h23'),1) &&ª½±µ³]¸ê®Æ½d³ò
¦bvfpªí³æ¤¤»yªk½d¨Ò¦p¤U:
thisform.olecontrol1.sheets(1).chartobjects(1).chart.setsourcedata(thisform.olecontrol1.sheets(2).range('a1:d4'),1)
sheets(1) ->¦b Excel ¤¤±Æ¦b²Ä1Ó¦ì¸mªº¸Õºâªí¦Ó¤£¬O¦WºÙ sheet1 |
|
¦^³»ºÝ |
|
|
ezpos
µù¥U®É¶¡: 2011-04-20 ¤å³¹: 323
²Ä 9 ¼Ó
|
µoªí©ó: ¬P´Á¤é ¤C¤ë 19, 2015 11:26 am ¤å³¹¥DÃD: |
|
|
·PÁ§A....
§Ú¥Îªº¤èªk¬O
oleApp.Charts.Add
oleApp.ActiveChart.setsourcedata(oleApp.sheets(2).range("B4:H"+ALLTRIM(STR(ii))))
oleApp.ActiveChart.ChartType =4 _________________ ezPos¦¬»È¾÷ ²³æ¦n¥Î§C¦¨¥» http://www.ezpos.info
¥þ·s¬üÆ[ªºPOS¦¬»È¾÷.POS³nµwÅé¯Ó§÷.
³nÅé«È¨î¤Æ.ºô¯¸³W¹º....¯àÁÈ¿úªº³£¥i¥H§ä§Ú
http://www.twelife.com ¥xÆW¥Í¬¡ºô |
|
¦^³»ºÝ |
|
|
ezpos
µù¥U®É¶¡: 2011-04-20 ¤å³¹: 323
²Ä 10 ¼Ó
|
µoªí©ó: ¬P´Á¤é ¤C¤ë 19, 2015 11:27 am ¤å³¹¥DÃD: |
|
|
½Ð°Ý¤j¤j
¦p¦ó³]©w¨ä¤¤¤@±ø½u...¥Lªº¼Æ¾Ú Åã¥Ü¤T¨¤ÂI _________________ ezPos¦¬»È¾÷ ²³æ¦n¥Î§C¦¨¥» http://www.ezpos.info
¥þ·s¬üÆ[ªºPOS¦¬»È¾÷.POS³nµwÅé¯Ó§÷.
³nÅé«È¨î¤Æ.ºô¯¸³W¹º....¯àÁÈ¿úªº³£¥i¥H§ä§Ú
http://www.twelife.com ¥xÆW¥Í¬¡ºô
ezpos ¦b ¬P´Á¤é ¤C¤ë 19, 2015 11:36 am §@¤F²Ä 1 ¦¸×§ï |
|
¦^³»ºÝ |
|
|
perry
µù¥U®É¶¡: 2014-07-20 ¤å³¹: 203
²Ä 11 ¼Ó
|
µoªí©ó: ¬P´Á¤é ¤C¤ë 19, 2015 11:36 am ¤å³¹¥DÃD: |
|
|
°õ¦æ®É´Á olecontrol1.AutoActivate=0
¥u¯à¬Ý¤£¯à½s¿è
±zªº¤£¾A¥Î³sÄò¦C¦L!! |
|
¦^³»ºÝ |
|
|
ezpos
µù¥U®É¶¡: 2011-04-20 ¤å³¹: 323
²Ä 12 ¼Ó
|
µoªí©ó: ¬P´Á¤é ¤C¤ë 19, 2015 12:00 pm ¤å³¹¥DÃD: |
|
|
·PÁ¤j¤j
°²¤é¸ÑµªºÃ´b
§Ú¥»¨Ó¥Î¤@Ӳ¤èªk ³z©ú¤è¶ôªº
§ï¥Î §Aªº¤èªk ¯u¬O¦n.... _________________ ezPos¦¬»È¾÷ ²³æ¦n¥Î§C¦¨¥» http://www.ezpos.info
¥þ·s¬üÆ[ªºPOS¦¬»È¾÷.POS³nµwÅé¯Ó§÷.
³nÅé«È¨î¤Æ.ºô¯¸³W¹º....¯àÁÈ¿úªº³£¥i¥H§ä§Ú
http://www.twelife.com ¥xÆW¥Í¬¡ºô |
|
¦^³»ºÝ |
|
|
perry
µù¥U®É¶¡: 2014-07-20 ¤å³¹: 203
²Ä 13 ¼Ó
|
µoªí©ó: ¬P´Á¤é ¤C¤ë 19, 2015 2:33 pm ¤å³¹¥DÃD: |
|
|
XLSHEET1.CHARTOBJECTS(1).CHART.SeriesCollection(1).MarkerStyle=3 &&¤T¨¤§Î
MarkerBackgroundColor=rgb() &&I´º
MarkerForegroundColor=rgb() &&«e´º |
|
¦^³»ºÝ |
|
|
ezpos
µù¥U®É¶¡: 2011-04-20 ¤å³¹: 323
²Ä 14 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤C¤ë 20, 2015 8:54 am ¤å³¹¥DÃD: |
|
|
¦¤W´ú¸Õµo²{
¨Ï¥Îoffice Excel ¤u§@ªí
¦bXP ¤W °õ¦æ®É ·|¥X¿ù...²q·Q¬Ooffice 2003ª©¥»
§Úªº¶}µoÀô¹Ò¬Owin8.office 2008
§ï¥Î office Excel 2003-2007 ¤u§@ªí ±±¨î¶µ
«oµo²{¨Ï¥Î ¥H¤U«ü¥O...Åܦ¨¨S¦³§@¥Î
Thisform.container2.ole1.Top=5
Thisform.container2.ole1.Left=5
Thisform.container2.ole1.Width=Thisform.container2.Width -10
Thisform.container2.ole1.Height=Thisform.container2.Height -10
²£¥Íªº²Îpªí...ÁY¦b¤@¹Î¤W±¤F..... _________________ ezPos¦¬»È¾÷ ²³æ¦n¥Î§C¦¨¥» http://www.ezpos.info
¥þ·s¬üÆ[ªºPOS¦¬»È¾÷.POS³nµwÅé¯Ó§÷.
³nÅé«È¨î¤Æ.ºô¯¸³W¹º....¯àÁÈ¿úªº³£¥i¥H§ä§Ú
http://www.twelife.com ¥xÆW¥Í¬¡ºô |
|
¦^³»ºÝ |
|
|
perry
µù¥U®É¶¡: 2014-07-20 ¤å³¹: 203
²Ä 15 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤C¤ë 20, 2015 9:59 pm ¤å³¹¥DÃD: |
|
|
Ó¤H¥u¦³ offices 2003 & VFP 6.0 = ='''
¥u¬O«Ü³æ¯Â¥Î VFP & Excel
Ole , WinApi ... ·|¨ü M$ §ïª©¼vÅT¨ìªºªFªF¤@«ß±Ë±ó¤£¥Î@@
¸Õ¸Õ¤U±³oÓ
thisform.container2.ole1.stretch=1 &&µ¥¤ñ¨Ò¥R¶ñ |
|
¦^³»ºÝ |
|
|
|