Hi,
how can I insert an image via an csv-file input?
I mean without using the image insert function of the program because the csv file is huge and I can not insert every image manually.
The image is based on the internet: https://myExampleDomain.com/myImage.jpg
Best
??? pretty incomprehensible - What is the content of your csv file and how is this content related to images? Does the question mean: “My csv file contains links to images, one link per line, and I want work through the csv file line by line and insert the respective image in to calc programatically”? If yes - what is your final goal?
BTW: The link doesn’t work
My example csv file content now is (A1, B1, A2, B2):
“ColA”,“ColB”
,A2(now missing),“ImageDescription”
My question is: What would I have to write in cell A2 so that the result after opening the file with LibreOffce Calc is the same as if I would use the program function (and use the link mentioned)?
My original file is very large, and don’t want to insert manually 10,000 images.
I would like to do that somehow via some kind of code defined in the csv file.
For example:
“ColA”,“ColB”
useLinkToDoTheSameAutomaticallyWhatTheInsertImageFunctionDoes(https://myExampleDomain.com/myImage.jpg),“ImageDescription”
useLinkToDoTheSameAutomaticallyWhatTheInsertImageFunctionDoes does not exist, it is just to demonstrate how it could/should work.
PS: How can I format this text, how can I say: NewLine???
Are you assuming that there is already a function allowing to do that by just opening a csv file. If yes - you are wrong. You definitely would need to write a macro. And again: What is the final goal? This sounds a bit like you want to create a some kind of a photo album using calc?
“This sounds a bit like you want to create a some kind of a photo album using calc?”
See answer before
Sorry that I’m so stupid and insisting - you really want to embed (not just create links) 10.000 images into a calc sheet?
yes, why not, I want to see the images in 240x320 px, perhaps in several files with 500 - 1,000 images per file if that is more performant.
CSV simply is the wrong file format for that, it can’t have embedded images. You might use HTML instead.
I know that csv can not have embedded images as it a simple character file.
What do you see in the following csv file code? Is there a 2 in cell C2 or a formular, to calculate the sum so that I have 2 after execute the code in Calc?
“ColA”,“ColB”,“ColC”
1,1,"=SUM(A2:B2)"
I’m searching for a similiar way to load/insert an image from an external URL that will be shown after loading. Something like this:
“ColA”,“ColB”,“ColC”
“INSERT-IMAGE-FILE-CODE(https://myExampleDomain.com/myImage.jpg)”, “My File”, “85MB”
There is no such INSERTIMAGE() spreadsheet function. You maybe could achieve it with a user defined (macro) function, but functions that modify the document content while interpreting them sooner or later ask for trouble.Though in this case where no cell content would be modified (only the drawing layer) it may work.
