Insert an image from url in openpyxl
I would like to insert an image from URL into the xlsx file.
How could I do that with openpyxl?
I checked the documentation but not shows how to insert an image from URL.
python image python-3.x url openpyxl
asked Mar 18 '17 at 14:04
KesterKester
2526
add a comment |
I would like to insert an image from URL into the xlsx file.
How could I do that with openpyxl?
I checked the documentation but not shows how to insert an image from URL.
python image python-3.x url openpyxl
asked Mar 18 '17 at 14:04
KesterKester
2526
Possible duplicate of Insert image in openpyxl
– stovfl
Mar 18 '17 at 15:57
add a comment |
I would like to insert an image from URL into the xlsx file.
How could I do that with openpyxl?
I checked the documentation but not shows how to insert an image from URL.
python image python-3.x url openpyxl
asked Mar 18 '17 at 14:04
KesterKester
2526
I would like to insert an image from URL into the xlsx file.
How could I do that with openpyxl?
I checked the documentation but not shows how to insert an image from URL.
python image python-3.x url openpyxl
python image python-3.x url openpyxl
asked Mar 18 '17 at 14:04
KesterKester
2526
asked Mar 18 '17 at 14:04
KesterKester
2526
asked Mar 18 '17 at 14:04
KesterKester
2526
asked Mar 18 '17 at 14:04
KesterKester
2526
asked Mar 18 '17 at 14:04
KesterKester
2526
2526
Possible duplicate of Insert image in openpyxl
– stovfl
Mar 18 '17 at 15:57
add a comment |
Possible duplicate of Insert image in openpyxl
– stovfl
Mar 18 '17 at 15:57
Possible duplicate of Insert image in openpyxl
– stovfl
Mar 18 '17 at 15:57
Possible duplicate of Insert image in openpyxl
– stovfl
Mar 18 '17 at 15:57
add a comment |
1 Answer
1
active
oldest
votes
There is no built-in function in Openpyxl to insert images through URLs. You'll need to use an Http client module for python.(example:urllib)
import openpyxl
from openpyxl.writer.excel import save_virtual_workbook
from openpyxl.drawing.image import Image
import PIL
import io
import urllib3
wb = openpyxl.Workbook()
ws = wb.active
r = 1
ws['A1'] = 'test'
http = urllib3.PoolManager()
r = http.request('GET', 'http://myridia.com/assets/images/logo.png')
image_file = io.BytesIO(r.data)
img = Image(image_file)
ws.add_image(img, 'A2')
Source: Insert image from URL in openpyxl.
You didn't search properly, did you?
answered Mar 18 '17 at 15:50
RottenCandyRottenCandy
335314
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f42875353%2finsert-an-image-from-url-in-openpyxl%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
There is no built-in function in Openpyxl to insert images through URLs. You'll need to use an Http client module for python.(example:urllib)
import openpyxl
from openpyxl.writer.excel import save_virtual_workbook
from openpyxl.drawing.image import Image
import PIL
import io
import urllib3
wb = openpyxl.Workbook()
ws = wb.active
r = 1
ws['A1'] = 'test'
http = urllib3.PoolManager()
r = http.request('GET', 'http://myridia.com/assets/images/logo.png')
image_file = io.BytesIO(r.data)
img = Image(image_file)
ws.add_image(img, 'A2')
Source: Insert image from URL in openpyxl.
You didn't search properly, did you?
answered Mar 18 '17 at 15:50
RottenCandyRottenCandy
335314
add a comment |
There is no built-in function in Openpyxl to insert images through URLs. You'll need to use an Http client module for python.(example:urllib)
import openpyxl
from openpyxl.writer.excel import save_virtual_workbook
from openpyxl.drawing.image import Image
import PIL
import io
import urllib3
wb = openpyxl.Workbook()
ws = wb.active
r = 1
ws['A1'] = 'test'
http = urllib3.PoolManager()
r = http.request('GET', 'http://myridia.com/assets/images/logo.png')
image_file = io.BytesIO(r.data)
img = Image(image_file)
ws.add_image(img, 'A2')
Source: Insert image from URL in openpyxl.
You didn't search properly, did you?
answered Mar 18 '17 at 15:50
RottenCandyRottenCandy
335314
add a comment |
There is no built-in function in Openpyxl to insert images through URLs. You'll need to use an Http client module for python.(example:urllib)
import openpyxl
from openpyxl.writer.excel import save_virtual_workbook
from openpyxl.drawing.image import Image
import PIL
import io
import urllib3
wb = openpyxl.Workbook()
ws = wb.active
r = 1
ws['A1'] = 'test'
http = urllib3.PoolManager()
r = http.request('GET', 'http://myridia.com/assets/images/logo.png')
image_file = io.BytesIO(r.data)
img = Image(image_file)
ws.add_image(img, 'A2')
Source: Insert image from URL in openpyxl.
You didn't search properly, did you?
answered Mar 18 '17 at 15:50
RottenCandyRottenCandy
335314
There is no built-in function in Openpyxl to insert images through URLs. You'll need to use an Http client module for python.(example:urllib)
import openpyxl
from openpyxl.writer.excel import save_virtual_workbook
from openpyxl.drawing.image import Image
import PIL
import io
import urllib3
wb = openpyxl.Workbook()
ws = wb.active
r = 1
ws['A1'] = 'test'
http = urllib3.PoolManager()
r = http.request('GET', 'http://myridia.com/assets/images/logo.png')
image_file = io.BytesIO(r.data)
img = Image(image_file)
ws.add_image(img, 'A2')
Source: Insert image from URL in openpyxl.
You didn't search properly, did you?
answered Mar 18 '17 at 15:50
RottenCandyRottenCandy
335314
edited Nov 24 '18 at 14:32
answered Mar 18 '17 at 15:50
RottenCandyRottenCandy
335314
answered Mar 18 '17 at 15:50
RottenCandyRottenCandy
335314
answered Mar 18 '17 at 15:50
RottenCandyRottenCandy
335314
335314
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f42875353%2finsert-an-image-from-url-in-openpyxl%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Possible duplicate of Insert image in openpyxl
– stovfl
Mar 18 '17 at 15:57