跳到主要内容

在Excel中轻松地从URL或文件路径插入或显示图像

Kutools for Excel

提升 Excel 300+
强大的功能

通常,要根据相关的 URL 或文件路径插入图像,只有 VBA 代码可以帮助您处理它。 在这里,与 从路径插入图片(URL) 实用程序 Kutools for Excel,只需单击几下,您就可以在 Excel 中快速插入来自给定 URL 或文件路径的图像。

从Excel中的URL插入/显示图像

从Excel中的文件路径插入/显示图像


单击Kutools>插入>从路径(URL)插入图片…以启用该功能


从Excel中的URL插入/显示图像

要从URL插入图像,请执行以下操作。

1.单击以启用该功能 库工具 > 插页 > 从路径插入图片(URL).

2.在 从路径插入图片(URL) 对话框,请:

  • 1)选择要根据其中插入图片的URL的单元格范围 路径(URL)范围 部分;
  • 2)选择一个空白单元格,您将在其中输出图像 插入范围(一个单元格) 部分;
  • 3)在中指定您需要的图片尺寸 图片尺寸(像素) 部分;
  • 4)点击 OK 按钮。 看截图:

然后,根据给定的URL显示所有图片,如下图所示。


从Excel中的文件路径插入/显示图像

如果要显示文件路径中的图像,请尝试以下操作。

1.单击以启用该功能 库工具 > 插页 > 从路径插入图片(URL).

2.在 从路径插入图片(URL) 对话框,请完成以下设置:

  • 1)在 路径(URL)范围 部分中,选择包含将基于其显示图片的文件路径的单元格;
  • 2)在 插入范围(一个单元格) 部分,选择一个单元格,您将输出图像;
  • 3)在中指定您需要的图片尺寸 图片尺寸(像素) 部分;
  • 4)点击 OK 按钮。 看截图:

现在,根据给定的路径将图片插入特定的单元格中。 看截图:

备注:

1.如果您检查 添加原始图像作为评论 此对话框中的框,图像将同时以原始尺寸插入评论中。

2.根据Excel规范和限制(https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3),插入图片的宽度必须小于2045像素,固定高度必须小于547像素。

3.如果超出指定的大小限制,插入的图片将被自动调整。


演示:使用 Kutools for Excel 从路径或 URL 插入图片

Kutools for Excel:300 + Excel 中必须具备的功能, 从这里免费试用30天


生产力工具推荐
以下工具可以极大地节省您的时间和金钱,哪一种适合您?
Office Tab: 在办公室中使用方便的选项卡,作为Chrome,Firefox和New Internet Explorer的方式。
Kutools for Excel: 超过300种Excel高级功能 2021、2019、2016、2013、2010、2007 和 Office 365。

Kutools for Excel

上述功能只是 Kutools for Excel 300 个强大功能之一。

专为 Excel(Office) 2021、2019、2016、2013、2010、2007 和 Office 365 设计。免费下载和使用 30 天。

Kutools for Excel 的屏幕截图

btn了解更多      btn下载     btn购买

Comments (17)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Dear team, I have followed these steps correctly, but the resulting output says "picture(s) failed to be inserted". Give me a solution to solve this problem... Thanks you
This comment was minimized by the moderator on the site
I have followed these steps correctly, but the resulting output says "picture(s) failed to be inserted". Give me a solution to solve this problem pleasee... Thanks you
This comment was minimized by the moderator on the site
when i use the split data it doesnt grab the images accordingly and im splitting my workbook into aprox 50 sheets is there a better way to do this without going through each workbook
This comment was minimized by the moderator on the site
Hi rafa,
The Split Data function does not yet support processing images. Sorry for the inconvenience.
This comment was minimized by the moderator on the site
Dear team,
When I added the images matching column through kutools which I just purchased to solve my problem after spending 52USD, still my problem persists, as the image quality becomes worse on its own after adding thrugh kutools in excel. Please help.
This comment was minimized by the moderator on the site
Hi akshay,

To solve this problem, please select File > Options to open the Excel Options window. Then select Advanced in the left pane, check the Do not compress images in file checkbox and then click OK to save the changes.
https://www.extendoffice.com/images/stories/comments/comment-picture-zxm/insert-file-by-path.png?1698389451
This comment was minimized by the moderator on the site
Dear team,
When I added the images matching column through kutools which I just purchased to solve my problem after spending 52USD, still my problem persists, as the image quality becomes worse on its own after adding thrugh kutools in excel. Please help.
This comment was minimized by the moderator on the site
Hi,

Does this feature not work if the URL link is a formula?

I connected to Anaplan module which displays the account logo link based on the user selection of specific account name. This way the in the other tab the table information (coming from separate Anaplan module) is updated based on the user selection of account name and the link would also update based on same to populate the grid and the logo image.
This comment was minimized by the moderator on the site
Hi Claudia,

This feature does not work in formula cells. Sorry for the inconvenience.
This comment was minimized by the moderator on the site
I have a spreadsheet I use for a list of names.
The cells have the names.
Some of the cells would have the same picture.
(Think of a family list for ancestry)
To have the same picture show more than once would make the file very large.

Is it possible to have two worksheets in the same workbook.
One sheet is for only pictures.
The other sheet shows the names, the names of parents.

Can I put a code (similar to html) that can show the same picture more than once.
Not embed, that would make the file size too large.
But only to show the picture with a click.
Another click hides the picture.

When the workbook is closed, only the original pictures on their own sheet are retained.

Showing this same procedure inside a comment would be fantastic too.
(This way, embed picture once, show many.
This comment was minimized by the moderator on the site
Hi Jane Anderson,
This feature has been upgraded to include the "add original image as comment" option, please watch out for our new release.
You can select a cell in another worksheet as the picture storage area to separate the picture worksheet from the original data worksheet.
But this feature will not help you to achieve inserting pictures based on names only, you need to provide the picture storage path. Or you can use the "Match Import Picture" fearure to handle this problem.
This comment was minimized by the moderator on the site
Not able to extract the images from url path
Picture fail to insert error
This comment was minimized by the moderator on the site
Hi Vivek Desai,
We have improved this feature, please download this version and give it a try. Sorry for the inconvenience.
Click to download Kutools for Excel 27.00
This comment was minimized by the moderator on the site
Hello,

Insert/Display Images From File Paths In Excel is not working, would you please help me.
This comment was minimized by the moderator on the site
Hi Ayman,
Can you provide the specific data, such as the file path, the URL of the picture, etc.
It would be nice if you can uploade a screenshot of the data.
This comment was minimized by the moderator on the site
No funciona en Windows 11 ni en Windows 10 esta funcion... aun no he probado en Win7... y he probado la version 21 y 24 de kutools.. que horrible que lo publiciten tanto.... Cuando lo mando a trabajar, se poco antes de llegar al 100% se pega, independiente de usar otro ser de url o no....
This comment was minimized by the moderator on the site
Hi dj.Clearme,
This feature was successfully tested on Win10 and Win11. Did you get any error prompt? I need to know more specific about your issue.
You can download the latest version 26.00: https://www.extendoffice.com/download/kutools-for-excel.html or contact us via to send us feedback on specific questions.
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations