{"id":6559,"date":"2017-10-24T22:11:14","date_gmt":"2017-10-24T14:11:14","guid":{"rendered":"http:\/\/terkini.hargaemas.com.my\/?p=6559"},"modified":"2017-10-25T00:48:11","modified_gmt":"2017-10-24T16:48:11","slug":"10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet","status":"publish","type":"post","link":"https:\/\/hargaemas.com.my\/terkini\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\/","title":{"rendered":"10 Cara menarik harga emas dari laman web ke google spreadsheet"},"content":{"rendered":"

Google spreadsheet adalah clone kepada Microsoft excel, ia adalah percuma dan boleh diakses di https:\/\/sheets.google.com . Dalam perniagaan emas, kemahiran menggunakan excel atau spreadsheet mungkin dapat membantu peniaga dalam jual beli emas contohnya untuk update harga emas terkini, untuk mengira harga beribu-ribu stok barang dengan 1 klik sahaja atau untuk membina simple inventory stok emas tuan-tuan.<\/p>\n

Kepoweran Google sheets kini bukan setakat clone excel semata-mata, malah boleh digunakan untuk membina web ecommerce, inventory management malah untuk scrap harga di website mana-manapun tanpa perlu membina bot, belajar coding dan etc.<\/p>\n

Pada tutorial ini, kami mengajar tuan-tuan cara untuk scrap \/ tarik harga dari laman web emas popular ke google sheets anda.<\/p>\n

\n
    \n
  1. Pertama tuan memerlukan akaun google, buka satu disini jika tiada<\/li>\n
  2. Buka google sheets di sheets.google.com dan create new blank sheets<\/li>\n<\/ol>\n<\/div>\n
    1.Tarik harga dari laman web arrahnu xchange<\/h5>\n

    masukkan code ini pada mana-mana column di google sheets<\/p>\n

    =ImportHTML(\"http:\/\/183.81.165.75\/~rms\/online\/EIS\/goldprice.php\", \"table\", 1)<\/pre>\n
    Jika anda copy paste code diatas, anda sepatutnya mendapat result seperti ini
    \n
    \n\"harga<\/a><\/p>\n
    jadi ini adalah harga arrahnu xchange, harganya berubah setiap hari, untuk auto update sheets anda setiap hari, sila ke<\/p>\n
    files\/spreadsheet settings\/calculation dan set on change every hour atau every day depend kepada kehendak tuan-tuan<\/p>\n
    2. Tarik harga dari laman web yapeim<\/h5>\n
    =ImportHtml(\"http:\/\/yapeim.net.my\/\", \"table\",1)<\/pre>\n
    Ini result sepatutnya anda dapat apabila paste code diatas di mana-mana column<\/p>\n
    \"harga<\/a><\/p>\n
    oleh kerana yapeim menulis harga dalam bentuk string, kira boleh menukarnya kepada bentuk number, cuma isikan code ini disebelah cell yang nak diextract<\/p>\n
    =value(mid(D31,4,3))<\/pre>\n
    D31 itu adalah column harga yapeim *RM196**, sila ubah mengikut no column spreadsheet anda<\/p>\n
    3. Tarik harga kijang emas bank negara Malaysia<\/h5>\n
    =IMPORTHTML(\"http:\/\/www.bnm.gov.my\/index.php\",\"table\",2)<\/pre>\n
    result adalah seperti berikut, harga kijang emas bank negara dikira RM\/oz .. untuk ditukar kepada gram, bahagikan dengan 31.1, harga bank negara update cuma sekali sehari sahaja
    \n    \"harga<\/a><\/p>\n
    4. Tarik harga bank muamalat<\/h5>\n
    =ImportHtml(\"http:\/\/www.muamalat.com.my\/consumer-banking\/Ar-Rahnu\/Ar-Rahnu-Gold-Counter-Rates.html\",\"table\",7)<\/pre>\n
    ini result sepatutnya anda dapat<\/p>\n
    \"harga<\/a><\/p>\n
    5. Tarik harga dari laman web nubex<\/h5>\n
    =ImportHtml(\"https:\/\/www.nubex.my\/chart\/myr_spot_rates4.php\", \"table\",1)<\/pre>\n
    dan ini result sepatutnya anda dapat<\/p>\n
    \"harga<\/a><\/p>\n
    harga nubex adalah liverate, tetapi bagaimana untuk settings up harga nubex ke google sheets emas anda?<\/p>\n
    6. Tarik harga dari laman web public gold<\/h5>\n
    =importhtml(\"https:\/\/www.publicgold.com.my\/\",\"table\", 3)<\/pre>\n
    Laman web PG selalu mengubah kedudukan table harga item mereka, boleh cuba jaya no table di code PG diatas untuk dapatkan table yang anda nak, ini contoh jika tarik harga bar PG ke spreadsheet<\/p>\n
    \"harga<\/a><\/p>\n
    7. Tarik harga emas dari laman web public bank<\/h5>\n
    =ImportHtml(\"https:\/\/www.pbebank.com\/rates\/gold.html\", \"table\",1)<\/pre>\n
    ini ada result dari harga emas public bank, emas yang dijual di bank biasa ada harga jual dan beli je, sbb mereka jual dlm bentuk digital, kadang2 mungkin ada fizikal.. jadi xde table2 karat seperti harga di web arrahnu<\/p>\n
    \"harga<\/a><\/p>\n
    8. Tarik harga dari laman web KFH ( Kuwait Finance House)<\/strong><\/p>\n
    =ImportHtml(\"http:\/\/www.kfh.com.my\/kfhmb\/\", \"table\",3)<\/pre>\n
    KFH adalah sama juga seperti public bank, cuma ada harga jual dan beli sahaja<\/p>\n
    \"harga<\/a><\/p>\n
    9. Tarik harga dari laman web harga emas maybank<\/h5>\n
    =importxml(\"http:\/\/www.maybank2u.com.my\/mbbfrx\/gold_rate.htm\",\"\/\/*[@id='COUNTERRATES_CONVERT_14601']\")<\/pre>\n
    10. Tarik harga dari laman web harga emas CIMB<\/h5>\n
    =IMPORTHTML(\"https:\/\/www.cimbbank.com.my\/en\/personal\/support\/help-and-support\/rates-and-charges.html?c=rates-and-charges&n=gold-investment\", \"table\", 1)<\/pre>\n
    Dari semua-semua table diatas, anda boleh guna function importrange atau =A1 etc dan susun dalam satu table untuk menjadi dashboard untuk monitor harga emas dari semua laman web hanya pada google sheets sahaja, seperti ini<\/p>\n
    \"harga<\/a><\/p>\n
    Ada 5 lagi laman web yang lebih advanced untuk setting up harga liverate, Belilah ebook kami, “Jerung emas online 101” dalam siri akan datang….<\/p>\n
     <\/p>\n","protected":false},"excerpt":{"rendered":"
    Google spreadsheet adalah clone kepada Microsoft excel, ia adalah percuma dan boleh diakses di https:\/\/sheets.google.com . Dalam perniagaan emas, kemahiran menggunakan excel atau spreadsheet mungkin dapat membantu peniaga dalam jual beli emas contohnya untuk update harga emas terkini, untuk mengira harga beribu-ribu stok barang dengan 1 klik sahaja atau untuk membina simple inventory stok emas […]<\/p>\n","protected":false},"author":1,"featured_media":6571,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1468],"tags":[1469],"class_list":["post-6559","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorial","tag-tutorial"],"yoast_head":"\n10 Cara menarik harga emas dari laman web ke google spreadsheet - Hargaemas MY<\/title>\n<meta name=\"description\" content=\"Google spreadsheet adalah clone kepada Microsoft excel, ia adalah percuma dan boleh diakses di https:\/\/sheets.google.com . Dalam perniagaan emas,\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hargaemas.com.my\/terkini\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"10 Cara menarik harga emas dari laman web ke google spreadsheet - Hargaemas MY\" \/>\n<meta property=\"og:description\" content=\"Google spreadsheet adalah clone kepada Microsoft excel, ia adalah percuma dan boleh diakses di https:\/\/sheets.google.com . Dalam perniagaan emas,\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hargaemas.com.my\/terkini\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Hargaemas MY\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hargaemas\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-24T14:11:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-10-24T16:48:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hargaemas.com.my\/terkini\/wp-content\/uploads\/2017\/10\/harga-emas-exchange.png\" \/>\n\t<meta property=\"og:image:width\" content=\"477\" \/>\n\t<meta property=\"og:image:height\" content=\"246\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Shahrul\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@hargaemasMY\" \/>\n<meta name=\"twitter:site\" content=\"@hargaemasMY\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Shahrul\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\\\/\"},\"author\":{\"name\":\"Shahrul\",\"@id\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/#\\\/schema\\\/person\\\/d6bc3e3f7f4ef8a71563c8be246f68f4\"},\"headline\":\"10 Cara menarik harga emas dari laman web ke google spreadsheet\",\"datePublished\":\"2017-10-24T14:11:14+00:00\",\"dateModified\":\"2017-10-24T16:48:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\\\/\"},\"wordCount\":516,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/harga-emas-exchange.png\",\"keywords\":[\"tutorial\"],\"articleSection\":[\"Tutorial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\\\/\",\"url\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\\\/\",\"name\":\"10 Cara menarik harga emas dari laman web ke google spreadsheet - Hargaemas MY\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/harga-emas-exchange.png\",\"datePublished\":\"2017-10-24T14:11:14+00:00\",\"dateModified\":\"2017-10-24T16:48:11+00:00\",\"description\":\"Google spreadsheet adalah clone kepada Microsoft excel, ia adalah percuma dan boleh diakses di https:\\\/\\\/sheets.google.com . Dalam perniagaan emas,\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\\\/#primaryimage\",\"url\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/harga-emas-exchange.png\",\"contentUrl\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/harga-emas-exchange.png\",\"width\":477,\"height\":246,\"caption\":\"harga arrahnu xhange\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"10 Cara menarik harga emas dari laman web ke google spreadsheet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/#website\",\"url\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/\",\"name\":\"Hargaemas MY\",\"description\":\"Maklumat Terkini Emas Malaysia\",\"publisher\":{\"@id\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/#organization\"},\"alternateName\":\"Harga Emas Malaysia\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/#organization\",\"name\":\"Hargaemas Trading\",\"alternateName\":\"Harga Emas Malaysia Trading\",\"url\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/wp-content\\\/uploads\\\/2017\\\/01\\\/hargaemas-logo152px.png\",\"contentUrl\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/wp-content\\\/uploads\\\/2017\\\/01\\\/hargaemas-logo152px.png\",\"width\":152,\"height\":152,\"caption\":\"Hargaemas Trading\"},\"image\":{\"@id\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/hargaemas\",\"https:\\\/\\\/x.com\\\/hargaemasMY\",\"https:\\\/\\\/www.instagram.com\\\/hargaemas\",\"https:\\\/\\\/www.tiktok.com\\\/@hargaemas\",\"https:\\\/\\\/www.pinterest.com\\\/hargaemas\\\/\",\"https:\\\/\\\/t.me\\\/s\\\/hrgms\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/#\\\/schema\\\/person\\\/d6bc3e3f7f4ef8a71563c8be246f68f4\",\"name\":\"Shahrul\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/wp-content\\\/litespeed\\\/avatar\\\/8ca4a2599f4ed82e0bb9654959b64d5c.jpg?ver=1774931411\",\"url\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/wp-content\\\/litespeed\\\/avatar\\\/8ca4a2599f4ed82e0bb9654959b64d5c.jpg?ver=1774931411\",\"contentUrl\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/wp-content\\\/litespeed\\\/avatar\\\/8ca4a2599f4ed82e0bb9654959b64d5c.jpg?ver=1774931411\",\"caption\":\"Shahrul\"},\"url\":\"https:\\\/\\\/hargaemas.com.my\\\/terkini\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"10 Cara menarik harga emas dari laman web ke google spreadsheet - Hargaemas MY","description":"Google spreadsheet adalah clone kepada Microsoft excel, ia adalah percuma dan boleh diakses di https:\/\/sheets.google.com . Dalam perniagaan emas,","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hargaemas.com.my\/terkini\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\/","og_locale":"en_US","og_type":"article","og_title":"10 Cara menarik harga emas dari laman web ke google spreadsheet - Hargaemas MY","og_description":"Google spreadsheet adalah clone kepada Microsoft excel, ia adalah percuma dan boleh diakses di https:\/\/sheets.google.com . Dalam perniagaan emas,","og_url":"https:\/\/hargaemas.com.my\/terkini\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\/","og_site_name":"Hargaemas MY","article_publisher":"https:\/\/www.facebook.com\/hargaemas","article_published_time":"2017-10-24T14:11:14+00:00","article_modified_time":"2017-10-24T16:48:11+00:00","og_image":[{"width":477,"height":246,"url":"https:\/\/hargaemas.com.my\/terkini\/wp-content\/uploads\/2017\/10\/harga-emas-exchange.png","type":"image\/png"}],"author":"Shahrul","twitter_card":"summary_large_image","twitter_creator":"@hargaemasMY","twitter_site":"@hargaemasMY","twitter_misc":{"Written by":"Shahrul","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hargaemas.com.my\/terkini\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\/#article","isPartOf":{"@id":"https:\/\/hargaemas.com.my\/terkini\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\/"},"author":{"name":"Shahrul","@id":"https:\/\/hargaemas.com.my\/terkini\/#\/schema\/person\/d6bc3e3f7f4ef8a71563c8be246f68f4"},"headline":"10 Cara menarik harga emas dari laman web ke google spreadsheet","datePublished":"2017-10-24T14:11:14+00:00","dateModified":"2017-10-24T16:48:11+00:00","mainEntityOfPage":{"@id":"https:\/\/hargaemas.com.my\/terkini\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\/"},"wordCount":516,"commentCount":0,"publisher":{"@id":"https:\/\/hargaemas.com.my\/terkini\/#organization"},"image":{"@id":"https:\/\/hargaemas.com.my\/terkini\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\/#primaryimage"},"thumbnailUrl":"https:\/\/hargaemas.com.my\/terkini\/wp-content\/uploads\/2017\/10\/harga-emas-exchange.png","keywords":["tutorial"],"articleSection":["Tutorial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hargaemas.com.my\/terkini\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/hargaemas.com.my\/terkini\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\/","url":"https:\/\/hargaemas.com.my\/terkini\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\/","name":"10 Cara menarik harga emas dari laman web ke google spreadsheet - Hargaemas MY","isPartOf":{"@id":"https:\/\/hargaemas.com.my\/terkini\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hargaemas.com.my\/terkini\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\/#primaryimage"},"image":{"@id":"https:\/\/hargaemas.com.my\/terkini\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\/#primaryimage"},"thumbnailUrl":"https:\/\/hargaemas.com.my\/terkini\/wp-content\/uploads\/2017\/10\/harga-emas-exchange.png","datePublished":"2017-10-24T14:11:14+00:00","dateModified":"2017-10-24T16:48:11+00:00","description":"Google spreadsheet adalah clone kepada Microsoft excel, ia adalah percuma dan boleh diakses di https:\/\/sheets.google.com . Dalam perniagaan emas,","breadcrumb":{"@id":"https:\/\/hargaemas.com.my\/terkini\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hargaemas.com.my\/terkini\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hargaemas.com.my\/terkini\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\/#primaryimage","url":"https:\/\/hargaemas.com.my\/terkini\/wp-content\/uploads\/2017\/10\/harga-emas-exchange.png","contentUrl":"https:\/\/hargaemas.com.my\/terkini\/wp-content\/uploads\/2017\/10\/harga-emas-exchange.png","width":477,"height":246,"caption":"harga arrahnu xhange"},{"@type":"BreadcrumbList","@id":"https:\/\/hargaemas.com.my\/terkini\/10-cara-menarik-harga-emas-dari-laman-web-ke-google-spreadsheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/hargaemas.com.my\/terkini\/"},{"@type":"ListItem","position":2,"name":"10 Cara menarik harga emas dari laman web ke google spreadsheet"}]},{"@type":"WebSite","@id":"https:\/\/hargaemas.com.my\/terkini\/#website","url":"https:\/\/hargaemas.com.my\/terkini\/","name":"Hargaemas MY","description":"Maklumat Terkini Emas Malaysia","publisher":{"@id":"https:\/\/hargaemas.com.my\/terkini\/#organization"},"alternateName":"Harga Emas Malaysia","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hargaemas.com.my\/terkini\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/hargaemas.com.my\/terkini\/#organization","name":"Hargaemas Trading","alternateName":"Harga Emas Malaysia Trading","url":"https:\/\/hargaemas.com.my\/terkini\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hargaemas.com.my\/terkini\/#\/schema\/logo\/image\/","url":"https:\/\/hargaemas.com.my\/terkini\/wp-content\/uploads\/2017\/01\/hargaemas-logo152px.png","contentUrl":"https:\/\/hargaemas.com.my\/terkini\/wp-content\/uploads\/2017\/01\/hargaemas-logo152px.png","width":152,"height":152,"caption":"Hargaemas Trading"},"image":{"@id":"https:\/\/hargaemas.com.my\/terkini\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hargaemas","https:\/\/x.com\/hargaemasMY","https:\/\/www.instagram.com\/hargaemas","https:\/\/www.tiktok.com\/@hargaemas","https:\/\/www.pinterest.com\/hargaemas\/","https:\/\/t.me\/s\/hrgms"]},{"@type":"Person","@id":"https:\/\/hargaemas.com.my\/terkini\/#\/schema\/person\/d6bc3e3f7f4ef8a71563c8be246f68f4","name":"Shahrul","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hargaemas.com.my\/terkini\/wp-content\/litespeed\/avatar\/8ca4a2599f4ed82e0bb9654959b64d5c.jpg?ver=1774931411","url":"https:\/\/hargaemas.com.my\/terkini\/wp-content\/litespeed\/avatar\/8ca4a2599f4ed82e0bb9654959b64d5c.jpg?ver=1774931411","contentUrl":"https:\/\/hargaemas.com.my\/terkini\/wp-content\/litespeed\/avatar\/8ca4a2599f4ed82e0bb9654959b64d5c.jpg?ver=1774931411","caption":"Shahrul"},"url":"https:\/\/hargaemas.com.my\/terkini\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/hargaemas.com.my\/terkini\/wp-json\/wp\/v2\/posts\/6559","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hargaemas.com.my\/terkini\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hargaemas.com.my\/terkini\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hargaemas.com.my\/terkini\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hargaemas.com.my\/terkini\/wp-json\/wp\/v2\/comments?post=6559"}],"version-history":[{"count":0,"href":"https:\/\/hargaemas.com.my\/terkini\/wp-json\/wp\/v2\/posts\/6559\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hargaemas.com.my\/terkini\/wp-json\/wp\/v2\/media\/6571"}],"wp:attachment":[{"href":"https:\/\/hargaemas.com.my\/terkini\/wp-json\/wp\/v2\/media?parent=6559"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hargaemas.com.my\/terkini\/wp-json\/wp\/v2\/categories?post=6559"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hargaemas.com.my\/terkini\/wp-json\/wp\/v2\/tags?post=6559"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}