User Manual

9-4
!ﻡﺎﻫ
.ﺔﻴﻟﺎﺧ ﺔﻴﻠﺨﻛ CSV ﻒﻠﳌﺍ ﻲﻓ ﺔﻴﻟﺎﳋﺍ ﺕﺎﻧﺎﻴﺒﻟﺍ ﻊﻴﻤﺟ ﻝﺎﺧﺩﺇ ﻢﺘﻳ •
.ﺪﺣﺍﻭ ﺺﻨﻟﺍ ﻂﻳﺮﺷ ﺕﺎﻧﺎﻴﺑ ﺪﻨﺑ ﻰﻠﻋ ﻰﺘﺣ CSV ﻒﻠﻣ ﻯﻮﺘﺣﺍ ﺍﺫﺍ ﺄﻄﳋﺍ ﺙﺪﺤﻳ ﻭ •
ﻒﻠﳌﺍ ﻊﻗﻮﻣ ﻲﻓ ﺽﺮﻌﺗ ﻲﺘﻟﺍ ﺄﻄﳋﺍ ﺔﻟﺎﺳﺭ ﺮﻬﻈﺗ ﻑﻮﺳ ﻭ ،ﺎﻬﻠﻳﻮﲢ ﻦﻜﳝ ﻻ ﺕﺎﻧﺎﻴﺑ ﻰﻠﻋ CSV ﻒﻠﳌﺍ ﻞﻤﺘﺷﺍ ﺍﺫﺍ •
.ﺎﻬﻠﻳﻮﲢ ﻦﻜﳝ ﻻ ﻲﺘﻟﺍ ﺕﺎﻧﺎﻴﺒﻟﺍ ﻉﻮﻗﻭ ﻢﺘﻳ ﺚﻴﺣ (3 ﺩﻮﻤﻋ ،2 ﻒﺻ :ﻝﺎﺜﻣ) CSV
."Invalid Data Size" ﺄﻄﳋﺍ ﺐﺒﺴﺗ ﻑﻮﺳ ﻒﺻ 999 ﻭﺃ ﺩﻮﻤﻋ 26 ﻪﻴﻓ ﺩﻮﺟﻮﳌﺍ CSV ﻒﻠﳌﺍ ﻝﺎﺧﺩﺇ ﺔﻟﻭﺎﺤﻣ •
CSV ﻒﻠﻤﻛ ﻞﺴﻛﻷﺍ ﺕﺎﻳﻮﺘﺤﻣ ﻆﻔﺣ u
.ﻝﻭﺪﳉﺍ ﺕﺎﻳﻮﺘﺤﻣ ﺏﺎﺴﺣ ﺓﺩﺎﻋﻹ 1(FILE)4(RECAL) ﻰﻠﻋ ﻂﻐﺿﺍ ،ﺮﻣﻻﺍ ﺐﻠﻄﺗ ﺍﺫﺍ . 1
ﺪﻛﺄﺗ .CSV ﻒﻠﻣ ﻰﻟﺍ ﻝﻭﺪﳉﺍ ﺕﺎﻳﻮﺘﺤﻣ ﻆﻔﺤﺑ ﻡﻮﻘﺗ ﺎﻣﺪﻨﻋ ﺎﻴﺋﺎﻘﻠﺗ ﺏﺎﺴﳊﺍ ﺓﺩﺎﻋﺇ ﺬﻴﻔﻨﺘﺑ ﻡﻮﻘﻳ ﻻ ﻪﻧﺃ ﻆﺣﻻ •
ﻰﻠﻋ ﻝﻮﺼﺤﻠﻟ ﺮﻈﻧﺃ .(=) ﻱﻭﺎﺴﻳ ﺔﻣﻼﻌﺑ ﺃﺪﺒﺗ ﻲﺘﻟﺍ ،ﺔﻐﻴﺼﻟﺍ ﻰﻠﻋ ﻝﻭﺪﳉﺍ ﻯﻮﺘﺣﺍ ﺍﺫﺍ ﺏﺎﺴﳊﺍ ﺓﺩﺎﻋﺇ ﺬﻴﻔﻨﺗ ﻦﻣ
.(9-9 ﺔﺤﻔﺻ) "ﺔﻴﻠﺧ ﻰﻟﺍ ﺔﻐﻴﺻ ﻝﺎﺧﺩﺇ" ﺕﺎﻣﻮﻠﻌﳌﺍ ﻦﻣ ﺪﻳﺰﻣ
.ﻂﻘﻓ ﺔﻴﺑﺎﺴﳊﺍ ﺔﻴﻠﻤﻌﻟﺍ ﺞﺋﺎﺘﻧ ﻆﻔﺣ ﻢﺘﻳ .
CSV ﻒﻠﳌﺍ ﻰﻟﺍ ﻎﻴﺼﻟﺍ ﻆﻔﲢ ﻻ •
.ﺔﻴﻟﺎﺧ ﺕﺎﻧﺎﻴﺒﻛ ﻝﻭﺪﳉﺍ ﻲﻓ ERROR ﺔﻴﻠﳋﺍ ﺕﺎﻧﺎﻴﺑ ﻊﻴﻤﺟ ﻆﻔﺣ ﻢﺘﻳ •
.1(FILE)5(CSV)2(SA
•
AS) ﻰﻠﻋ ﻂﻐﺿﺍ . 2
.ﺪ
ﹼ
ﻠﺍ ﺭﺎﻴﺘﺧﺍ ﺔﺷﺎﺷ ﺍﺬﻫ ﺮﻬﻈﻳ •
.CSV ﻒﻠﳌﺍ ﻆﻔﺣ ﺪﻳﺮﺗ ﺚﻴﺣ ﺪ
ﹼ
ﻠﺍ ﺮﺘﺧﺍ . 3
."ROOT" ﻞﻴﻠﻈﺘﺑ ﻢﻗ ،ﻞﻴﻟﺪﻟﺍ ﺭﺬﺟ ﻲﻓ CSV ﻒﻠﳌﺍ ﻦﻳﺰﺨﺘﻟ •
ﻢﺛ ﻦﻣ ﻭ ﺏﻮﻠﻄﳌﺍ ﺪ
ﹼ
ﻠﺍ ﻰﻟﺍ ﻞﻴﻠﻈﺘﻟﺍ ﻚﻳﺮﺤﺘﻟ f ﻭ c ﺢﻴﺗﺎﻔﻣ ﻡﺪﺨﺘﺳﺍ ،ﺪﻠﺍ ﻲﻓ CSV ﻒﻠﳌﺍ ﻦﻳﺰﺨﺘﻟ •
.1(OPEN)ﻰﻠﻋ ﻂﻐﺿﺍ
.
1(SA
•
AS) ﻰﻠﻋ ﻂﻐﺿﺍ . 4
.w ﻰﻠﻋ ﻂﻐﺿﺍ ﻢﺛ ﻦﻣ ﻭ ﻒﻠﳌﺍ ﻢﺳﻻ ﻑﺮﺣﺃ ﺔﻴﻧﺎﻤﺛ ﻰﺘﺣ ﻝﺎﺧﺩﺈﺑ ﻢﻗ . 5
"!ﻡﺎﻫ" ﺮﻈﻧﺍ .CSV ﻒﻠﳌﺍ ﻰﻟﺍ ﻆﻔﲢ ﺎﻣﺪﻨﻋ ﺕﺎﻧﺎﻴﺒﻟﺍ ﻉﺍﻮﻧﺃ ﺾﻌﺑ ﻞﻳﻮﲢ ﺔﻴﻔﻴﻛ ﻦﻋ ﻞﻴﺻﺎﻔﺗ ﻰﻠﻋ ﻝﻮﺼﺤﻠﻟ •
.(2-44 ﺔﺤﻔﺻ) "CSV ﻒﻠﻤﻛ ﺔﻓﻮﻔﺼﳌﺍ ﺕﺎﻳﻮﺘﺤﻣ ﻆﻔﳊ" ﻥﺍﻮﻨﻋ ﺖﲢ ﻆﺣﻻ
ﺔﻳﺮﺸﻋ ﺔﻄﻘﻧ ﻭ CSV ﻒﻠﻤﻠﻟ ﺓﺩﺪﺤﻣ ﺯﻮﻣﺭ ﺪﻳﺪﲢ u
ﺕﺍﺀﺍﺮﺟﻹﺍ ﺬﻴﻔﻨﺘﺑ ﻢﻗ ﻢﺛ .CSV ﺕﺎﻴﺛﺍﺪﺣﻹﺍ ﺩﺍﺪﻋﺇ ﺔﺷﺎﺷ ﺽﺮﻌﻟ 1(FILE)5(CSV)3(SET) ﻰﻠﻋ ﻂﻐﺿﺍ
.(3-16 ﺔﺤﻔﺻ) "ﺔﻳﺮﺸﻋ ﺔﻄﻘﻧ ﻭ CSV ﻒﻠﻤﻠﻟ ﺓﺩﺪﺤﻣ ﺯﻮﻣﺭ ﺪﻳﺪﲢ" ﻥﺍﻮﻨﻋ ﺖﲢ 3 ﺓﻮﻄﳋﺍ ﻦﻣ
ﹰ
ﺎﻴﻟﺎﺣ ﺡﻮﺘﻔﳌﺍ ﻝﻭﺪﳉﺍ ﻲﻓ ﻎﻴﺼﻟﺍ ﻦﻣ ﻞﻜﻟ ﺏﺎﺴﳊﺍ ﺓﺩﺎﻋﺍ ﺔﻴﻠﻤﻋ
k
ﻭﺃ ﻪﺤﺘﻔﺗ ﺎﻤﻠﻛ ﻞﺴﻛﺃ ﻲﻓ ﻎﻴﺼﻟﺍ ﻦﻣ ﻞﻜﻟ ﺏﺎﺴﳊﺍ ﺪﻴﻌﺗ ﻱﺬﻟﺍ Auto Calc ﻞﺒﻘﺘﺴﻣ S • SHT ﻊﺿﻮﻟﺍ ﻥﻮﻜﻳ
ﹰ
ﺎﻀﻳﺃ ﻚﻨﻜﳝﻭ .ﺔﻴﻟﻭﻷﺍ ﺔﻛﺮﺸﻠﻟ ﺔﻴﺿﺍﺮﺘﻓﺇ ﺕﺍﺩﺍﺪﻋﺍ ﺖﲢ Auto Calc ﺢﻴﺘﻳ ﻭ .ﻞﻳﺪﻌﺘﻟﺍ ﺔﻴﻠﻤﻋ ﻱﺍ ﺀﺍﺮﺟﺈﺑ ﻡﻮﻘﺗ
.ﺕﺩﺭﺍ ﺍﺫﺍ ،ﺎﻳﻭﺪﻳ ﺏﺎﺴﳊﺍ ﺓﺩﺎﻋﺍ ﺔﻴﻠﻤﻋ ﺬﻴﻔﻨﺗ