I ka hoʻohana ʻana i ka polokalamu hāmeʻa demo o ka ʻōnaehana lepili ESL, e hoʻohana mākou i ka lawe mai kiʻi a me ka lawe mai ʻikepili. Hoʻolauna ʻia nā ʻano lawe mai ʻelua:
ʻO ke ʻano mua: ka lawe ʻana mai i nā kiʻi lepili ESL
Kākoʻo ka mea hana demo i ka lawe ʻana mai i nā faila kiʻi bitmap a me ka hāʻawi ʻana iā lākou i ka lepili ESL ma ke ʻano o ka dot matrix.
E hana ka mea hana demo i ke kiʻi bitmap i lawe ʻia mai penei:
1. ʻOki ʻana i ka nui e hoʻokō i ka hoʻonā nui o ka pale o ka lepili ESL like;
2. Ka hana kala, ʻeleʻele-a-keʻokeʻo ke kiʻi a hoʻopau i ke kumu hina. Inā koho ʻoe i ka pale ʻulaʻula ʻeleʻele-a-keʻokeʻo, e unuhi ʻia ka ʻāpana ʻulaʻula; inā koho ʻoe i ka pale melemele ʻeleʻele-a-keʻokeʻo, e unuhi ʻia ka ʻāpana melemele;
I ke koho ʻana i ka pale ʻulaʻula ʻeleʻele-a-keʻokeʻo a i ʻole ka pale melemele ʻeleʻele-a-keʻokeʻo, ua ʻōlelo ʻia e waiho ʻia ka ʻāpana ʻulaʻula a melemele paha o ke kiʻi ma kahi ʻāpana kikoʻī o ke kiʻi. A i ʻole, e ālai ka ʻāpana ʻulaʻula a melemele paha i ka ʻāpana ʻeleʻele o ke kiʻi.
ʻO ke ala ʻelua, ʻo ia ka lawe ʻana mai i ka ʻikepili lepili ESL
Kākoʻo ka mea hana hōʻike i ka excel import e hōʻano hou i nā ʻike like ʻole o nā lepili ESL like ʻole. Eia nō naʻe, e kaupalena ʻia ka helu o nā lepili ESL:
ʻAʻole i ʻoi aku ma mua o 10.
Pono ka faila excel e hoʻohana i ka faila testdata.xls i hāʻawi ʻia ma ka faila polokalamu. Eia ka laʻana o ka ʻike:
Ma mua o ka lawe ʻana mai i ka ʻikepili no ka lepili ESL, hiki iā ʻoe ke hoʻololi i nā ʻike ma ka papa Excel, akā pono ʻoe e mālama i nā lula ʻano o nā kahua ma ka papa. Hōʻike kēlā me kēia kahua i nā ʻikepili like ʻole, penei:
ID lepili: ID lepili ESL.
ʻAno lepili: ʻAno lepili ESL.
Waihoʻoluʻu lepili: ʻano kala, B = ʻeleʻele, Br = ʻulaʻula ʻeleʻele, e = melemele ʻeleʻele;
#1 kikokikona, #2 kikokikona, #3 kikokikona, #4 kikokikona, #5 kikokikona: ʻano kikokikona string;
#7 kumukūʻai, #8 kumukūʻai: waiwai kālā;
#9 barcode: waiwai barcode.
Ka manawa hoʻouna: Sep-28-2021