PDA

View Full Version : Excel gurus - How to make picture catalog


DavidRSA
02-24-2010, 12:20 PM
Hi there... I am trying to find if there is a way to automatically pull images into excel. Let's say I have a database of images. If I put the filename of the image into excel, is there a way to automatically have the image appear in an adjacent column? (Kinda like a vlookup but pulls images instead of data.)

Any help will me much appreciated. Thanks!

Rivers
02-25-2010, 5:17 PM
I know that you can with Filemaker. That's a real database program, not a spreadsheet program.

aGunForEachHand
02-25-2010, 7:44 PM
No function to do this that I am aware of, and I consider myself an Excel power user.

command_liner
02-25-2010, 8:30 PM
Hi there... I am trying to find if there is a way to automatically pull images into excel. Let's say I have a database of images. If I put the filename of the image into excel, is there a way to automatically have the image appear in an adjacent column? (Kinda like a vlookup but pulls images instead of data.)

Any help will me much appreciated. Thanks!

In general this is not possible. The MS image processing tools fail to
operate on images with more than 2^32 pixels, cannot make low res
images and fail. And they take a long time to do it. Lots of real images
have more than that many pixels. I deal with about 1000 a day.

A quick way to get a basic functionality is to open a _directory_ of
images with the Windows image viewer. Naturally you can just use
Explorer under Windows or Finder on the Mac to do something similar.

** 23 years of working with high-resolution digital images every day **

Corbin Dallas
02-25-2010, 8:35 PM
images in excel, no.

Access, yes.

Funbaby
02-26-2010, 11:40 AM
Never found a way to do it automatically.

Macadelic4
02-26-2010, 9:43 PM
May I suggest a web-based "Content Management System"? I know that may be kinda overkill depending on what you want to do, but in the long-run you'll probably have more flexibility.

And if you're doing this for a business, getting a local webserver/DB running now will make those future "gee, wouldn't it be nice if we had a <xyz> system..." moments a LOT easier to deal with. PM me for details.

stilly
06-25-2013, 8:46 AM
Hi there... I am trying to find if there is a way to automatically pull images into excel. Let's say I have a database of images. If I put the filename of the image into excel, is there a way to automatically have the image appear in an adjacent column? (Kinda like a vlookup but pulls images instead of data.)

Any help will me much appreciated. Thanks!

I am a bit confused. Perhaps the terms are not being used properly.

Excel is a SPREADSHEET, not a database. You can manipulate data in it once you have entered it, but if you already have an image database, then...

What exactly are you doing with this stuff? Limited number of phtos or ever growing? For catalogging images I would go with an already made photo manager that allows you to TAG them with words/names. I would recco ACDSee but well, they have fallen from the graces.

Excel is meant to display textual data from what I understand. You CAN insert photos, but that would be a LOT of work to shrink them down and manipulate them. NOT recommended.



Well, I just find one useful tutorial: http://www.xflip.com/tutorials/creat...rom-excel.html
well, great topic, our company would give it a try, thanks!


:ban:

That is not a tutorial for Excel. Welcome to calguns...

I just found the cracked enterprise version of that program and will be seeing if it is as good as it says it is...

ocabj
06-25-2013, 9:30 AM
If you already have a database with images, why not just create tables in that database with the data from your spreadsheet and link/join the tables/columns as necessary to generate the desired output?

stilly
06-25-2013, 3:04 PM
If you already have a database with images, why not just create tables in that database with the data from your spreadsheet and link/join the tables/columns as necessary to generate the desired output?

No doubt. I am not an expert in this area, but it seems like someone is trying to upgrade from the wheel to walking...

Link tables, sounds like a job fast approaching sql server...