Sebelisa dintlha ho tswa ho litafole tsa Inthanete ka hare ho Microsoft Excel
Tšobotsi e 'ngoe e tsebahalang haholo ea Excel ke matla a eona a ho kenya Liwebsaete . Sena se bolela hore haeba o ka fihlella ditshwantsho ho websaeteng, ho bonolo hore oe fetole ho spreadsheet ea Excel haeba leqephe la Websaete le hlongoa hantle. Ts'ebetso ena ea ho kenya ho u thusa hore u sekaseke data ea Web ho sebelisa mekhoa e tloaelehileng ea Excel le li-interfaces.
Lintlha tsa ho taka
Excel ke sesebelisoa sa spreadsheet se khabisitsoeng bakeng sa ho hlahloba boitsebiso ka mochini oa bobeli. Kahoo, haeba o tla kenya data ho tsoa leqepheng la websaete ho Excel, mofuta o motle haholo o tšoana le tafole. Excel e tla kenya tafoleng e 'ngoe le e' ngoe leqepheng la Websaete, litafole tse tobileng feela, kapa esita le litemana tsohle tse leqepheng lena-le hoja e sa hlophiseha data, ho feta moo ho kenngoa ha lintho ho tla hloka ho tsosolosoa pele u ka sebetsa le eona.
Kenya litaba
Ka mor'a hore u fumane sebaka sa marang-rang se nang le boitsebiso boo u bo hlokang, kenya lintlha ho Excel.
- Bula Excel.
- Tobetsa Taba ea Data mme u khethe ho Websaete sehlopheng sa Get & Transform Data .
- Ka lebokoseng la lebokose, khetha Basic le ho thapa kapa kenya URL ka lebokoseng. Tlanya OK.
- Ka lebokoseng la Navigator , khetha litafole tseo u lakatsang ho li kenya. Excel e leka ho arola li-blocks tse fapaneng (litlhaku, litafole, litšoantšo) haeba e tseba ho li arola. Ho kenya chelete e fetang e le 'ngoe ea thepa, etsa bonnete ba hore lebokose le hlahlojoa bakeng sa Khetha lintho tse ngata.
- Tobetsa tafoleng ho e kenya ho lebokose la Navigator . Ponahalo ea pele e hlaha ka lehlakoreng le letona la lebokose. Haeba e finyella litebello, tobetsa konopo ea Load .
- Excel e jara tafole tabeng e ncha bukeng ea mosebetsi.
Ho Fetola Dintlha Pele U ka Reka
Haeba dataset eo u e batlang e kholo haholo kapa e sa e fetisetsoe ho seo u se lebeletseng, e fetoloe ho Query Editor pele o laela data ho websaete ea hau ho Excel.
Ka lebokoseng la Navigator , khetha Edit ho e-na le Mojaro. Excel e tla jarisa tafole ho Query Editor ho e-na le spreadsheet. Sesebelisoa sena se bula tafole lebokoseng le khethehileng le etsang hore u laole potso, khetha kapa u tlose melafo tafoleng, u boloke kapa u tlose mela e tsoang tafoleng, ho hlophisa, mekhako e arohaneng, sehlopha le ho nka litekanyetso, kopanya tafole le mehloli e meng ea litaba le fetola meeli ea tefo ka boeona.
Query Editor e fana ka tshebetso e tsoetseng pele e amanang le tikoloho ya ditshwantsho (e kang Microsoft Access) ho feta disebediswa tse tloaelehileng tsa spreadsheet tsa Excel.
Ho sebetsana le Dintlha tse Ngotsoeng
Ka mor'a hore dintlha tsa hau tsa Inthanete li kenelle Excel, u tla ba le tokelo ea ho etsa lipapali tsa Query Tools. Melao ena e ncha e tšehetsa lisebelisuoa tsa mohloli oa data (ho feta ka Query Editor), e khathollang ho tloha mohloling oa pele oa data, ho kopanya le ho tsamaisana le lipotso tse ling bukeng ea ho sebetsa le ho arolelana le data e senyehileng le basebelisi ba bang ba Excel.
Tlhokomelo
Excel e tšehetsa ho senya mangolo ho tsoa mawebsaeteng, eseng feela litafole. Bokhoni bona bo molemo ha o hloka ho kenya tlhahisoleseding e sebelisitsoeng ka mokhoa o sebelisitsoeng ka fensetere empa ha e hlophisoe joaloka data-tabeng, hothathamo ea aterese. Excel e tla etsa sohle se matleng a bona ho kenya ditshwantsho tsa Websaete ka-, empa e sa hlophiseha data ya Websaete, ho ka etsahala hore o tla tlameha ho etsa mekhoa e mengata ka har'a Excel ho lokisetsa lintlha tsa tlhahlobo.