Have you tried the Excel groups on MSN? Lots of helpful MSCP's over there.
dave
--- On Thu, 11/27/08, Paul Bennett <[EMAIL PROTECTED]> wrote:
From: Paul Bennett <[EMAIL PROTECTED]>
Subject: [advanced_delphi] Inserting an (Database) image into an Excel
spreadsheet
To: advanced_delphi@yahoogroups.com
Date: Thursday, November 27, 2008, 7:49 AM
Hi all,
Can anyone help me with this one?
One of our customers requires that we send him his invoices as xls
files - he wants the spreadsheet to contain a picture of each item
supplied together with a breakdown of the component costs for each item.
Getting the data into the spreadsheet is no problem.
Each of the items has an associated wmf image held in the database as
a blobfield. My plan was to extract the image into a memory stream and
then to create an picture object in the spreadsheet and use the memory
stream to 'load' the image data, however I have yet to find a way of
inserting/creating the picture object in the spreadsheet! !!
Using D7, Windows XP & Excel 2003 (but would probably need a solution
that would work with earlier excel versions).
TIA
Paul
