Shandisa dhiyabhorosi kubva mumatafura eIndaneti mukati meMicrosoft Excel
Chimwe chinhu chiduku-chinonyatsozivikanwa cheExcel ndiyo kukwanisa kwayo kuisa maWebhu . Izvi zvinoreva kuti kana iwe uchikwanisa kuwana dhidhiro pawebsite, zviri nyore kuzvishandura kuExpcel spreadsheet kana peji yeWebhu yakanyatsogadzirirwa. Izvi zvinokwanisa kukubatsira iwe kuongorora yeDebhu yedata uchishandisa mienzaniso yakadzika yaExcel uye interfaces.
Scraping Data
Excel ishandisi yesperesheet yakagadziridzwa kuongorora ruzivo mune girasi miviri. Nokudaro, kana uri kutumira deta kubva pawebhu iwe kuExcel, yakanakisisa mafomu yakafanana nefurafura. Excel inotumira tafura yose paWebhu peji, mafurafura chaiwo, kana kunyange zvinyorwa zviri papeji-kunyange zvazvo zvishoma zvakanyatsogadzirisa deta, kunyanya kukosha kunotora kunoda kudzokorora musati washanda nayo.
Tumira Data
Mushure mokunge maona webhusaiti iyo ine ruzivo rwaunoda, tumira iyo data ku Excel.
- Vhura Excel.
- Dzvanya Dhiyabhorosi tab uye sarudza Kubva paIndaneti muBet & Transform Data boka.
- Mubhokisi rebhokisi, sarudza Basic uye sarudza kana kuisa URL mubhokisi. Dzvanya OK.
- Mubhokisi reNigigator , sarudza tafura dzamunoda kutumira. Excel inoedza kuparadzanisa zvigadziro zvinowanikwa (zvinyorwa, matafura, maikirwo) kana ikaziva nzira yekuvadzinga. Kunyoresa kudarika imwe yedhaka yemari, chengetedza bhokisi rinotarirwa kuti Sarudza zvinhu zvakawanda.
- Dzvanyira tafura kuti uitwe kubva kuNebigator bhokisi. Chiratidziro chinotaridzika chinowanikwa kune rumwe rutivi rworudyi rwebhokisi. Kana iyo inosangana nezvinodiwa, shandisa bhodhi rekutakura.
- Excel inotakura tafura mumutambo mutsva mubhuku rebhuku.
Kugadzirisa Data Usati Watengesa
Kana iyo dataset iwe yaunoda yakakura kwazvo kana isati yasanganiswa pane zvaunotarisirwa, shandura iyo muQuery Editor usati wagadzirisa data kubva pawebsite kuExcel.
Muchikwata cheNigigator , sarudza Hora pane Mutoro. Excel inotakura tafura muQuery Editor panzvimbo pepadheti. Iri shanduro rinovhura tafura mubhokisi rakasiyana rinoita kuti iwe uchengetedze mubvunzo, sarudza kana kubvisa mazamu ari patafura, chengetedza kana kubvisa mitsetse kubva patafura, kuisa, kuparadzanisa mapuranga, boka uye kuchinja mararamiro, kubatanidza tafura nemamwe magwaro ezvinyorwa uye gadzirisa zviyero zvetafura pachayo.
IQuery Editor inopa hunobudirira hunoenderana nemamiriro ezvinhu epa database (kufanana neMacrosoft Access) kupfuura mashandisirwo anozivikanwa epadheseti eExpcel.
Kushanda neInded Data
Mushure meDebhu yenyu yedhidha inotakura kuExcel, iwe uchave nekwaniso yeKuchina Tools ribhoni. Iyi mitsara yemitemo itsva inotsigira data-source editing (kuburikidza neQuery Editor), inozorodza kubva kune yakatanga dhiyabhorosi, yekubatanidza nekushandisa pamwe nemimwe mibvunzo mubhuku rebhuku uye kugoverana nedhimbwa nedhara pamwe nevamwe vashandisi veExcel.
Kufunga
Excel inotsigira kugadzira zvinyorwa kubva kune mawebsite, kwete zvese tafura. Izvi zvinobatsira kana iwe uchida kutumira mashoko anonyatsoongororwa mufomu yepaspiritsi asi haurongedzwi sematular data-semuenzaniso, mazita emadhorosi. Excel ichaita zvakanakisisa kuti iwedzere maDebhu eDaily as-is, asi zvisinganyatsogadziridzwa maDebhu data, zvinowanzoita kuti iwe uchatora maitiro akawanda mukati meExcel kuti ugadzirire data yekuongorora.