Ukusebenzisa iiWebhu zeeWebhu nge Excel

Sebenzisa idatha esuka kumatafula e-intanethi ngaphakathi kwe-Microsoft Excel

Into eyaziwayo encinane ye Excel yikhono layo lokungenisa amaphepha eWebhu . Oku kuthetha ukuba ukuba unako ukufikelela kwiedatha kwiwebhusayithi, kulula ukuyiguqula kwi-spreadsheet ye-Excel ukuba iphepha lewebhu lihlelwe ngokufanelekileyo. Oku kukwazi ukungenisa kukunceda ukuba uhlalutye idatha yewebhu usebenzisa iifomula eziqhelekileyo kunye ne-interfaces.

Data Scraping

I-Excel yisicelo se- spreadsheet esilungiselelwe ukuvavanya ulwazi kwi-grid-dimensional grid. Ngaloo ndlela, ukuba uya kuthumela idatha kwiphepha lewebhu kwi-Excel, ifomathi ifanelekileyo njengetafile. I-Excel iya kufaka zonke iithebula kwiphepha leWebhu, iithebula ezicacileyo, okanye zonke iindatshana ezikwiphepha-nangona zingabonakali kakuhle idatha, ngokugqithiseleyo ukuba ukungenisa kwangaphandle kuza kufuna ukulungiswa ngaphambi kokuba usebenze nayo.

Ngenisa i Datha

Emva kokuba ufumene iwebhusayithi equlethe ulwazi olufunayo, thumela idatha kwi-Excel.

1. Vula i-Excel.
2. Cofa kwiTebhu yeData uze ukhethe kwiWebhu kwiQela lokuFumana nokuTshintshisa iDatha .
3. Kwibhokisi yencoko, khetha iSiseko kwaye uthayiphe okanye unamathisele i-URL kwibhokisi. Chofoza OK.
4. Kwibhokisi ye- Navigator , khetha ietafile ofuna ukuba zingenise. I-Excel izama ukuhlukanisa iibhloko zemixholo (itekisi, iitheyibhile, imifanekiso) ukuba iyazi indlela yokuzibetha. Ukungenisa ngaphezulu kweefayili enye yedatha, qinisekisa ibhokisi ihlolwe ukuba Khetha izinto ezininzi.
5. Cofa kwitafile ukuba ungenise kwibhokisi le- Navigator . Imboniselo ibonakala ngakwesokudla kwibhokisi. Ukuba ihlangabezana nezilindelo, cinezela inkinobho yokulayisha .
6. I-Excel yithwala itafile kwithebhu entsha kwincwadi yokusebenzela.

Idatha yokuHlela ngaphambi kokungenisa

Ukuba ifasitethi oyifunayo inkulu kakhulu okanye ayifomathiweyo kulindeleke, yitshintshe kwi-Query Editor ngaphambi kokuba ulayishe idatha ukusuka kwiwebhusayithi kwi-Excel.

Kwibhokisi ye- Navigator , khetha u- Hlela endaweni yokuLawula. I-Excel iya kulayisha itafile kwi-Query Editor endaweni yespredishithi. Esi sixhobo sivula itafile kwibhokisi ekhethekileyo ekuvumela ukulawula umbuzo, ukhethe okanye ususe iikholomu kwitheyibhile, gcina okanye ususe imigqa etafileni, uhlele, uhlukanise iikholomu, iqela uze ufake indawo yamanani, udibanise itafile kunye neminye imithombo yolwazi kunye lungisa ii parameters zetafile ngokwayo.

Umbuzo we-Query Editor unikezela ukusebenza okuphambili okuhambelana nokusingqongileyo kwimvelo (njengeMicrosoft Access) kunezixhobo eziqhelekileyo ze-spreadsheet zixhobo ze-Excel.

Ukusebenza ngeDatha eNgenisiweyo

Emva kokuba idatha yakho yeWebhu ilayishe kwi-Excel, uya kuba nokufikelela kwi-Ribery Tools Ribbon. Le miyalelo emitsha isekela ukulungiswa kwedatha-mveliso (nge-Query Editor), ihlaziya kwimvelaphi yedatha yasekuqaleni, idibanisa iphinde ifake nezinye iincwadi kumsebenzi wencwadi kunye nokwabelana ngolwazi oluchongiweyo kunye nabanye abasebenzisi be-Excel.

Ukuqwalasela

I-Excel isekela ukutshekisha okubhaliweyo kwiwebhsayithi, kungekhona nje ietafile. Olu luncedo luncedo xa ufuna ukungenisa ulwazi oluhlalutyiweyo ngokufanelekileyo kwifom yespredishithi kodwa alulwanga njengedatha yedatha-umzekelo, uludwe lweedilesi. I-Excel iya kwenza konke okusemandleni ukufakela idatha yewebhu njenge-, kodwa ingenakucwangciswa kwedatha yeWebhu, mhlawumbi kufuneka ukuba wenze ifomathi ezininzi ngaphakathi kwe-Excel ukulungiselela idatha yokuhlalutya.