Loncat ke daftar isi utama

Bagaimana cara mengimpor dan menghubungkan situs web di Excel?

Pernahkah Anda mencoba mengimpor situs web menjadi lembaran dan terus berubah seiring perubahan situs web di Excel? Di sini, saya perkenalkan cara menangani pekerjaan ini di lembar Excel.

Impor dan hubungkan situs web di lembar Excel

Impor dan hubungkan situs web di lembar Excel

Untuk mengimpor dan menyambungkan situs web di lembar Excel, Anda dapat melakukan hal berikut:

1. klik Data > dari Web.
doc impor hubungkan situs web 1

2. Kemudian di Kueri Web Baru dialog, ketikkan alamat situs web yang ingin Anda impor Alamat kotak teks, dan klik Go untuk menampilkan situs web.
doc impor hubungkan situs web 2

3. klik impor, Dan impor data dialog muncul untuk memilih sel atau lembar baru untuk menempatkan konten halaman web. Lihat tangkapan layar:
doc impor hubungkan situs web 3

4. klik OK. Sekarang semua konten halaman web tidak termasuk gambar telah diimpor ke dalam sheet.
doc impor hubungkan situs web 4

5. Kemudian pilih seluruh lembar kerja, lalu klik Data > Properties dalam Koneksi kelompok. Lihat tangkapan layar:
doc impor hubungkan situs web 5

6. Dalam Properti Rentang Data Eksternal dialog, periksa opsi yang Anda butuhkan Segarkan kontrol bagian dan klik OK.
doc impor hubungkan situs web 6

7. Anda juga dapat menyegarkan isi lembar dengan mengklik secara manual Segarkan Semua > Segarkan Semua / Segarkan.
doc impor hubungkan situs web 7

Alat Produktivitas Kantor Terbaik

馃 Kutools AI Ajudan: Merevolusi analisis data berdasarkan: Eksekusi Cerdas   |  Hasilkan Kode  |  Buat Rumus Khusus  |  Analisis Data dan Hasilkan Grafik  |  Aktifkan Fungsi Kutools...
Fitur Populer: Temukan, Sorot, atau Identifikasi Duplikat   |  Hapus Baris Kosong   |  Gabungkan Kolom atau Sel tanpa Kehilangan Data   |   Putaran tanpa Formula ...
Pencarian Super: VLookup Beberapa Kriteria  |   VLookup Nilai Berganda  |   VLookup di Beberapa Lembar   |   Pencarian Fuzzy ....
Daftar Drop-down Lanjutan: Buat Daftar Drop Down dengan Cepat   |  Daftar Drop Down yang Bergantung   |  Multi-pilih Drop Down List ....
Manajer Kolom: Tambahkan Jumlah Kolom Tertentu  |  Pindahkan Kolom  |  Alihkan Status Visibilitas Kolom Tersembunyi  |  Bandingkan Rentang & Kolom ...
Fitur Unggulan: Fokus Kisi   |  Tampilan Desain   |   Bar Formula Besar   |  Manajer Buku Kerja & Lembar   |  Perpustakaan Sumberdaya (Teks otomatis)   |  Pemetik tanggal   |  Gabungkan Lembar Kerja   |  Enkripsi/Dekripsi Sel   |  Kirim Email berdasarkan Daftar   |  Filter Super   |   Filter Khusus (filter tebal/miring/coret...) ...
15 Perangkat Teratas:  12 Teks Tools (Tambahkan Teks, Hapus Karakter, ...)   |   50 + Grafik jenis (Gantt Chart, ...)   |   40+ Praktis Rumus (Hitung usia berdasarkan ulang tahun, ...)   |   19 Insersi Tools (Masukkan Kode QR, Sisipkan Gambar dari Jalur, ...)   |   12 Konversi Tools (Angka ke Kata, Konversi Mata Uang, ...)   |   7 Gabungkan & Pisahkan Tools (Lanjutan Gabungkan Baris, Pisahkan Sel, ...)   |   ... dan banyak lagi

Tingkatkan Keterampilan Excel Anda dengan Kutools for Excel, dan Rasakan Efisiensi yang Belum Pernah Ada Sebelumnya. Kutools for Excel Menawarkan Lebih dari 300 Fitur Lanjutan untuk Meningkatkan Produktivitas dan Menghemat Waktu.  Klik Di Sini untuk Mendapatkan Fitur yang Paling Anda Butuhkan...

Deskripsi Produk

Tab Office Membawa antarmuka Tab ke Office, dan Membuat Pekerjaan Anda Jauh Lebih Mudah

  • Aktifkan pengeditan dan pembacaan tab di Word, Excel, PowerPoint, Publisher, Access, Visio, dan Project.
  • Buka dan buat banyak dokumen di tab baru di jendela yang sama, bukan di jendela baru.
  • Meningkatkan produktivitas Anda sebesar 50%, dan mengurangi ratusan klik mouse untuk Anda setiap hari!
Comments (9)
No ratings yet. Be the first to rate!
Enzo
Enzo
This comment was minimized by the moderator on the site
Hello,
I am wondering about something.
I understand how to connect data from a webpage to Excel, through the URL. Although the URL gives access to one page on the net, but you can switch pages (all the results are not available in onepage, you need to click to the next page and so on). When i connect it to my Excel file, only the first page appears. How could I do this?
Reply
0
0
Roger E Plant
Roger E Plant     Enzo
This comment was minimized by the moderator on the site
Enzo, I open the Web Link and find where the cursor is placed initially. Manually Tab Forward or Backward until you move the cursor to the proper location. COUNT the number of times you pressed the TAB Key and include the appropriate number of "Application.SendKeys" as shown below. Once there you should be able to press the ENTER key to do what you need. I don't know if this will work or not but give it a go. Good luck.


' Tab BACKWARDS SIX (6) times to move from the "Agent ID" input field to the "Enter Shorthand or MLS#" input field.
Application.SendKeys ("+{TAB}")
Application.SendKeys ("+{TAB}")
Application.SendKeys ("+{TAB}")
Application.SendKeys ("+{TAB}")
Application.SendKeys ("+{TAB}")
Application.SendKeys ("+{TAB}")
SendKeys "^v", Yes ' The current session of HGMLS receives the PASTED MLS# (up to 250)
Application.SendKeys ("{TAB}")
SendKeys "~", Yes ' Press ENTER.
Reply
0
0
Roger E Plant
Roger E Plant
This comment was minimized by the moderator on the site
Sunny, thanks for the reply. Indicating that it couldn't be done gave me the incentive to "make it happen". With a combination of "AppActivate" and "Sendkeys" commands, I was able to accomplish my task of jumping from an Excel VBA macro where I copied a list of IDs over to a Chrome link where I pasted those IDs to get information about them, and then jump back to Excel to get the next batch of IDs. It's not the most efficient code BUT it does what I want very nicely. Thanks.
Reply
0
0
Roger Plant
Roger Plant
This comment was minimized by the moderator on the site
To clarify my request a bit. I have cell F1 which contains the code to Link to a website. In my macro, I execute: Range("F1").Hyperlinks(1).Follow and the link is opened. I minimize it after I have done what I need to do in the website and that gets me back into the macro. A few instructions later I am trying to jump back to the url but cannot do so without issuing the same command: Range("F1").Hyperlinks(1).Follow which open another screen but all I want to do is redisplay the already open url. Can't figure it out.
Reply
0
0
Sunny
Sunny     Roger Plant
This comment was minimized by the moderator on the site
Hi, Roger Plant, sorry that there is no way to do this.
Reply
Report
0
0
Roger Plant
Roger Plant
This comment was minimized by the moderator on the site
Thank you for your quick reply. Unfortunately, I am trying to jump to the already opened website from within a VBA macro to automate the process. Thanks for trying.
Reply
0
0
Roger E Plant
Roger E Plant
This comment was minimized by the moderator on the site
I have an OPENED web site and I'd like to jump from a worksheet into that web site, without having to open it again. I'm trying to paste a number of IDs into a field in the Web site to look up their email and address but since I am limited to only 75 ids at a time I need to bounce back and forth copying 75 ids from the worksheet, jump into the web site, paste the data (and look up their information and save it as a PDF), then jump back to the Excel worksheet to copy the next 75 ids, again and again. How can I do this?
Reply
0
0
Logan
Logan
This comment was minimized by the moderator on the site
Thank you so much, I have searching the web all over for this. YOU SERIOUSLY ROCK!!!!! Love from Kansas, US.
Reply
0
0
賳诏丕乇 賵夭蹖乇蹖
賳诏丕乇 賵夭蹖乇蹖
This comment was minimized by the moderator on the site
爻賱丕賲 賲賲賳賵賳 丕夭 賲胤丕賱亘 賲賮蹖丿鬲賵賳... 丕诏乇 賲賵賯毓 丕鬲氐丕賱 賵 丿丕賳賱賵丿 丿蹖鬲丕 丕夭 爻丕蹖鬲 賲賵乇丿 賳馗乇 鬲賯丕囟丕蹖 username 賵 password 讴乇丿 賵 賳丿丕卮鬲蹖賲 丌蹖丕 乇丕賴蹖 賵噩賵丿 丿丕乇賴責 賲賲賳賵賳賲
Reply
0
0
There are no comments posted here yet
Please leave your comments in English
Guest
Posting as Guest
脳
Rate this post:
Reset
0   Characters
Suggested Locations