{"id":6133,"date":"2024-12-21T13:40:10","date_gmt":"2024-12-21T13:40:10","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/excel-scrape-html-add-in-trich-xuat-du-lieu-html-vao-excel\/"},"modified":"2024-12-21T13:40:10","modified_gmt":"2024-12-21T13:40:10","slug":"excel-scrape-html-add-in-trich-xuat-du-lieu-html-vao-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/excel-scrape-html-add-in-trich-xuat-du-lieu-html-vao-excel\/","title":{"rendered":"EXCEL SCRAPE HTML ADD-IN- Tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u HTML v\u00e0o Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><a href=\"http:\/\/blog.ezworkapp.com\/excel-scrape-html-add-trich-xuat-du-lieu-html-vao-excel.html\"><strong>Scrape HTML Add-In<\/strong> l\u00e0 m\u1ed9t Excel Add-In<\/a> \u0111\u01a1n gi\u1ea3n cho ph\u00e9p b\u1ea1n d\u1ec5 d\u00e0ng thu th\u1eadp n\u1ed9i dung HTML t\u1eeb c\u00e1c website m\u00e0 kh\u00f4ng c\u1ea7n vi\u1ebft m\u00e3 VBA. H\u1ea7u h\u1ebft c\u00e1c c\u00f4ng c\u1ee5\/ add-in d\u00f9ng \u0111\u1ec3 tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u r\u1ea5t ph\u1ee9c t\u1ea1p v\u00e0 kh\u00f4ng linh ho\u1ea1t khi ch\u1ec9 l\u1ea5y m\u1ed9t v\u00e0i th\u00f4ng tin HTML \u0111\u01a1n gi\u1ea3n. <a href=\"http:\/\/blog.ezworkapp.com\/excel-scrape-html-add-trich-xuat-du-lieu-html-vao-excel.html\"><strong>Scrape HTML Add-In<\/strong><\/a> s\u1eed d\u1ee5ng c\u00e1c bi\u1ec3u th\u1ee9c ch\u00ednh quy thay v\u00ec XPath.<\/p>\n<p>Tr\u01b0\u1edbc khi t\u00ecm hi\u1ec3u chi ti\u1ebft, h\u00e3y c\u00f9ng xem v\u00ed d\u1ee5 \u0111\u1ec3 \u00a0th\u1ea5y vi\u1ec7c tr\u00edch title t\u1eeb trang web Google d\u1ec5 d\u00e0ng nh\u01b0 th\u1ebf ch\u1ec9 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng Add-Ins- \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng th\u00e0nh c\u00e1c h\u00e0m:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9924\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/26-09-01-300x41-1.png\" width=\"600\" height=\"81\" title=\"26-09-01-300x41-1\"><\/p>\n<p><strong>N\u00f3 ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o?<\/strong><\/p>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 v\u00ed d\u1ee5 cho t\u1eebng ph\u1ea7n. Ch\u1ee9c n\u0103ng c\u1ed1t l\u00f5i c\u1ee7a Add-In l\u00e0 c\u00e1c h\u00e0m c\u00f3 s\u1eb5n trong Excel ngay sau khi Add-In \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t.<\/p>\n<ul>\n<li><strong>GetElementById<\/strong>\u2013\u00a0 tr\u00edch \u00a0t\u1eebng nh\u00e2n t\u1ed1 HTML \u0111\u01a1n l\u1ebb b\u1eb1ng id t\u1eeb \u00a0trang web.<\/li>\n<li><strong>GetElementByName \u2013 <\/strong>tr\u00edch t\u1eebng nh\u00e2n t\u1ed1 HTML \u0111\u01a1n l\u1ebb b\u1eb1ng t\u00ean t\u1eeb trang web.<\/li>\n<li><strong>GetElementByRegex- <\/strong>tr\u00edch HTML t\u1eeb web b\u1eb1ng c\u00e1c bi\u1ec3u th\u1ee9c ch\u00ednh quy<\/li>\n<li><strong>GetRegex<\/strong>\u2013 tr\u00edch m\u1ed9t \u0111o\u1ea1n v\u0103n b\u1ea3n t\u1eeb v\u0103n b\u1ea3n b\u1ea5t k\u1ef3 b\u1eb1ng c\u00e1c bi\u1ec3u th\u1ee9c ch\u00ednh quy<\/li>\n<li><strong>RegexReplace- <\/strong>thay th\u1ebf t\u1ea5t c\u1ea3 c\u00e1c m\u1eabu bi\u1ec3u th\u1ee9c ch\u00ednh quy th\u00e0nh v\u0103n b\u1ea3n c\u1ee5 th\u1ec3<\/li>\n<li><strong>And more\u2026<\/strong><\/li>\n<\/ul>\n<p>Vi\u1ec7c k\u1ebft h\u1ee3p c\u00e1c h\u00e0m n\u00e0y v\u1edbi nhau s\u1ebd cho ph\u00e9p b\u1ea1n tr\u00edch d\u1eabn \u0111\u01b0\u1ee3c h\u1ea7u h\u1ebft \u0111\u01b0\u1ee3c b\u1ea5t k\u1ef3 n\u1ed9i dung n\u00e0o t\u1eeb website. S\u1eed d\u1ee5ng h\u00e0m<strong> GetElementByRegex <\/strong>\u0111\u1ec3 tr\u00edch l\u1ea5y ph\u1ea7n \u0111\u1ea7u ti\u00ean c\u1ee7a website r\u1ed3i d\u00f9ng h\u00e0m <strong>GetRegex <\/strong>\u0111\u1ec3 v\u00e9t \u0111\u1ebfn n\u1ed9i dung cu\u1ed1i c\u00f9ng. Sau \u0111\u00f3, s\u1eed d\u1ee5ng h\u00e0m <strong>\u00a0RegexReplace<\/strong> cho \u0111\u1ea7u ra.<\/p>\n<p><strong>The Add-In<\/strong><\/p>\n<p>Khi Add-In \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t, n\u00f3 s\u1ebd xu\u1ea5t hi\u1ec7n trong Excel ribbon nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-551.gif\" title=\"ex101_92019-nho-551\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9925\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/29-06-02-300x58-1.png\" width=\"600\" height=\"116\" title=\"29-06-02-300x58-1\"><\/p>\n<p>Add-In bao g\u1ed3m nh\u1eefng \u0111\u1eb7c t\u00ednh sau:<\/p>\n<ul style=\"list-style-type: circle\">\n<li><strong>Insert function<\/strong>\u2013 ch\u00e8n m\u1ed9t trong nh\u1eefng h\u00e0m Get* v\u00e0o \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn<\/li>\n<li><strong>Cache settings<\/strong>\u2013 cho ph\u00e9p b\u1ea1n thay \u0111\u1ed5i b\u1ed9 nh\u1edb \u0111\u1ec7m c\u1ee7a HTML \u0111\u1ec3 t\u0103ng kh\u1ea3 n\u0103ng ho\u1ea1t \u0111\u1ed9ng<\/li>\n<li><strong>Regex Tester<\/strong>\u2013 c\u00f4ng c\u1ee5 \u0111\u1ec3 ki\u1ec3m tra c\u00e1c bi\u1ec3u th\u1ee9c ch\u00ednh quy<\/li>\n<li><strong>Scrape HTML Tool<\/strong>\u2013 c\u00f4ng c\u1ee5 tr\u00edch l\u1ea5y t\u1ea5t c\u1ea3 c\u00e1c ph\u1ea7n kh\u1edbp v\u1edbi m\u1ed9t m\u1eabu c\u1ee5 th\u1ec3 \u0111\u00e3 c\u00f3<\/li>\n<li><strong>Automatic Updating<\/strong>\u2013 c\u00f4ng c\u1ee5 cho ph\u00e9p t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadp v\u1edbi worksheet \u0111\u01b0\u1ee3c ch\u1ecdn (ch\u1ec9 \u00e1p d\u1ee5ng v\u1edbi c\u00e1c h\u00e0m GetElementBy*)<\/li>\n<\/ul>\n<p><strong>Regex Tester<\/strong><\/p>\n<p>Khi tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb trang website, th\u01b0\u1eddng c\u00f3 v\u1ea5n \u0111\u1ec1 x\u1ea3y ra l\u00e0 b\u1ea1n kh\u00f4ng th\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c c\u00e1c bi\u1ec3u th\u1ee9c ch\u00ednh quy c\u00f3 \u0111\u00fang kh\u00f4ng ngay t\u1eeb ban \u0111\u1ea7u. Regex Tester cho ph\u00e9p b\u1ea1n nhanh ch\u00f3ng ki\u1ec3m tra t\u1eebng k\u00fd t\u1ef1. C\u00f4ng c\u1ee5 n\u00e0y ph\u1ea3n \u1ee9ng v\u1edbi b\u1ea5t k\u00ec thay \u0111\u1ed5i n\u00e0o trong c\u00e1c bi\u1ec3u th\u1ee9c \u0111\u01b0\u1ee3c ph\u00ea chu\u1ea9n cho v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c tr\u00edch d\u1eabn. \u0110i\u1ec1u n\u00e0y gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian. H\u00e3y xem video s\u1eed d\u1ee5ng Regex Tester d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><strong>Scrape HTML Tool<\/strong><\/p>\n<p>C\u00e1c h\u00e0m Get* tr\u00edch xu\u1ea5t nh\u1eefng d\u1eef li\u1ec7u c\u1ee5 th\u1ec3 t\u1eeb website. Tuy nhi\u00ean, n\u1ebfu b\u1ea1n mu\u1ed1n nhanh ch\u00f3ng l\u1ea5y \u0111\u01b0\u1ee3c t\u1ea5t c\u1ea3 c\u00e1c th\u00f4ng tin theo m\u1ed9t d\u1ea1ng nh\u1ea5t \u0111\u1ecbnh th\u00ec c\u00f4ng c\u1ee5 Scrape HTML Tool s\u1ebd r\u1ea5t c\u00f3 \u00edch. N\u00f3 c\u00f3 r\u1ea5t nhi\u1ec1u c\u00e1c bi\u1ec3u th\u1ee9c ch\u00ednh quy \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a tr\u01b0\u1edbc nh\u01b0 l\u00e0 tr\u00edch URLs v\u00e0 img src properties.<\/p>\n<p>Xem video d\u01b0\u1edbi \u0111\u00e2y v\u1ec1 c\u00e1ch Scrape HTML Tool l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 gi\u00fap b\u1ea1n:<\/p>\n<p><strong>Caching- l\u01b0u tr\u1eef trong b\u1ed9 nh\u1edb \u0111\u1ec7m<\/strong><\/p>\n<p>\u00dd t\u01b0\u1edfng ch\u1ee7 y\u1ebfu c\u1ee7a Add-In l\u00e0 gi\u1ea3m vi\u1ec7c ph\u1ea3i vi\u1ebft c\u00e1c m\u00e3 VBA. Tuy nhi\u00ean, x\u1ea3y ra v\u1ea5n \u0111\u1ec1 khi s\u1eed d\u1ee5ng c\u00e1c h\u00e0m Get* v\u1edbi c\u00f9ng m\u1ed9t URL b\u1edfi v\u00ec ch\u00fang s\u1ebd qu\u00e1 t\u1ea3i khi ph\u1ea3i download c\u00f9ng m\u1ed9t n\u1ed9i dung HTML nhi\u1ec1u l\u1ea7n. \u0110i\u1ec1u n\u00e0y s\u1ebd \u1ea3nh h\u01b0\u1edfng nghi\u00eam tr\u1ecdng \u0111\u1ebfn qu\u00e1 tr\u00ecnh ho\u1ea1t \u0111\u1ed9ng. \u0110\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y, h\u00e3y s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Cache- l\u01b0u tr\u1eef trong b\u1ed9 nh\u1edb \u0111\u00eam. N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng c\u00f9ng m\u1ed9t URL v\u1edbi h\u01a1n m\u1ed9t h\u00e0m Get* th\u00ec: v\u1edbi \u0111i\u1ec1u ki\u1ec7n l\u00e0 th\u1eddi gian ch\u1edd c\u1ee7a b\u1ed9 nh\u1edb Cache ch\u01b0a h\u1ebft, HTML content s\u1ebd kh\u00f4ng b\u1ecb refresh t\u1eeb Web m\u00e0 ch\u1ec9 t\u1eeb Cache. T\u01b0\u01a1ng t\u1ef1, n\u1ebfu b\u1ea1n c\u00f3 2 h\u00e0m Get* v\u1edbi c\u00f9ng m\u1ed9t URL th\u00ec trong 60s ch\u1edd, ch\u1ec9 c\u00f3 h\u00e0m \u0111\u1ea7u ti\u00ean ph\u1ea3i t\u1ea3i n\u1ed9i dung t\u1eeb Web, trong khi h\u00e0m th\u1ee9 hai kh\u00f4ng c\u1ea7n t\u1ea3i- v\u1edbi \u0111i\u1ec1u ki\u1ec7n l\u00e0 h\u00e0m th\u1ee9 hai ph\u1ea3i \u0111\u01b0\u1ee3c g\u1ecdi tr\u01b0\u1edbc khi 60s ch\u1edd k\u1ebft th\u00fac. B\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i ph\u1ea7n c\u00e0i \u0111\u1eb7t n\u00e0y t\u1ea1i \u201cCache settings\u201d.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9926\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/26-09-03.png\" width=\"500\" height=\"616\" title=\"26-09-03\"><\/p>\n<p><strong>Automatic Updating- T\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadp <\/strong><\/p>\n<p>Khi \u0111\u1ecbnh file Excel \u0111\u1ec3 tr\u00edch d\u1eabn d\u1eef li\u1ec7u t\u1eeb c\u00e1c websites HTML, th\u01b0\u1eddng c\u00f3 v\u1ea5n \u0111\u1ec1 x\u1ea3y ra l\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 refresh (l\u00e0m m\u1edbi) d\u1eef li\u1ec7u t\u1eeb web m\u00f4t c\u00e1ch \u0111\u1ecbnh k\u1ef3. V\u00ed d\u1ee5, b\u1ea1n mu\u1ed1n l\u1ea5y d\u1eef li\u1ec7u v\u1ec1 gi\u00e1 c\u1ed5 phi\u1ebfu v\u00e0 refresh n\u00f3 trong m\u1ed7i 2 ph\u00fat. B\u1ea1n c\u00f3 th\u1ec3 l\u00e0m th\u1ee7 c\u00f4ng, vi\u1ebft m\u1ed9t m\u00e3 VBA th\u00f4ng minh s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Application.OnTime hay ch\u1ec9 \u0111\u01a1n gi\u1ea3n l\u00e0 c\u00e0i \u0111\u1eb7t ch\u1ee9c n\u0103ng refresh theo chu k\u1ef3 trong c\u00f4ng c\u1ee5 Automatic Update c\u1ee7a Add-In.<\/p>\n<p>Xem v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><strong>V\u00ed d\u1ee5 v\u1ec1 tr\u00edch l\u1ea5y m\u1ed9t b\u1ea3ng HTML<\/strong><\/p>\n<p>S\u1eed d\u1ee5ng b\u1ea3ng HTML tr\u00ean trang\u00a0<a href=\"https:\/\/www.w3schools.com\/html\/html_tables.asp\" target=\"_blank\">w3schools<\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9927\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/26-09-04-300x60-1.png\" width=\"600\" height=\"120\" title=\"26-09-04-300x60-1\"><\/p>\n<p>Tr\u00edch m\u1ed7i \u00f4 trong b\u1ea3ng v\u00e0o t\u1eebng \u00f4 Excel ri\u00eang bi\u1ec7t v\u00e0 \u0111i\u1ec1u n\u00e0y ch\u1ec9 m\u1ea5t c\u00f3 v\u00e0i ph\u00fat<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9928\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/26-09-05-300x102-1.png\" width=\"600\" height=\"204\" title=\"26-09-05-300x102-1\"><\/p>\n<p>Th\u1ef1c hi\u1ec7n nh\u01b0 th\u1ebf n\u00e0o?<\/p>\n<p>\u0110\u1ea7u ti\u00ean, h\u00e3y tr\u00edch d\u1eabn c\u1ea3 b\u1ea3ng v\u00e0o \u00f4 B2 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m GetElementbyRegex<\/p>\n<table>\n<tbody>\n<tr>\n<td><code class=\"vb plain\">=GetElementByRegex(<\/code><code class=\"vb string\">\"<a href=\"http:\/\/www.w3schools.com\/html\/html_tables.asp\">http:\/\/www.w3schools.com\/html\/html_tables.asp<\/a>\"<\/code><code class=\"vb plain\">;<\/code><code class=\"vb string\">\"&lt;table class=\"<\/code><code class=\"vb string\">\"reference\"<\/code><code class=\"vb string\">\" style=\"<\/code><code class=\"vb string\">\"width:100%\"<\/code><code class=\"vb string\">\"&gt;([^\"<\/code><code class=\"vb string\">\"]*?)&lt;\/table&gt;\"<\/code><code class=\"vb plain\">)<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y trong m\u1ed9t \u00f4 \u0111\u1ec3 t\u1ed1i \u01b0u workbook (trong tr\u01b0\u1eddng h\u1ee3p worksheet th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n l\u1ea1i th\u00ec n\u1ed9i dung n\u00e0y s\u1ebd kh\u00f4ng ph\u1ea3i t\u1ea3i l\u1ea1i ri\u00eang cho m\u1ed7i \u00f4). Ch\u00fa \u00fd regex\u00a0<strong>([^\u201d]*?)<\/strong>, n\u00f3 c\u00f3 ngh\u0129a l\u00e0 kh\u00f4ng l\u1ea5y t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1, ch\u1ec9 m\u1ed7i b\u1ea3ng n\u00e0y \u0111\u01b0\u1ee3c tr\u00edch d\u1eabn trong bi\u1ec3u th\u1ee9c ch\u1ee9 kh\u00f4ng ph\u1ea3i t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng. S\u1eed d\u1ee5ng k\u00fd t\u1ef1 <strong>(.*)?<\/strong> L\u00e0 kh\u00f4ng \u0111\u1ee7 b\u1edfi v\u00ec d\u1ea5u ch\u1ea5m kh\u00f4ng th\u00edch h\u1ee3p v\u1edbi newlines.<\/p>\n<p>Ti\u1ebfp theo l\u00e0 l\u1ea5y c\u00e1c \u00f4 header ( l\u1ea5y c\u00e1c header ti\u1ebfp theo b\u1eb1ng c\u00e1ch thay \u0111\u1ed5i s\u1ed1 cu\u1ed1i c\u00f9ng t\u1eeb 0-3)<\/p>\n<table>\n<tbody>\n<tr>\n<td><code class=\"vb plain\">=GetRegex(GetRegex($B$1;<\/code><code class=\"vb string\">\"&lt;tr&gt;([^\"<\/code><code class=\"vb string\">\"]*?)&lt;\/tr&gt;\"<\/code><code class=\"vb plain\">;0);<\/code><code class=\"vb string\">\"&lt;th&gt;([^\"<\/code><code class=\"vb string\">\"]*?)&lt;\/th&gt;\"<\/code><code class=\"vb plain\">;0)<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>N\u00f3 l\u1ea5y ra d\u00f2ng \u0111\u1ea7u ti\u00ean v\u00e0 tr\u00edch xu\u1ea5t th\u00e0nh header \u0111\u1ea7u ti\u00ean<\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1c \u00f4 kh\u00e1c (c\u00e1c c\u1ed9t v\u00e0 d\u00f2ng)<\/p>\n<table>\n<tbody>\n<tr>\n<td><code class=\"vb plain\">=GetRegex(GetRegex($B$1;<\/code><code class=\"vb string\">\"&lt;tr&gt;([^\"<\/code><code class=\"vb string\">\"]*?)&lt;\/tr&gt;\"<\/code><code class=\"vb plain\">;1);<\/code><code class=\"vb string\">\"&lt;td&gt;([^\"<\/code><code class=\"vb string\">\"]*?)&lt;\/td&gt;\"<\/code><code class=\"vb plain\">;0)<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>N\u00f3 l\u1ea5y \u00a0ra d\u00f2ng th\u1ee9 hai v\u00e0 tr\u00edch xu\u1ea5t ch\u00fang v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean<\/p>\n<p><strong>T\u00e0i li\u1ec7u<\/strong><\/p>\n<p>T\u1ea3i t\u00e0i li\u1ec7u ho\u00e0n ch\u1ec9nh t\u1ea1i link sau:<\/p>\n<p><a href=\"http:\/\/analystcave.com\/excel-tools\/excel-scrape-html-add\/documentation\/\">T\u00e0i li\u1ec7u<\/a><\/p>\n<p>\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-551.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6134,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6133","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=6133"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6133\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6134"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}