Siv cov ntaub ntawv los ntawm cov ntxhuav hauv internet hauv Microsoft Excel
Ib qho kev paub me ntsis ntawm Excel yog nws lub peev xwm los mus xa cov Web pages . Qhov no txhais tau hais tias yog koj tuaj yeem nkag tau cov ntaub ntawv hauv lub vev xaib, nws yog ib qho yooj yim los hloov nws mus rau Excel spreadsheet yog tias qhov Web site zoo tsim. Qhov peev xwm ntawm no tuaj yeem pab koj txheeb xyuas cov ntaub ntawv Web uas siv Excel paub cov qauv thiab cov cim.
Cov Ntawv Qhia Seem
Excel yog daim ntawv thov kev ua haujlwm kom pom zoo rau kev ntsuam xyuas cov ntaub ntawv hauv daim duab ob sab. Yog li, yog hais tias koj mus import cov ntaub ntawv los ntawm lub webpage rau Excel, qhov zoo tshaj plaws hom ntawv yog ua ib lub rooj. Excel yuav xa txhua lub rooj ntawm nplooj ntawv Web site, tsuas yog cov ntxhuav xwb, los yog tag nrho cov ntawv sau rau ntawm nplooj ntawv-txawm hais tias qhov tsawg zog cov ntaub ntawv, qhov ntau tshaj qhov kev tuaj ua lag luam yuav tsum tau hloov dua tshiab ua ntej koj tuaj yeem ua haujlwm nrog nws.
Import Cov Ntaub Ntawv
Tom qab koj tau txheeb xyuas lub website uas muaj cov ntaub ntawv koj xav tau, xa cov ntaub ntawv mus rau Excel.
- Qhib Excel.
- Tshawb cov ntaub ntawv tab thiab xaiv Ntawm Qhov Web nyob rau hauv Txais Tau & Hloov Cov Ntaub Ntawv .
- Hauv lub thawv ntawv, xaiv Basic thiab hom lossis paste qhov URL hauv lub thawv. Nyem OK.
- Hauv lub thawv Navigator , xaiv cov ntxhuav uas koj xav import. Excel rub tawm cais cov ntsiab lus (text, tables, graphics) yog hais tias nws paub yuav ua li cas parse lawv. Mus import ntau dua ib qho khoom muaj nqis, xyuas kom lub thawv kos rau xaiv Xaiv ntau yam.
- Nyem ib lub rooj rau import ntawm lub thawv Navigator . Ib qho kev tshwm sim tshwm rau ntawm sab xis ntawm lub npov. Yog tias nws ua tau raws li qhov kev cia siab, nias lub khawm Load .
- Excel loads lub rooj rau hauv ib txoj kab tshiab hauv phau ntawv ua haujlwm.
Editing Cov Ntaub Ntawv Ua Ntej
Yog hais tias cov dataset koj xav tau loj heev los yog tsis formatted rau koj cov miv nyuas, hloov nws hauv Query Editor ua ntej koj thauj cov ntaub ntawv los ntawm lub website hauv Excel.
Hauv lub thawv Navigator , xaiv hloov tsis txhob Thauj khoom. Excel yuav thauj khoom mus rau Query Editor es tsis siv cov ntaub ntawv khom nqi. Qhov cuab yeej no qhib lub rooj rau hauv ib lub box tshwj xeeb uas cia koj tswj cov lus nug, xaiv lossis tshem tawm cov kab hauv lub rooj, khaws lossis tshem tawm kab ntawm lub rooj, qhov txawv, cais kab, pawg thiab hloov qhov tseem ceeb, muab cov lus nrog lwm cov ntaub ntawv thiab kho cov tsis ntawm lub rooj nws tus kheej.
Lub Query Editor muaj kev ua haujlwm zoo tshaj plaws uas yog ntau dua akin rau lub chaw ib puag ncig (zoo li Microsoft Access) dua li paub cov ntaub ntawv spreadsheet ntawm Excel.
Ua hauj lwm nrog cov ntaub ntawv Imported
Tom qab koj cov ntaub ntawv hauv Web xa mus rau hauv Excel, koj yuav tau nkag mus rau cov lus nug Cov Ribbon. Cov txheej txheem tshiab no txhawb cov ntaub ntawv-tawm editing (los ntawm Query Editor), kev txhawb zog los ntawm cov thawj cov ntaub ntawv tau los, koom ua ke thiab xa nrog lwm cov lus nug nyob hauv phau workbook thiab sib qhia cov ntaub ntawv nrog lwm cov neeg siv Excel.
Kev xav
Excel txhawb scraping cov ntawv nyeem los ntawm cov websites, tsis yog ntxhuav. Qhov no muaj peev xwm ua tau yog thaum koj xav tau cov ntaub ntawv tawm uas yog siv los tshawb fawb hauv daim ntawv tshaj tawm, tiam sis tsis muaj teeb meem li cov ntaub ntawv ntawm cov ntaub ntawv-piv txwv, chaw teev npe. Excel yuav ua nws qhov zoo tshaj plaws rau import Web cov ntaub ntawv raws li-yog, tab sis qhov tsawg structured cov ntaub ntawv hauv Web, qhov feem ntau yuav nws yog tias koj yuav tau ua ntau lub formatting hauv Excel los npaj cov ntaub ntawv rau kev tsom xam.