Excel waa qayb software ah oo aad u awood badan kaas oo samayn kara ku dhawaad ​​xisaab kasta ama xisaabaad macquul ah oo aad rabto. Gurus Excel^(Excel) wuxuu abuuri karaa xaashiyo-falaafeed toosiya habab adag, oo lama huraan u ah ganacsiyo badan inay si wanaagsan u shaqeeyaan.

Dhibka kaliya ayaa ah in galitaanka xogtu ay noqon karto xoogaa hawl kar ah iyo wakhti weyn oo lagu quusiyo. Gaar ahaan haddii xisaabintaadu ay ku xidhan tahay macluumaadka si joogto ah isu beddela. Runtii ma tahay inaad gacanta ku hubiso oo aad ku qorto macluumaadka beddelka wakhti kasta?

Waxay soo baxday in dadka Microsoft ay ka fikireen tan oo Excel   wuxuu awood u leeyahay inuu si toos ah macluumaadka uga soo saaro boggaga internetka. Taas oo^(Which) macnaheedu yahay haddii ay jirto goob la socota qiime gaar ah oo ku jira miiska shabakadda nooc ka mid ah, waxaad ku dhejin kartaa xaashidaada, adoo hubinaya in xisaabintaadu ay tahay mid cusub mar kasta oo faylka Excel laga furo kombuyuutar ku xiran internetka. .

Xitaa ka sii fiican, waxaad dejisan kartaa miis degel adiga kuu gaar ah, laga yaabee inaad isticmaasho hal-abuure shabakad bilaash ah sida Goobaha Google^{(Google Sites)} -ka , oo siinaya hab fudud oo aad ku ilaalin karto xaashida Excel ee aad wadaagto si toos ah. Si^(Sound) aad u fiican u dhawaaq, sax? Haddaba aan hoos ugu dhaadhacno sida ay u shaqeyso.

Ka soo jiidashada xogta ^(Data)bogga internetka^(Website) ee Excel

Waxaan u isticmaali doonaa nooca ugu dambeeyay ee Office 365 ee Excel laga bilaabo Maarso 2019^{(March 2019)} casharkan.

Marka hore, fur Excel oo samee xaashi shaqo maran.

Hadda, u beddel qalabka xogta ^{( Data )}.

Qalabkan ka hoos yimaada Hel oo beddel xogta^{(Get and transform data)} guji From Web . 3

Waxaad ku dhejin kartaa cinwaanka goobta miiska shabakadda ee aad rabto halkan. Xaaladdan oo kale waxaan isticmaaleynaa bogga la yiraahdo ferates.com , kaas oo taxaya jaantusyada hadda jira ee qiimaha sarrifka Mastercard .

Gaar ahaan, waxaanu isticmaali doonaa URL-ka https://ferates.com/mastercard/usd , kaas oo soo bandhigay shaxdan qiimaha sarrifka ee Doolarka Maraykanka^{(US Dollar)} . Jadwalka goobta ayaa u eg sidan:

Ku dheji URL goobta ku habboon oo guji OK .

Tani waxay keenaysaa navigator, qalab ku tusaya qaybaha kala duwan ee shabakada aad dooratay.

Qalabku wuxuu aqoonsaday miis bogga ku yaal, dooro^{(select it)} si aad u aragto haddii ay tahay waxa aan rabno.

Haa! Tani waa sida saxda ah ee aan rabnay, markaa hadda waxa kaliya oo ay tahay inaad sameyso waa guji Load .

Bal eega!

Jadwalka hadda waxa uu ku yaalaa xaashida xisaabaadkaaga oo leh xog toos ah. Waxaad u isticmaali kartaa waxa ku jira sida aad u isticmaali karto miis kasta oo kale, iyada oo faraqa u yahay in tirooyinka mar walba la cusbooneysiiyo.

Retrieve Excel Data From a Web Page Directly

Excel is an incredibly pоwerful piece of software that can do almost any mathematiсal or logіcal calculations уou could want. Excel gurus can create sрreadsheets that automate complex processes, еssential for mаny businesses to operate wеll.

The only problem is that data entry can be a bit of a chore and a major time sink. Especially if your calculations depend on information that changes regularly. Do you really have to manually check and type changing information manually every time?

It turns out that the folks at Microsoft have thought of this and Excel  has the ability to pull information from websites directly. Which means if there’s a site that keep track of a particular value in a web table of some sort, you can plug it in to your spreadsheet, ensuring that your calculations are up to date whenever that Excel file is opened on an internet-connected computer.

Even better, you can set up a website table of your own, perhaps using a free website creator such as Google Sites, providing an easy way to keep Excel sheets you share automatically updated. Sound pretty good, right? So let’s get down to how it works.

Pulling Data From a Website in Excel

We’re going to use the latest Office 365 version of Excel as of March 2019 for this tutorial.

First, open Excel and create a blank worksheet.

Now, switch to the Data toolbar.

On this toolbar under Get and transform data click From Web.3

You can paste the site address for the web table you want here. In this case we are going to use a site called ferates.com, which lists current tables of Mastercard exchange rates.

Specifically, we’ll use the URL https://ferates.com/mastercard/usd, which displays this table of exchange rates for the US Dollar. The table from the site looks like this:

Paste the URL into the appropriate field and click OK.

This will bring up the navigator, a tool that shows you the various components of the website you have selected.

The tool has identified a table on the page, select it to see if it is what we want.

Yes! This is exactly what we wanted, so now all you have to do is click Load.

Lo and behold!

The table is now in your spreadsheet with live data. You can use the contents of it just as you would any other table, with the difference being the figures will always be up to date.

Related posts

• Sida loo kaydiyo bogga internetka PDF ahaan Mac iyo Windows

• Sida loo Beddelayo Bogga Bilawga ee Chrome iyo Browser Kasta oo Shabakad ah

• U isticmaal Excel Qalab ahaan si aad xogta uga koobbiso Shabakadda

• Isticmaalka Interface Web Gudbinta

• Samee App-ka Mareegta oo u orda sida App-ka Desktop-ka

• Hal-Column iyo Xog-urur badan oo Aasaaska ah oo ku kala soocida xaashida faafinta ee Excel

• Koobi ka samee Xogta Laptop-ka ama Hard Drive-ka aan la kabi karin

• Si Toos ah Hoos ugu dhaadhac Bogagga Mareegahaaga

• Sida Xogtaga Shakhsiyeed looga soo dejiyo Google

• Sida loo cusboonaysiiyo browserkaaga

• Sida loogu kaydiyo xogta WhatsApp-kaaga iPhone iyo Android

• Sida loo Gelida Nambarada Bogga Word iyo Google Docs

• Sida Dhakhso iyo Fudud Loogu Badbaadi Lahaa Bogaga Shabkada Word Document

• Sida Loo Sameeyo Chatbot Website Ama Facebook Page

• Sida Loo Daarayo YouTube Mode Madow Shabkada & Mobilka

• Sida loogu beddelo Taxanaha Xogta ee garaafka Excel ama jaantuska

• Sida loogu dabaqo Xaqiijinta Xogta Unugyada Microsoft Excel

• Sida Loo Isticmaalo Discord Iyada oo loo marayo browserka Shabkada

• Sida Si Toos ah Loogu Soo Celiyo Faylasha Google Drive ama OneDrive si Looga Hortago Luminta Xogta

• Sida Loo Sameeyo Bog Shabakad Fudud Oo Bilaash Ah