Home USU  ››  Iinkqubo zokuzenzela ishishini  ››  Inkqubo yevenkile yeentyatyambo  ››  Imiyalelo yenkqubo yevenkile yeentyatyambo  ›› 


Thatha ngaphandle kwi-Excel


Standard Ezi mpawu zifumaneka kuphela kwiMigangatho yoMgangatho kunye neProfessional programmerations.

Vula ifestile yokungenisa idatha

Siza kuqwalasela umzekelo wokulayisha uluhlu lwemveliso kunye neebhalansi zokuqala.

Ukuvula uluhlu "igama-magama" ukubona indlela yokungenisa idatha kwinkqubo kwifayile entsha ye- XLSX MS Excel .

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

Imenyu. Ngenisa ngaphandle

Ifestile yemodal yokungenisa idatha iya kuvela.

Incoko yababini

Kubalulekile 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 kwifayile yeXLSX

Thatha ngaphandle itemplate yefayile

Nceda uqaphele ukuba kwifayile esiya kungenisa ukulayisha into ngeebhalansi zokuqala, kufuneka kubekho iindawo ezinjalo. Okokuqala yiza nefayile ye-Excel kwifom efunekayo.

Imimandla kwifayile yokuthatha ngaphandleImimandla kwifayile yokuthatha ngaphandle. Ukuqhubekeka

Iikholomu ezinezihloko eziluhlaza kufuneka zibe yinyanzelo - olu lulwazi oluphambili malunga noluhlu lwemveliso. Kwaye unokubandakanya iikholamu ezineentloko eziluhlaza okwesibhakabhaka kwifayile engeniswe ngaphandle ukuba ufuna uluhlu lwamaxabiso kunye neebhalansi zemveliso zizaliswe ngokungeziweyo.

Ukukhetha ifayile

Emva koko khetha ifayile. Igama lefayile ekhethiweyo liya kufakwa kwindawo yokufaka.

Ukukhetha ifayile eza kuthathwa ngaphandle

Ngoku qiniseka ukuba ifayile ekhethiweyo ayivulwanga kwinkqubo yakho ye- Excel .

Cofa iqhosha ' Okulandelayo '.

Iqhosha. Ngokubhekele phaya

Udibaniso lomhlaba wenkqubo kunye nomhlathi wefayile egqwesileyo

Emva koko, ifayile ye-Excel echaziweyo iya kuvula kwindawo elungileyo yebhokisi yencoko yababini. Kwaye kwicala lasekhohlo, imihlaba ye ' USU ' inkqubo izakudweliswa. Yehlela. Siza kufuna iindawo ezinamagama aqala ngo ' IMP_ '. Zenzelwe ukungeniswa kwedatha .

Incoko yababini. Inyathelo loku-1

Ngoku kufuneka sibonise ukuba yeyiphi intsimi yeprogram ye- USU ulwazi oluvela kwikholamu nganye yefayile ye-Excel iya kuthunyelwa ngaphandle.

Ukudibanisa indawo enye yenkqubo kunye nekholamu evela kwitheyibhile ye-Excel
  1. Cofa kuqala kwi ' IMP_NAME ' indawo ekhohlo. Apha kulapho igama lemveliso ligcinwa khona.

  2. Ngapha koko sinqakraza ekunene kuyo nayiphi na indawo yoluhlu ' C '. Amagama eempahla adweliswe kule kholamu yefayile ethathwe ngaphandle.

  3. Emva koko unxibelelwano lwenziwa. ' [ Iphepha1] C ' liza kuvela kwicala lasekhohlo legama lendawo ' IMP_NAME '. Oku kuthetha ukuba ulwazi luya kufakwa kulo mmandla ukusuka ' C ' ikholam yefayile ye-excel.

Ubudlelwane kuzo zonke iinkalo

Ngomgaqo ofanayo, siqhagamshela yonke eminye imihlaba ye ' USU ' inkqubo, ukuqala nge ' IMP_ ', kunye neentsika zefayile egqwesileyo. Ukuba ungenisa umgca wemveliso kunye neentsalela, umphumo kufuneka ubukeke ngolu hlobo.

Udibaniso lwazo zonke iinkalo zenkqubo ye-USU enezintlu ezisuka kwitheyibhile ye-Excel

Ngoku makhe sibone ukuba icandelo ngalinye lokungenisa lithetha ukuthini.

Yeyiphi imigca efanele ukutsitywa?

Qaphela kwifestile enye ofuna ukutsiba umgca omnye ngexesha lenkqubo yokungenisa, ekubeni umgca wokuqala wefayile ye-excel awunayo idatha, kodwa iiheader zomhlaba.

Inani lemigca yokutsitywa

Cofa iqhosha ' Okulandelayo '.

Iqhosha. Ngokubhekele phaya

Amanye amanyathelo kwincoko yababini yokungenisa

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

Incoko yababini. Inyathelo lesi-2

Cofa iqhosha ' Okulandelayo '.

Iqhosha. Ngokubhekele phaya

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

Incoko yababini. Inyathelo lesi-3

Gcina ukuseta ngaphandle

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

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

Cinezela iqhosha ' Gcina itemplate '.

Iqhosha. Gcina ukuseta ngaphandle

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

Igama lefayile yokuseta ngaphandle

Qala inkqubo yokungenisa elizweni

Xa ukhankanye zonke izicwangciso zorhweba ngaphakathi, sinokuqala inkqubo yorhweba ngokucofa iqhosha ' Yenza '.

Iqhosha. Baleka

Thatha ngaphandle iziphumo ezineempazamo

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

Thatha ngaphandle iziphumo

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

Ngenisa ilogi enempazamo

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 ' Rhoxisa ' ukuvala incoko yababini yokungenisa.

Iqhosha. Rhoxisa

Siphendula umbuzo ngokuvumayo.

Isiqinisekiso sokuvala ingxoxo yokungenisa ngaphandle

Ukuba ayizizo zonke iirekhodi eziwele kwimpazamo, kwaye ezinye zongezwa, ngoko ngaphambi kokuba uzame ukungenisa kwakhona, kuya kufuneka ukhethe kwaye ucime iirekhodi ezongeziweyo ukuze 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 '.

Incoko yababini. Khuphela ithempleyithi enesetingi

Khetha ifayile ebigcinwe ngaphambili enesetingi zokurhweba ngaphandle.

Ukukhetha ifayile enemimiselo yorhweba ngaphandle

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

Ngeqhosha ' Okulandelayo ', ungagqitha kumanyathelo alandelayo encoko yababini ukuqinisekisa okungentla. Okanye cinezela nje iqhosha ' Baleka ' ngoko nangoko.

Iqhosha. Baleka

Thatha ngaphandle iziphumo ngaphandle kweempazamo

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

Ngenisa ilogi ngaphandle kweempazamo

Ukwakheka kwe-invoyisi

Kubalulekile Ukuba umthengisi uhlala ekuthumela i-invoyisi yezinto ezithengiweyo kwifom ye-elektroniki, awukwazi ukuyifaka ngesandla, kodwa ngokulula. Standard ngenisa .

Jonga ngezantsi eminye imixholo eluncedo:


Uluvo lwakho lubalulekile kuthi!
Ngaba eli nqaku beliluncedo?




Inkqubo yoCwangciso-mali yeHlabathi
2010 - 2024