ÒÔÏÂÊDzâÊÔ´úÂ룺
Set o_EXL = CreateObject("Excel.application")
Set o_EBKs = o_EXL.workbooks
If Dir(pÎļþÃû) <> "" Then
o_EXL.Visible = False
o_EXL.displayalerts = False
Set oeb = o_EBKs.Open(pÎļþÃû)
Set osheets = oeb.worksheets
......
ÈçÌâ.Ôõô¶ÁÈ¡Êý¾Ý¿âÖÐ×ֶβ»Îª¿ÕµÄÐÅÏ¢?
ÎÒÏë¶ÁÈ¡Êý¾Ý¿âÖÐͼƬһÀ¸²»Îª¿ÕµÄ¼Ç¼
SQL="select * from info where img not isnull"
ûÓб¨´í.µ«ÊÇËü°ÑËùÓеͼ¶Á³öÀ´ÁË.ûÓÐͼƬµÄÒ²¶Á³öÀ´ÁË..
SQL code:
select * from info where img is not isnull
SQL code:
select * from info where img is not ......
Çë½Ì£º
±íA½á¹¹ÈçÏ£ºID StartTime EndTime
1 2010/4/2 9:00:00 2010/4/2 11:00:00
2 2010/4/2 12:00:00 2010/4/2 14:00:00
. ... ...
ÏÖÎÒÓµÓÐÁ½¸öʱ¼ä±äÁ¿a,b£¬ÔõÑù²éѯ¿ÉÒÔµ ......
ÏÖÔÚÏë×öÒ»¸ö½øÏú´æ,¿ÉÄÜ»áÓÐ20ÈËͬʱһÆðÓÃ
²»ÖªµÀµ½ÊÇÑ¡Ôñ sqlite »¹ÊÇ access
´ó¼Ò¸ø¸øÒâ¼û°É
»¹ÊÇÓÃaccess°É£¬ÒòΪÄã¿Ï¶¨ÊÇÓÃ.net¿ª·¢£¬³öÁËʲôÎÊÌâµÄ»°ºÃ½â¾öһЩ¡£
Èç¹ûÓÃsqlite×ÊÁÏÏà¶Ô±È½ÏÉÙ¡£
²»¹ýÌý˵Õâ¸öÊý¾Ý¿â²»´í£¬Ö®Ç°ÍæPythonµÄdjangoµÄʱºò¸ã¹ýһϡ£Ó¦¸ÃÒ²²»´íµÄ¡£
System.Data.SQLite
An open ......
±àдһ¸ö´æ´¢¹ý³Ì
ÊäÈëÒ»¸ö projectid µÃµ½ ProjectInfo ÖÐ ×îеÄÒ»ÌõÐÅÏ¢
±íÈçÏ£º
PersonInfo ProjectInfo
PersonId PersonName ProjectId ProjectPersons Project_time
1 zhanshan 1 1£¬2£¬3 2 ......
СµÜ×î½ü×öÁ˼¸¸ö·þÎñ ·þÎñÔËÐÐÐèҪһЩ²ÎÊý ²ÎÊýÊÇͨ¹ýÒ»¸ö³ÌÐò½çÃæÐÞ¸ÄµÄ ²ÎÊý±£´æÔÚaccessÊý¾Ý¿âÖÐ ÏÖÔÚ³öÏÖÒ»ÁéÒìÏÖÏó µ¥¶ÀµÄ·þÎñÊÇ¿ÉÒÔ½øÐпØÖƵ썷þÎñµÄÍ£Ö¹ ÔÝÍ£µÈµÈ£©µ«ÊǶà¸ö·þÎñÒ»Æð¿ªÆô»á³öÏÖÒ»·þÎñ¿ªÆôºó ³ÌÐòÎÞÏàÓ¦µÄ״̬ ÆÚ´ý¸ßÊÖÄܹ»·ÖÎö£¡
°æÖ÷ÌùÖ÷ÔçÉϺã¡
°æÖ÷ÌùÖ÷ÿÌì¶¼ÓкÃÐÄÇ飡
qFmN2KbDndC»ØÌ ......