µ±Ç°Î»Öà : 145zÓÎÏ·Õ¾¡¡|¡¡ÈÈѪ´«Ææ¡¡|¡¡¼¼Êõ½Ì³Ì¡¡|¡¡

´«ÆæHAOM2ôá·ç¸üÐÂÁËCSV±í¸ñ¶ÁȡΪ³£Á¿ÐÎʽ½øÐвÙ×÷£¡

Èȶȣº
´«ÆæHAOM2ôá·ç×îиüÐÂÁ˶ÔCSV±í¸ñµÄ¶ÁÈ¡·½Ê½£¬Ö§³Ö½«CSV±í¸ñ¶ÁȡΪ³£Á¿ÐÎʽ½øÐвÙ×÷£¬²¢Ôö¼ÓÁËCSV½Ó¿Ú¼°Ïà¹ØÃüÁî¡£ÕâЩ¸üн«Ê¹¿ª·¢ÕßÄܹ»¸ü¼Ó·½±ãµØ²Ù×÷CSV±í¸ñ£¬Ìá¸ß¿ª·¢Ð§ÂÊ¡£

еÄCSV½Ó¿Ú¼°Ïà¹ØÃüÁî°üÀ¨£º

CSVOpenCache£º½«CSV±í¸ñ¼ÓÔØµ½ÄÚ´æÖУ¬Ö§³ÖÈȼÓÔØ£¬ÐÞ¸ÄÎļþºó¿ÉʹÓÃCSVOpenCacheÖØÐ¼ÓÔØÎļþÃüÁî¸üлº´æÄÚÈÝ¡£
CSVGetCellInfo£º»ñÈ¡CSVÎļþµÄ×î´óÐÐÊýºÍ×î´óÁÐÊý¡£
CSVGetCellText£º¶ÁÈ¡µ¥Ôª¸ñµÄÄÚÈÝ¡£
CSVFindTextRow£º²éÕÒÄÚÈݳöÔÚµÚ¼¸ÐС£
ÕâЩÐÂÃüÁʹ¿ª·¢ÕßÄܹ»¸ü¼Ó·½±ãµØ²Ù×÷CSV±í¸ñ£¬Ìá¸ß¿ª·¢Ð§ÂÊ¡£

ÒÔÏÂÊÇÒ»¸öʾ·¶½Å±¾£¬ÑÝʾÁËÈçºÎʹÓÃÕâЩÐÂÃüÁ

[@²âÊÔ]
#act
;CSVOpenCache ..\\QuestDiary\\Test.csv
CSVGetCellInfo ..\\QuestDiary\\Test.csv N$×ÜÐÐÊý N$×ÜÁÐÊý
Mov N$ÐÐÊý 0
While N$ÐÐÊý < N$×ÜÐÐÊý
CSVGetCellText ..\\QuestDiary\\Test.csv <$STR(N$ÐÐÊý)> 0 S0
CSVGetCellText ..\\QuestDiary\\Test.csv <$STR(N$ÐÐÊý)> 1 S1
CSVGetCellText ..\\QuestDiary\\Test.csv <$STR(N$ÐÐÊý)> 2 S2
Sendmsg 6 [<$STR(N$ÐÐÊý)>,0]<$STR(S0)>;[<$STR(N$ÐÐÊý)>,1]<$STR(S1)>;[<$STR(N$ÐÐÊý)>,2]<$STR(S2)>;
Inc N$ÐÐÊý 1
EndWhile
CSVFindTextRow ..\\QuestDiary\\Test.csv 1.25±¶ 0~10 2 0 N0
Sendmsg 6 "1.25±¶"ÔÚ<$STR(N0)>ÐÐ,µÚ2ÁÐÖÐ

;--------------------------------------------------------

;±í¸ñÄÚÈÝ×÷Ϊ³£Á¿½øÐлñÈ¡£¬½ö¶ÔCSVOpenCacheµÄ¿ÉÓÃ...
;¶Áȡʱ»áÒѳ£Á¿ÐÎʽ´æ·ÅÔÚÄÚ´æÖÐ(Èç¹û²»¾­³£¸ü¸ÄµÄÇé¿öϽ¨Òé·ÅÔÚQMµÄ[@Startup]Æô¶¯´¥·¢Ö´ÐÐ)
;ÐÞ¸ÄCSVÎļþºó¿ÉʹÓÃCSVOpenCacheÖØÐ¼ÓÔØÎļþÃüÁî¸üлº´æÄÚÈÝ
;ͨ¹ýÒÔÏÂÈ¥¶ÁÏà¹ØÄÚ´æÖеıí¸ñ³£Á¿Öµ

[@²âÊÔ]
#act
CSVOpenCache ..\\QuestDiary\\Test.csv
SendMsg 7 TEST±í¸ñÄÚµÚÒ»ÐеڶþÁÐֵΪ£º<$TEST(1,2)>
Mov S1 <$TEST(1,2)>
SendMsg 5 1ÐÐ2ÁеÄֵΪ£º<$STR(S1)> <$TEST(1,2)>
Copy
ÔÚÕâ¸öʾ·¶½Å±¾ÖУ¬ÎÒÃÇÊ×ÏÈʹÓÃCSVOpenCacheÃüÁî¼ÓÔØÁËTest.csv±í¸ñµ½ÄÚ´æÖС£È»ºó£¬ÎÒÃÇʹÓÃCSVGetCellInfoÃüÁî»ñÈ¡Á˱í¸ñµÄ×î´óÐÐÊýºÍ×î´óÁÐÊý£¬²¢Ê¹ÓÃCSVGetCellTextÃüÁî¶ÁÈ¡Á˱í¸ñÖеĵ¥Ôª¸ñÄÚÈÝ¡£×îºó£¬ÎÒÃÇʹÓÃCSVFindTextRowÃüÁî²éÕÒÁ˱í¸ñÖеÄÌØ¶¨ÄÚÈÝ¡£

Ôö¼ÓÁËCSV½Ó¿Ú¼°Ïà¹ØÃüÁî,¸üÐÂÁËÖ§³ÖCSVΪ³£Á¿ÐÎʽ½øÐвÙ×÷,À©Õ¹ÁËCSVOpenCache¼ÓÔØ±í¸ñµ½ÄÚ´æÖ§³ÖÈȼÓÔØ ¼ÓÔØcsv±í¸ñÄÚÈݵ½ÄÚ´æÖÐCSVOpenCache Îļþ·¾¶ ÐÞ¸ÄÎļþºó¿ÉʹÓÃCSVOpenCacheÖØÐ¼ÓÔØÎļþÃüÁî¸üлº´æÄÚÈÝ

¹¦ÄÜ˵Ã÷: CSV±í¸ñ¶ÁÈ¡ CSVÏà¹ØÃüÁî
;-------------------------------------------
;½«ÎļþÉèÖÃΪ»º´æ£¬Ä³Ò»ÎļþÖ´ÐдËÃüÁîºó£¬ËùÓеIJÙ×÷¶¼ÊÇ»º´æ²Ù×÷£¨²»Ê¹Óûº´æÃüÁî¶ÁÈ¡µÄÎļþ¿ÉÒÔʵʱ²Ù×÷£©
;Èç¹û²»¾­³£¸ü¸ÄµÄÇé¿öϽ¨Òé·ÅÔÚQMµÄ[@Startup]Æô¶¯´¥·¢Ö´Ðлº´æÃüÁ¿É¼Ó¿ì½Å±¾ÔËÐÐËÙ¶ÈÓëЧÂÊ
;ÐÞ¸ÄÎļþºó¿ÉʹÓÃCSVOpenCacheÖØÐ¼ÓÔØÎļþÃüÁî¸üлº´æÄÚÈÝ

¼ÓÔØcsv±í¸ñÄÚÈݵ½ÄÚ´æÖÐ
CSVOpenCache Îļþ·¾¶

;-------------------------------------------
»ñÈ¡CSVÎļþµÄ×î´óÐÐÊýºÍ×î´óÁÐÊý
CSVGetCellInfo Îļþ·¾¶ ×î´óÐÐÊý±£´æ±äÁ¿ ×î´óÁÐÊý±£´æ±äÁ¿

¶ÁÈ¡µ¥Ôª¸ñµÄÄÚÈÝ
CSVGetCellText Îļþ·¾¶ ÐÐÊý ÁÐÊý ±£´æ±äÁ¿

²éÕÒÄÚÈݳöÔÚµÚ¼¸ÐÐ
CSVFindTextRow Îļþ·¾¶ ×Ö·û´® ¿ªÊ¼ÐÐ~½áÊøÐÐ ÁÐÊý(´ÓµÚ¼¸ÁвéÕÒ) 0/1(0:¿ªÊ¼³öÏÖµÄÐУ»1:×îºó³öÏÖµÄÐÐ) ±£´æ±äÁ¿

--------------------------------------------------------------

ÏÂÃæÊ¾·¶½Å±¾µÄTest.csvÄÚÈÝ

; ±¸×¢·ûºÅ£¬¶Áȡʱ»áºöÂÔ´ËÐÐ
; תÉúµÈ¼¶,µ±Ç°ÊôÐÔ,ϼ¶ÊôÐÔ,ÐèÇó²ÄÁÏ
0,µ±Ç°¹¥»÷1.05±¶,1.10±¶,תÉú¾§Ê¯,1
1,µ±Ç°¹¥»÷1.10±¶,1.15±¶,תÉú¾§Ê¯,2
2,µ±Ç°¹¥»÷1.15±¶,1.20±¶,תÉú¾§Ê¯,3
3,µ±Ç°¹¥»÷1.20±¶,1.25±¶,תÉú¾§Ê¯,4
4,µ±Ç°¹¥»÷1.25±¶,1.30±¶,תÉú¾§Ê¯,5
5,µ±Ç°¹¥»÷1.30±¶,1.35±¶,תÉú¾§Ê¯,6

-------------------------------------------------------------

;ʾ·¶½Å±¾

[@²âÊÔ]

#act
;CSVOpenCache ..\QuestDiary\Test.csv
CSVGetCellInfo ..\QuestDiary\Test.csv N$×ÜÐÐÊý N$×ÜÁÐÊý
Mov N$ÐÐÊý 0
While N$ÐÐÊý < N$×ÜÐÐÊý
CSVGetCellText ..\QuestDiary\Test.csv <$STR(N$ÐÐÊý)> 0 S0
CSVGetCellText ..\QuestDiary\Test.csv <$STR(N$ÐÐÊý)> 1 S1
CSVGetCellText ..\QuestDiary\Test.csv <$STR(N$ÐÐÊý)> 2 S2
Sendmsg 6 [<$STR(N$ÐÐÊý)>,0]<$STR(S0)>;[<$STR(N$ÐÐÊý)>,1]<$STR(S1)>;[<$STR(N$ÐÐÊý)>,2]<$STR(S2)>;
Inc N$ÐÐÊý 1
EndWhile
CSVFindTextRow ..\QuestDiary\Test.csv 1.25±¶ 0~10 2 0 N0
Sendmsg 6 "1.25±¶"ÔÚ<$STR(N0)>ÐÐ,µÚ2ÁÐÖÐ

;--------------------------------------------------------

;±í¸ñÄÚÈÝ×÷Ϊ³£Á¿½øÐлñÈ¡£¬½ö¶ÔCSVOpenCacheµÄ¿ÉÓÃ...
;¶Áȡʱ»áÒѳ£Á¿ÐÎʽ´æ·ÅÔÚÄÚ´æÖÐ(Èç¹û²»¾­³£¸ü¸ÄµÄÇé¿öϽ¨Òé·ÅÔÚQMµÄ[@Startup]Æô¶¯´¥·¢Ö´ÐÐ)
;ÐÞ¸ÄCSVÎļþºó¿ÉʹÓÃCSVOpenCacheÖØÐ¼ÓÔØÎļþÃüÁî¸üлº´æÄÚÈÝ
;ͨ¹ýÒÔÏÂÈ¥¶ÁÏà¹ØÄÚ´æÖеıí¸ñ³£Á¿Öµ

[@²âÊÔ]
#act
CSVOpenCache ..\QuestDiary\Test.csv
SendMsg 7 TEST±í¸ñÄÚµÚÒ»ÐеڶþÁÐֵΪ£º<$TEST(1,2)>
Mov S1 <$TEST(1,2)>
SendMsg 5 1ÐÐ2ÁеÄֵΪ£º<$STR(S1)> <$TEST(1,2)>