如何为我的exel表格获取一些网站 [英] How do I fetch a number of a website for my exel sheet

问题描述

我有一些带有不同客户名字的excel表格。

我想在这些表格中添加一些我知道的网站上的数字。问题是该表中的客户端数量为数千，并且难以复制和粘贴所有客户端。如果我知道我想要完成那些excel表，我需要查找什么？我需要在该网站上搜索我的客户的每个名字？



我曾尝试过：



此刻没什么..................... .................................................. .................

解决方案

这里没有很多信息可以继续。您想在Excel或外部应用程序中执行此操作吗？需要下载什么 - 它是一个网页，文本文件等...？



如果它是一次性活动，它会更容易手动下载文件，然后格式化，也可以格式化为CSV以便于导入Excel。



然后，您可以使用VLookup（...）公式 [ ^ ]查找要快速填充单元格的数据。无需编程！ ;）

这里没有很多信息可以继续。您想在Excel或外部应用程序中执行此操作吗？需要下载什么 - 它是一个网页，文本文件等...？



如果它是一次性活动，它会更容易手动下载文件，然后将其格式化，可能会导入CSV以便于导入Excel。然后，您可以使用 VLookup（...）公式 [ ^ ]查找要快速填充单元格的数据。无需编程！ ;）

i have some excel sheets with the names of different clients.
And i want to add to those sheets some numbers from a website i know. The problem is that the number of clients in that sheet is in the thousands and will be hard to copy and paste for all of them . What should i look for if i know with what i want to complete those excel sheets and i need to search every name of my clients on that website?

What I have tried:

nothing to this moment ........................................................................................

解决方案

There is not a lot of information here to go on. Are you wanting to do this in Excel or from an external app? What needs to be downloaded - is it a web page, text file, etc...?

If it is a once-off activity, it would be easier to download the file manually, then format it, maybe into a CSV for easy importing into Excel.

Then, you can use the VLookup(...) formula[^] to find the data that you want to populate your cell(s) quickly. No programming required! ;)

There is not a lot of information here to go on. Are you wanting to do this in Excel or from an external app? What needs to be downloaded - is it a web page, text file, etc...?

If it is a once-off activity, it would be easier to download the file manually, then format it, maybe into a CSV for easy importing into Excel. Then, you can use the VLookup(...) formula[^] to find the data that you want to populate your cell(s) quickly. No programming required! ;)

这篇关于如何为我的exel表格获取一些网站的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！