
September 22nd, 2003, 02:31 PM
|
|
Junior Member
|
|
Join Date: Sep 2003
Location: Montreal,Canada
Posts: 17
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Exporting Excel Images
Hi all - my first time posting here, sorry for any etiquette blunders.
I have taken over a site design project for a customer using ASP and MS-SQL..
They would like an inventory page based on a huge excel file. To start with, they gave me a small one with 200 rows, but they have a bigger 2000 row sheet. Column 1 is a description, column 2 is a unique product id, and column 3 is some sort of copy and pasted image of the product, and I need to display these on the page.
I guess I want to somehow export all the images in the 3rd column into individual jpg files, and name them according to the id. For instance, the image that is sitting in the third column of productid 1234 would be saved as 1234.jpg - then I could export the sheet as a CSV and make a simple database query to display the description, id, and image.
I have no idea how to go about exporting these images from Excel in any convenient fashion, and name them according to another column in the row. Any ideas?
|