USU  ››  Iinkqubo zokuzenzela ishishini  ››  Inkqubo yekliniki  ››  Imiyalelo yenkqubo yezonyango  ›› 

Thatha ngaphandle idatha kwi-Excel

Ezi mpawu zifumaneka kuphela kwiMigangatho yoMgangatho kunye neProfessional programmerations.

Vula ifestile yokungenisa idatha

Ukungenisa idatha kwi-Excel akunzima kwaphela xa usebenzisa inkqubo yethu. Siza kuqwalasela umzekelo wokulayisha uluhlu lwabathengi ukusuka kwifayile ye-Excel yesampuli entsha ye -XLSX kwinkqubo.

Ukuvula imodyuli "izigulane" .

Kwindawo ephezulu yefestile, cofa ekunene ukubiza imenyu yomxholo kwaye ukhethe umyalelo "Ngenisa ngaphandle" .

Ifestile yemodal yokungenisa idatha iya kuvela.

Nceda ufunde ukuba kutheni ungayi kukwazi ukufunda imiyalelo ngokuhambelana kwaye usebenze kwifestile evelayo.

Ukukhetha ifomathi yefayile efunwayo

Ukungenisa isampuli entsha yefayile yeXLSX , yenza i ' MS Excel 2007 ' ukhetho.

Thatha ngaphandle itemplate yefayile

Qaphela ukuba ifayile esiza kuyingenisa inemihlaba eqhelekileyo. Le mimandla iyafumaneka kwikhadi lomxhasi. Ukuba ufuna ukungenisa imihlaba engekhoyo, ungaodola ukuyilwa kwayo kubabhekisi phambili benkqubo ye ' USU '.

Ngokomzekelo, le yindlela i-template yefayile ye-Excel yokungenisa izigulane ezinokubonakala ngathi.

Kodwa le mimandla kwiprogram. Sigcwalisa le mimandla xa sibhalisa ngesandla umxhasi omtsha. Kubo apho siya kuzama ukungenisa idatha kwifayile ye-Excel.

Intsimi "Igama" kufuneka igcwaliswe. Kwaye ezinye iikholamu kwifayile ye-Excel zingahlala zingenanto.

Ukukhetha ifayile

Xa ifomati yefayile yokungenisa ichaziwe, khetha ifayile ngokwayo ukuba ilayishwe kwisixokelelwano. Igama lefayile ekhethiweyo liya kufakwa kwindawo yokufaka.

Ngoku qiniseka ukuba ifayile ekhethiweyo ayivulwanga kwinkqubo yakho ye-Excel . Ngaphandle koko, ukungenisa kuya kusilela, njengoko ifayile iya kuhlala yenye inkqubo.

Cofa iqhosha ' Okulandelayo '.

Ubudlelwane phakathi kweenkalo zeprogram kunye neekholamu zefayile ze-Excel

Emva kwefayile ekhankanyiweyo ye-Excel iya kuvula kwindawo ekunene yebhokisi yencoko yababini. Kwaye kwicala lasekhohlo, imihlaba ye ' USU ' inkqubo izakudweliswa. Ngoku kufuneka sibonise ukuba yeyiphi intsimi ye ' USU ' ulwazi lwenkqubo ukusuka kuluhlu ngalunye lwefayile ye-Excel eya kuthathwa ngaphandle.

1. Cofa kuqala kwi ' CARD_NO ' indawo ekhohlo. Kulapho inombolo yekhadi lesigulane igcinwa khona.

2. Okulandelayo, nqakraza kwicala lasekunene loluhlu lwesihloko ' A '. Kukulo kholamu yefayile engeniswe ngaphandle apho amanani ekhadi adweliswe.

3. Emva koko unxibelelwano lwenziwa. ' [Iphepha1] A ' izakuvela kwicala lasekhohlo legama lendawo ' CARD_NO '. Oku kuthetha ukuba ulwazi luya kulayishwa kulo mmandla ukusuka ku ' A ' kholam yefayile ye-excel.

Ubudlelwane kuzo zonke iinkalo

Ngomgaqo ofanayo, sinxulumanisa yonke eminye imihlaba yenkqubo ye ' USU ' kunye neentsika zefayile ye-Excel. Isiphumo kufuneka sibe yinto efana nale.

Ngoku makhe sibone ukuba icandelo ngalinye elisetyenzisiweyo lithetha ukuthini.

• IKHADI_NO - inombolo yekhadi.

• NAME - igama lesigulana. Ifani, igama kunye ne-patronymic.

• I-MOBILE - ifowuni yeselula.

• IIPHONE - ezinye iifowuni, njengenombolo yefowuni yasekhaya.

Onke amabala anamagama anengqiqo. Kwanele ukwazi amagama alula esiNgesi ukuqonda injongo yentsimi nganye. Kodwa, ukuba usekho, kukho into engacacanga, unokuqhagamshelana ngokukhuselekileyo nenkxaso yobugcisa .

Yeyiphi imigca efanele ukutsitywa?

Qaphela kwifestile enye ofuna ukutsiba umgca omnye ngexesha lenkqubo yokungenisa.

Enyanisweni, kumgca wokuqala wefayile ye-Excel, asinayo idatha, kodwa izihloko zentsimi.

Cofa iqhosha ' Okulandelayo '.

Amanye amanyathelo kwincoko yababini yokungenisa

' Inyathelo lesi-2 ' liza kuvela, apho iifomati zeentlobo ezahlukeneyo zedatha ziqwalaselwe. Ngokuqhelekileyo akukho mfuneko yokutshintsha nantoni na apha.

Cofa iqhosha ' Okulandelayo '.

Inyathelo lesi-3 liya kuvela. Kuyo, kufuneka sicwangcise zonke iibhokisi zokukhangela ', njengoko kubonisiwe kumzobo.

Gcina ukuseta ngaphandle

Ukuba simisela ukungeniswa esiceba ukukwenza ngamaxesha athile, ngoko kungcono ukugcina zonke izicwangciso kwifayile ekhethekileyo yokucwangcisa ukuze ungababeki rhoqo.

Kuyacetyiswa ukuba ugcine useto lokungenisa ukuba awuqinisekanga ukuba uya kuphumelela okokuqala.

Cinezela iqhosha ' Gcina itemplate '.

Siza negama lefayile yemimiselo yokungenisa. Kungcono ukuyigcina kwindawo enye apho ifayile yedatha ikhona, ukuze yonke into ibe kwindawo enye.

Qala inkqubo yokungenisa

Xa ukhankanye zonke izicwangciso zorhweba ngaphakathi, sinokuqala inkqubo yorhweba ngokwalo ngokunqakraza ku ' Yenza ' iqhosha.

Thatha ngaphandle iziphumo ezineempazamo

Emva kokubulawa, unokubona umphumo. Inkqubo iya kubala ukuba mingaphi na imigca eyongeziweyo kwinkqubo kwaye zingaphi ezibangele impazamo.

Kukwakho nelog yokungenisa. Ukuba iimpazamo zenzeka ngexesha lokwenziwa, zonke ziya kuchazwa kwilogi kunye nesalathiso somgca wefayile ye-Excel.

Ulungiso lwempazamo

Inkcazelo yeemposiso kwilog yezobugcisa, ngoko ke ziyakufuna ukuboniswa kwi ' USU ' abadwelisi benkqubo ukuze bancede ngolungiso. Iinkcukacha zoqhagamshelwano zidweliswe kwiwebhusayithi usu.kz.

Cofa iqhosha elithi ' Rhoxisa ' ukuvala incoko yababini yokungenisa.

Siphendula umbuzo ngokuvumayo.

Ukuba azikho zonke iirekhodi eziwele kwimpazamo, kwaye ezinye zongezwa, ngoko ngaphambi kokuba uzame ukungenisa kwakhona, kuya kufuneka ukhethe kwaye ucime iirekhodi ezongeziweyo ukwenzela ukuba ungabandakanyi ukuphindaphinda kwixesha elizayo.

Layisha ukusetha kwangaphambili xa uzama ukungenisa kwakhona

Ukuba sizama ukungenisa kwakhona idatha, sibiza ingxoxo yokungenisa kwakhona. Kodwa ngeli xesha kuyo sicinezela iqhosha ' Layisha itemplate '.

Khetha ifayile ebigcinwe ngaphambili eneesetingi zokurhweba ngaphandle.

Emva koko, kwibhokisi yencoko yababini, yonke into iya kuzaliswa ngendlela efanayo naleyo yayiyiyo ngaphambili. Akukho nto yimbi ekufuneka iqwalaselwe! Igama lefayile, ifomathi yefayile, amakhonkco phakathi kwamasimi kunye neekholamu zetafile ye-Excel, nayo yonke enye into igcwaliswa.

Ngeqhosha ' Okulandelayo ', ungagqitha kumanyathelo alandelayo encoko yababini ukuqinisekisa okungentla. Kwaye ngoku nqakraza iqhosha elithi ' Baleka '.

Thatha ngaphandle iziphumo ngaphandle kweempazamo

Ukuba zonke iimpazamo zilungisiwe, ngoko i-log yokwenziwa kokungeniswa kwedatha iya kujongeka ngolu hlobo.

Kwaye iirekhodi ezingenisiweyo ziya kuvela kwitheyibhile.

Jonga ngezantsi eminye imixholo eluncedo:

• Ukungenisa idatha kwiprogram
• Ekuqaleni

• Khuphela inkqubo ngoqeqesho olusebenzayo