Ukusebenzisa amakhasi ewebhu nge-Excel

Sebenzisa idatha kusuka kumatafula e-Inthanethi ngaphakathi kwe-Microsoft Excel

Isici esisodwa esaziwayo se- Excel yikhono layo lokungenisa amakhasi eWebhu . Lokhu kusho ukuthi uma ungakwazi ukufinyelela idatha kwiwebhusayithi, kulula ukuyiguqula kuspredishithi se-Excel uma ikhasi lewebhu lihlelwe kahle. Lokhu ikhono lokungeniswa likusiza ukuba uhlaziye idatha yewebhu usebenzisa amafomula ajwayelekile e-Excel kanye nezixhumanisi.

Idatha yokudweba

I-Excel uhlelo lokusebenza lwesipredishithi elungiselelwe ukuhlola ulwazi kumgridi womabili amabili. Ngakho-ke, uma uzofaka idatha kusuka kukhasi lewebhu libe yi-Excel, ifomethi enhle ifana netafula. I-Excel izofaka yonke ithebula ekhasini leWebhu, amatafula athile, noma yonke imibhalo ephepheni-nakuba encane idalwe idatha, okungaphezulu ukuthi ukungenisa okungenayo kuzodinga ukulungiswa ngaphambi kokuthi usebenze nayo.

Ngenisa Idatha

Ngemuva kokubona iwebhusayithi equkethe imininingwane oyidingayo, ngenisa idatha ku-Excel.

1. Vula i-Excel.
2. Chofoza ithebhu yedatha bese ukhetha Kusuka kuWebhu eqenjini le- Get & Transform Data .
3. Ebhokisini lengxoxo, khetha Okuyisisekelo bese uthayipha noma unamathisele i-URL ebhokisini. Chofoza OK.
4. Ebhokisini le- Navigator , khetha amatafula owafisa ukungenisa. I-Excel izama ukuhlukanisa amabhlogo wokuqukethwe (umbhalo, amatafula, ihluzo) uma ekwazi ukuwaphazamisa. Ukuze ungenise okungaphezulu kwedatha eyodwa yedatha, qiniseka ukuthi ibhokisi lihlolwe ukukhetha izinto eziningi.
5. Chofoza ithebula ukuze ungenise ebhokisini le- Navigator . Ukubuka kuqala kubonakala ngakwesokudla kwebhokisi. Uma ihlangabezana nezilindelwe, cindezela inkinobho yokulayisha .
6. I-Excel ilayisha ithebula kuthebhu entsha ebhukwini lokusebenzela.

Ukuhlela Idatha Ngaphambi Kokungenisa

Uma idathasethi oyifunayo inkulu kakhulu noma ingafomathiwe kulindeleke, yishintshe ku-Query Editor ngaphambi kokuthi ulayishe idatha kusuka kuwebhusayithi ibe yi-Excel.

Ebhokisini le- Navigator , khetha Hlela esikhundleni sokulayisha. I-Excel izolayisha ithebula ku-Query Editor esikhundleni sepredishithi. Leli thuluzi livula itafula ebhokisini elikhethekile elikuvumela ukuthi uphathe umbuzo, ukhethe noma ususe amakholomu etafuleni, gcina noma ususe imigqa etafuleni, ukuhlunga, amakholomu ahlukaniswe, iqembu futhi ubeke amanani, hlanganisa itafula neminye imithombo yedatha kanye lungisa imingcele yetafula uqobo.

I-Query Editor inikeza ukusebenza okuphambili okuhambelana nendawo yemininingwane (njenge-Microsoft Access) kunamathuluzi esipredishithi ajwayelekile e-Excel.

Ukusebenza Idatha Engenisiwe

Ngemuva kokuthi idatha yakho yeWeb ilayishe ku-Excel, uzokwazi ukufinyelela ku-Ribery Tools i-Ribbon. Le miyalelo emisha isekela ukuhlela kwedatha (ngokusebenzisa i-Query Editor), ivuselela kusukela emthonjeni wokuqala wedatha, ukuhlanganiswa nokufaka izinhlelo zokusebenza kanye neminye imibuzo ebhokisini lokusebenzela bese ukwabelana ngedatha ekhishwe nabanye abasebenzisi be-Excel.

Ukucabangela

I-Excel isekela ukukhipha umbhalo kusuka kumawebhusayithi, hhayi nje amatafula. Lekhono liwusizo uma udinga ukungenisa ulwazi oluhlaziywa ngendlela efanele kufomu lesipredishithi kodwa alihlelekile njengedatha yedatha-ngokwesibonelo, uhlu lwamakheli. I-Excel izokwenza konke okusemandleni ekungeniseni idatha yeWebhu njenge-kodwa, kodwa imininingwane encane yeWeb, ehle kakhulu ukuthi kuzodingeka wenze ukufometha okuningi ngaphakathi kwe-Excel ukuze ulungise idatha yokuhlaziywa.