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

Thatha ngaphandle kwi-Excel

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" .

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

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

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.

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

Cofa iqhosha ' Okulandelayo '.

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 .

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

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.

Ngoku makhe sibone ukuba icandelo ngalinye lokungenisa lithetha ukuthini.

• IMP_BARCODE -ibhakhowudi .

• IMP_CAT - udidi.

• IMP_SUBCAT - udidi oluphantsi.

• IMP_NAME - igama lemveliso.

• IMP_SKLAD - indawo yokugcina impahla.

• IMP_AMOUNT - inani lempahla ekhoyo ngoku kwindawo yokugcina impahla.

• IMP_UNITS - iiyunithi zomlinganiselo.

• IMP_PRICE_POKUP - ixabiso lokuthenga.

• IMP_PRICE_SALE - ixabiso lentengiso.

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.

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 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 '.

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

Qala inkqubo yokungenisa elizweni

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

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

Siphendula umbuzo ngokuvumayo.

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 '.

Khetha ifayile ebigcinwe ngaphambili enesetingi zokurhweba 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.

Thatha ngaphandle iziphumo ngaphandle kweempazamo

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

Ukwakheka kwe-invoyisi

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

Jonga ngezantsi eminye imixholo eluncedo:

• Ukungenisa idatha kwiprogram
• Ukungeniswa kwe-invoyisi
• Ekuqaleni

• Khuphela inkqubo ngoqeqesho olusebenzayo