Ngenisa idatha kusuka kweminye imithombo ku-Excel Kuyikhono eliyisisekelo lalabo abaphethe umthamo omkhulu wolwazi kule softhiwe yesipredishithi. I-Excel inikeza izinketho ezimbalwa zokungenisa idatha kweminye imithombo, kungaba isizindalwazi noma ifayela le-CSV. Kulesi sihloko, sizothola ukuthi ungawenza kanjani lo msebenzi ngempumelelo nangempumelelo, ngaleyo ndlela wandise amandla e-Excel njengethuluzi elinamandla lokuphatha nokuhlaziya idatha.
Enye yezinketho ezivame kakhulu zokungenisa idatha ku-excel kusukela kusizindalwazi sangaphandle. I-Excel ikuvumela ukuthi uxhume kusizindalwazi se-SQL noma Finyelela, phakathi kokunye, futhi ukhiphe imininingwane edingekayo ngokuqondile kusipredishithi sakho. Lokhu kubaluleke kakhulu uma usebenza ngedatha ebuyekezwa njalo futhi udinga ukufinyelela enguqulweni yakamuva yolwazi ngaphandle kokuthi uyingenise mathupha isikhathi ngasinye.
Enye inketho yokungenisa idatha ku-Excel Kungamafayela e-CSV (Amanani Ahlukaniswe Ngokhefana), ifomethi esetshenziswa kabanzi ukushintshanisa idatha phakathi kwezinhlelo zokusebenza ezihlukene. Ifayela le-CSV empeleni liyifayela lombhalo ongenalutho lapho idatha ihlelwa khona yaba amakholomu, ahlukaniswe ngamakhoma. I-Excel ibona ngokuzenzakalelayo le fomethi futhi ikuvumela ukuthi ungenise idatha ngokushesha kusuka kufayela CSV ngokukhetha inketho ethi “Vula” kumenyu ethi “Ifayela”.
Zombili izinketho zinezinzuzo kanye nokubi, futhi kubalulekile ukucabangela uhlobo lwedatha nesakhiwo obhekene naso ngaphambi kokunquma ukuthi iyiphi inketho engcono kakhulu yokungenisa idatha ku-Excel. Uma usungenise idatha isuka komunye umthombo ku-Excel, uzoba nezinhlobonhlobo zamathuluzi nemisebenzi onawo ukuze ulawule futhi uhlaziye leyo datha, okukuvumela ukuthi usebenzise ngokugcwele amandla aleli thuluzi elinamandla. Ezigabeni ezilandelayo, sizochaza kabanzi ngenqubo Igxathu emvakwe gxathu ukungenisa idatha kusuka kusizindalwazi kanye nakufayela le-CSV ku-Excel, ukuze ukwazi ukusebenzisa kalula ulwazi olutholiwe kumongo wakho womsebenzi.
- Isingeniso ekungeniseni idatha ku-Excel kusuka kweminye imithombo
Ikhono lokungenisa idatha ku-Excel kusuka emithonjeni ehlukene kuwumsebenzi oyinhloko ovumela abasebenzisi ukuthi bahlanganise ulwazi olusuka kusizindalwazi esihlukene noma amafayela e-CSV benze isipredishithi esisodwa. Lokhu kubaluleke kakhulu uma usebenza namasethi amakhulu edatha noma uma udinga ukuhlanganisa ulwazi oluvela emithonjeni eminingi endaweni eyodwa.
Ukungenisa idatha ku-Excel kusuka kweminye imithombo, kufanele siqale siqinisekise ukuthi unenguqulo efanelekile yesofthiwe. Ukuqala nge-Excel 2016, sinebanga elibanzi lezinketho zokungenisa idatha. Uma uhlelo seluvuliwe, singaya kuthebhu ethi "Idatha" kubha yokuzula bese ukhetha inketho ethi "Thola idatha yangaphandle". Lapha sizothola izindlela zokungenisa ezehlukene, ezifana nesizindalwazi, kusuka ku-a ifayela lombhalo noma i-CSV, phakathi kokunye.
Uma sifuna ukungenisa idatha kusuka isizindalwazi, i-Excel izosivumela ukuthi sisungule ukuxhumana okuqondile nomthombo wedatha. Ukuze senze lokhu, kumele sikhethe inketho ethi “Kusuka kusizindalwazi” futhi silandele izinyathelo ezihambisanayo. Kubalulekile ukuqaphela ukuthi kuzodingeka sibe nemininingwane efanele nezimvume zokufinyelela kusizindalwazi okukhulunywa ngaso. Singase futhi silungiselele izinketho zokuvuselela nokuhlunga ukuze siqinisekise ukuthi idatha ingeniswe ngendlela efanele.
Uma sifuna ukungenisa idatha kusuka ku-CSV noma ifayela lombhalo, inqubo ilula ngokulinganayo. Kufanele sikhethe »Kusuka embhalweni» kunketho ethi “Thola idatha yangaphandle” bese sikhethe ifayela elihambisanayo. I-Excel izosiqondisa kunqubo yokungenisa, isivumele ukuthi sichaze uhlobo lwefayela, i-field delimiter, ifomethi yedethi, phakathi kokunye. Uma sekuqediwe, idatha izongeniswa kuspredishithi futhi singaqala ukusebenza ngaso.
Sengiphetha, ukungenisa idatha ku-Excel kusuka kweminye imithombo kuwumsebenzi onamandla osivumela ukuthi sihlanganise ulwazi oluvela emithonjeni ehlukene endaweni eyodwa. Kungakhathaliseki ukuthi kuvela kusizindalwazi noma ifayela le-CSV, i-Excel isinika izinketho ezimbalwa zokungenisa ukuze sizivumelanise nezidingo zethu. Ngokulandela izinyathelo ezifanele, singangenisa idatha ngempumelelo futhi uqale ukuzisebenzisa ekuhlaziyeni kwethu noma emibikweni.
- Ukungenisa idatha kusizindalwazi se-Excel
I-HTML inikeza izinketho ezimbalwa zokungenisa idatha ku-Excel isuka kweminye imithombo, njengezizindalwazi noma amafayela e-CSV. Indlela evamile yokungenisa idatha iwukusebenzisa ithuluzi Ledatha Yangaphandle i-Excel ikuvumela ukuthi ungenise idatha kusuka emithonjeni ehlukahlukene, okuhlanganisa imininingwane yolwazi ye-SQL, Ukufinyelela, namafayela e-CSV. Ukuze ungenise idatha Kusizindalwazi se-Excel, landela lezi zinyathelo:
1. Vula i-Excel bese uye kuthebhu ethi “Idatha” kubha yamathuluzi. Chofoza u-»Thola Idatha Yangaphandle» bese ukhetha okuthi “Kusuka Kweminye Imithombo” kumenyu yokudonsela phansi. Okulandelayo, khetha umthombo wedatha ofuna ukuwungenisa. Uma uhlela ukungenisa idatha kusuka kusizindalwazi, khetha inketho ethi “Kusuka Kumbuzo We-Microsoft”. .
2. Khetha umthombo wedatha ofuna ukuwungenisa Ungakhetha ezinhlobonhlobo zezinketho, njenge izizindalwazi I-SQL noma Ukufinyelela. Uma usebenzisa isizindalwazi se-SQL, faka imininingwane yokufinyelela edingekayo ukuze uxhume kusizindalwazi.
3. Uma usukhethile umthombo wedatha futhi wasungula uxhumano, ungacacisa idatha ofuna ukuyingenisa. Ungakhetha wonke amathebula, ukubukwa, noma ubhale imibuzo yangokwezifiso ukuze ungenise kuphela idatha oyidingayo. I-Excel futhi ikuvumela ukuthi uhlunge futhi uhlunge idatha ngaphambi kokungenisa. Uma usulungise izinketho zokungenisa, chofoza okuthi "KULUNGILE" ukuze ungenise idatha ku-Excel. Ungakhetha ukuthi uyafuna yini ukubonisa idatha eshidini lokusebenzela elisha noma endaweni ethile ngaphakathi kweshidi lokusebenzela elikhona.
Ngokufigqiwe, I-Excel inikeza izinketho ezimbalwa zokungenisa idatha kusuka kusizindalwazi kuye kufayela le-CSV. Ungasebenzisa ithuluzi "Idatha Yangaphandle" ukuze usungule uxhumano kusizindalwazi bese ukhetha idatha ofuna ukuyingenisa. Ukwengeza, ungakwazi ukuhlunga futhi uhlele idatha ngaphambi kokungenisa Uma usulungise zonke izinketho, i-Excel izongenisa idatha kushidi lokusebenza futhi ungaqala ukusebenza nayo.
- Izinyathelo zokungenisa idatha kusizindalwazi ku-Excel
Izinyathelo zokungenisa idatha kusuka kusizindalwazi ku-Excel
Isinyathelo 1: Lungiselela isizindalwazi
Ngaphambi kokungenisa idatha ku-database ku-Excel, kubalulekile ukuqinisekisa ukuthi i-database ihlelwe kahle futhi ifomethiwe. Lokhu kuhilela ukuhlola ukuthi ikholomu ngayinye inesihloko esicacile nokuthi idatha ihlelwe ngendlela efanayo. Ukwengeza, kuyatuseka ukususa noma iyiphi idatha engabalulekile noma eyimpinda ukuze kuqinisekiswe ubuqotho bedatha ezongeniswa kwamanye amazwe Uma isizindalwazi sesilungile, ungadlulela esinyathelweni esilandelayo.
Isinyathelo sesi-2: Vula i-Excel bese ukhetha ithebhu "Idatha".
Ukungenisa idatha kusuka kusizindalwazi ku-Excel, kufanele siqale sivule uhlelo futhi siqinisekise ukuthi sinakho Ifayela le-Excel akunalutho ilungele ukwamukela idatha. Okulandelayo, sizokhetha ithebhu "Idatha" kubha yamathuluzi ye-Excel. Ngaphakathi kwale thebhu, sizothola inketho »Thola idatha yangaphandle», okufanele siyikhethe ukuze sifinyelele amathuluzi adingekayo ukungenisa idatha.
Isinyathelo sesi-3: Ngenisa idatha kusizindalwazi
Uma usungaphakathi kwenketho ethi “Thola idatha yangaphandle”, imenyu yokudonsela phansi izovuleka enemithombo yedatha ehlukene etholakalayo ukuze ingeniswe ku-Excel. Sizokhetha inketho ethi "Kusuka kusizindalwazi" bese sizokhetha uhlobo lwesizindalwazi esifuna ukukungenisa, njenge-Access, i-SQL Server noma i-Oracle. Okulandelayo, kuzovula iwizadi ezosiqondisa kunqubo yokuxhuma kusizindalwazi nokukhetha amathebula noma imibuzo esifuna ukuyingenisa. Uma amathebula noma imibuzo isikhethiwe, sizoqinisekisa ukungenisa futhi idatha izofakwa kufayela le-Excel ezindaweni esizibonisile.
- Ukungenisa idatha kufayela le-CSV ku-Excel
Ukungenisa idatha kusuka kufayela le-CSV kuya ku-Excel kuwumsebenzi ovamile futhi olula. I-Excel inikeza ithuluzi elakhelwe ngaphakathi elikuvumela ukuthi wenze lokhu kungenisa ngokushesha futhi kalula. Ukuze ungenise idatha efayeleni le-CSV, kufanele uqale uvule i-Excel bese ukhetha ithebhu ethi “Idatha” kuribhoni Bese, uchofoza inkinobho ethi “Kusuka Kumbhalo” etholakala eqenjini elithi “Thola Idatha”. Khetha ifayela le-CSV ofuna ukulingenisa bese uchofoza okuthi “Ngenisa”.
Uma ifayela le-CSV selikhethiwe, kuzovela isilekeleli sokungenisa umbhalo, lapho uzodinga ukulandela izinyathelo ezimbalwa ezilula Ewindini lewizadi lokuqala, khetha okuthi “Delimited” uma ifayela le-CSV lihlukaniswa ngokhefana , isemicolon, noma enye i-delimiter ethize. . Uma ifayela linefomethi engashintshi, khetha "Ububanzi Obulungisiwe." Kulesi sigaba, futhi unenketho yokukhetha ububanzi bamaseli lapho ufuna ukuthi idatha ingeniswe khona. Uma lokhu sekwenziwe, chofoza "Okulandelayo".
Ewindini lesibili lewizadi, ungasetha i-delimiter yekholomu noma uhlele ububanzi bamakholomu uma ukhethe "Ububanzi Obulungisiwe." Ungakwazi ukubuka kuqala imiphumela ezansi kwewindi ukuze uqiniseke ukuthi idatha ingeniswe ngendlela efanele. Ungaphinda ukhethe ifomethi yedatha yekholomu ngayinye futhi ucacise ukuthi uyafuna yini ukweqa noma iyiphi ikholomu ethile Chofoza okuthi "Okulandelayo" uma usuqedile.
Efasiteleni lesithathu nelokugcina lewizadi, ungakhetha ukuthi ufuna ukuthi idatha engenisiwe ibekwe kuphi: kuspredishithi esisha noma kuspredishithi esikhona. Khetha inketho ekufanelekela kangcono bese uchofoza okuthi “Qeda”. Futhi yilokho! Imininingwane izongeniswa ngokuzenzakalelayo endaweni ekhethiwe futhi ilungele ukusetshenziswa ekuhlaziyeni nasekubaleni kwakho ku-Excel Ukungenisa idatha isuka efayeleni le-CSV iye ku-Excel kuyithuluzi eliwusizo kakhulu elikuvumela ukuthi usebenze ngolwazi oluvela emithonjeni ehlukene futhi usebenzise ngokugcwele. yamakhono e-Excel.
- Ungayisetha kanjani ifomethi efanele yokungenisa idatha kusuka kufayela le-CSV ku-Excel
Uyisetha kanjani ifomethi efanele yokungenisa idatha kusuka kufayela le-CSV ku-Excel
Ukungenisa idatha kusuka emithonjeni ehlukene ku-Excel kungaba umsebenzi obalulekile kubasebenzisi abaningi. Phakathi kwale mithombo, amafayela e-CSV (amanani ahlukaniswe ngokhefana) avame kakhulu, njengoba ngokuvamile eyifomethi evamile yokuthekelisa idatha isuka kusizindalwazi sangaphandle noma amasistimu. Nokho, ukuze ungenise kahle le datha ku-Excel, kuyadingeka ukulungisa ifomethi efanelekile. Lapha sichaza indlela yokwenza ngendlela elula nephumelelayo.
1. Hlola ifayela le-CSV: Ngaphambi kokungenisa idatha, qiniseka ukuthi ifayela le-CSV lifomethwe kahle. Hlola ukuthi amanani ahlukaniswa ngokhefana nokuthi irekhodi ngalinye lithatha umugqa owodwa. Futhi qiniseka ukuthi izihloko zekholomu yakho zicacile futhi ziyachaza.
2. Qala ukungenisa ku-Excel: vula isipredishithi esisha ku-Excel bese ukhetha ithebhu ethi “Idatha” ibha yamathuluzi. Chofoza okuthi “Kusuka Kumbhalo/CSV” bese upheqa uye kufayela le-CSV ofuna ukulingenisa. Uma isikhethiwe, i-Excel izovula iwizadi ezokuqondisa ngenqubo yokungenisa.
- Ukulungisa izinkinga ezivamile lapho ungenisa idatha kusuka kweminye imithombo ku-Excel
Ukuxazulula izinkinga ezijwayelekile lapho ungenisa idatha kusuka kweminye imithombo ku-Excel
Kwesinye isikhathi, lapho ungenisa idatha kusuka kweminye imithombo ku-Excel, njengesizindalwazi noma ifayela le-CSV, ungahlangabezana nezinkinga ezithile. Ngenhlanhla, kunezixazululo zezinkinga ezivame kakhulu ezingavela kule nqubo yokungenisa.
Inkinga 1: Ifomethi yedatha engenisiwe
Enye yezinkinga ezivame kakhulu lapho ungenisa idatha ku-Excel “ukungafani” ngefomethi yedatha engenisiwe. Lokhu kungabangela amaphutha noma amanani angalungile kumaseli. Ukuze ulungise le nkinga, kubalulekile ukusebenzisa the I-Excel Data Import Wizard. Le wizadi ikuvumela ukuthi ukhethe ifomethi efanelekile yedatha yakho, njengenombolo, idethi, noma umbhalo, ngaphambi kokuyingenisa ngaphandle, ungakwazi ukulungisa ngokwakho ifomethi yeseli ngemva kokungenisa usebenzisa umsebenzi we-Format” kumenyu ye-Excel.
Inkinga 2: Ukungahambisani kwamagama ekholomu
Enye inkinga evamile lapho ungenisa idatha kusuka kweminye imithombo ku-Excel ukungahambisani namagama ekholomu. Lokhu kungenza kube nzima ukuhlaziya kanye nokukhohlisa idatha engenisiwe. Ngoba xazulula le nkinga, kutuswa ukusebenzisa umsebenzi we-Excel qamba kabusha amakholomu. Lo msebenzi ukuvumela ukuthi uguqule amagama amakholomu angenisiwe ngendlela elula nesheshayo. Ngaphezu kwalokho, kungenzeka ukusebenzisa umsebenzi wokuhlunga datos de Excel ukuthola nokushintsha amagama ekholomu angahambisani kuwo wonke amaspredishithi.
Inkinga 3: Ukuphindaphindwa kwedatha
Ukuphindwaphindwa kwedatha enye inkinga evamile okungahlangatshezwana nayo lapho ungenisa idatha kusuka kweminye imithombo ukuya ku-Excel. Lokhu kungenzeka uma ungenisa idatha emithonjeni eminingi equkethe ulwazi olufanayo noma olufanayo. Ukuze uxazulule le nkinga, i-Excel inikeza umsebenzi wokususa impinda. Lo msebenzi ikuvumela ukuthi ubone futhi ususe amarekhodi ayimpinda. eshidini Ukubala, ukugcina kuphela idatha eyingqayizivele. Ngaphezu kwalokho, kuyenzeka ukusebenzisa umsebenzi wokuhlanganisa idatha ye-Excel ukuhlanganisa idatha engenisiwe ngaphandle kokuyiphinda, okwenza kube lula ukuphatha nokuhlaziya ulwazi.
- Izincomo zokuthuthukisa ukungenisa kwedatha ku-Excel
Izincomo zokuthuthukisa ukungenisa kwedatha ku-Excel
Ukungenisa idatha kusuka kweminye imithombo ku-Excel kungase kubonakale kuwumsebenzi onzima, kodwa ngezincomo ezifanele ungakwazi ukuthuthukisa le nqubo futhi wonge isikhathi nomzamo. Uma ufuna ukungenisa idatha kusuka kusizindalwazi noma ifayela le-CSV, landela lawa macebiso:
1. Yazi idatha yakho de origen: Ngaphambi kokuqala inqubo yokungenisa, qiniseka ukuthi uyayazi idatha ozoyingenisa. Buyekeza ukwakheka kwesizindalwazi noma ifayela le-CSV futhi uqiniseke ukuthi unokuqonda okucacile kwamakholomu, imigqa, nanoma yiluphi ulwazi olungeziwe olufanele. Lokhu kuzokusiza ugweme ukudideka namaphutha ngesikhathi sokungenisa.
2. Sebenzisa amathuluzi afanele e-Excel: I-Excel inikezela ngezinhlobonhlobo zamathuluzi nemisebenzi engakusiza ukungenisa idatha kusuka indlela ephumelelayo. Ngokwesibonelo, ungasebenzisa umsebenzi othi “Ngenisa idatha yangaphandle” ukuze ungenise idatha kusuka kusizindalwazi noma ifayela le-CSV. Ngaphezu kwalokho, i-Excel inemisebenzi efana nokuthi Hlunga kanye nokuthi "Hlunga" ekuvumela ukuthi uhlele futhi uhlaziye idatha yakho ngempumelelo.
3. Hlanza futhi uguqule idatha yakho: Ngaphambi kokuqala ukusebenza ngedatha engenisiwe, kuyalulekwa ukuthi uhlanze futhi uguqule imininingwane ngokwezidingo zakho. Ungasebenzisa imisebenzi efana nokuthi “Susa Izimpinda” ukuze ususe amarekhodi aphindaphindiwe kanye nomsebenzi othi “Umbhalo Kukholomu” ukuze uhlukanise idatha ibe amakholomu ahlukene. Ukwengeza, qiniseka ukuthi ubuyekeza futhi ulungisa noma yimaphi amaphutha noma ukungahambisani kwedatha ukuze uqinisekise ukunemba kwayo.
Ngokulandela lezi zincomo, uzokwazi ukungenisa idatha isuka kweminye imithombo uye ku-Excel ngempumelelo nangempumelelo. Khumbula ukujwayelana nedatha yomthombo wakho, sebenzisa amathuluzi e-Excel afanelekile, futhi uhlanze futhi uguqule idatha yakho njengoba kudingeka. Lungiselela inqubo ukungenisa futhi usebenzise ngokugcwele amandla e-Excel ekuhlaziyeni nasezinqumweni zakho!
- Ukungenisa Idatha ku-Excel: Amathiphu Athuthukile Nemikhuba Emihle
Amathiphu athuthukile nemikhuba engcono kakhulu yokungenisa idatha ku-Excel:
Inqubo yokungenisa idatha ku-Excel ingaba yinkimbinkimbi, ikakhulukazi uma kuziwa emithonjeni yangaphandle efana nesizindalwazi noma amafayela e-CSV. Kodwa-ke, ngamathiphu alungile nemikhuba engcono kakhulu, ungakwenza ngempumelelo nangokunembile. Nawa amaphuzu abalulekile okufanele uwakhumbule:
1. Yazi imithombo yedatha yakho: Ngaphambi kokungenisa idatha ku-Excel, kubalulekile ukuqonda ukwakheka nefomethi yemithombo yedatha. Qiniseka ukuthi unokufinyelela okwanele kanye nezimvume ezidingekayo ukuze ukhiphe ulwazi ngendlela efanele.
2. Sebenzisa amathuluzi afanelekile: I-Excel inikezela ngamathuluzi ahlukahlukene anamandla okungenisa idatha, njenge-Ngenisa Idatha Yangaphandle Wizadi. Ungafinyelela lesi sici ngethebhu “Idatha” kuribhoni. Thatha ithuba lezici ezithuthukile ezikuvumela ukuthi uchaze uhlobo lwedatha, usethe izimo zokungenisa, futhi uhlanganise idatha evela emithonjeni ehlukene. Lokhu kuzokusiza ulungiselele inqubo futhi uthole imiphumela enembile.
3. Ukuhlanzwa nokuguqulwa kwedatha: Uma idatha isingenisiwe, kubalulekile ukwenza izinyathelo zokuhlanza nokuguqula ukuze kuqinisekiswe ukuthi ulwazi luyahambisana futhi luyasebenziseka. Sebenzisa amathuluzi okufometha e-Excel ukuze ususe izimpinda, ulungise amaphutha, futhi uguqule idatha ibe yifomethi oyifunayo Ukwengeza, ungasebenzisa amafomula nemisebenzi ukuze wenze izibalo, wenze izifinyezo, futhi uthole ulwazi olufanele nokuguqulwa kwedatha ingasebenza kahle nangokunembile ekuhlaziyeni kwakho noma emibikweni.
Khumbula ukuthi lawa macebiso athuthukile nezinqubo ezingcono kakhulu zizokusiza ukuthi ungenise idatha ngempumelelo ku-Excel Ungangabazi ukuhlola nokuhlola ngamathuluzi ahlukene nemisebenzi enikezwa uhlelo kuze kube yilapho uthola inketho engcono kakhulu yezidingo zakho.
Ngingu-Sebastián Vidal, unjiniyela wekhompyutha ozifelayo ngobuchwepheshe kanye ne-DIY. Ngaphezu kwalokho, ngingumdali we tecnobits.com, lapho ngabelana khona ngezifundo zokwenza ubuchwepheshe bufinyeleleke kakhudlwana futhi buqonde wonke umuntu.