Add a picture to an Excel file without exporting it

redhotmustang

Is it possible to add a picture in a report to an Excel file without exporting it?

IF CompanyInfo.GET THEN;
CompanyInfo.CALCFIELDS(Picture);

IF CompanyInfo.Picture.HASVALUE THEN BEGIN
   CompanyInfo.Picture.EXPORT('C:\logoNavision.BMP',FALSE);
   LogoCreated := TRUE;
END;

With this code I export a picture to an excel file, but the file is saved on that path C:\.
This is bad, because every computer that runs the report will save that picture on the disk.
I wonder if it is possible to skip the "save to path" part of the process? Meaning that one could send the picture directly from the DB to the Excel sheet.

Thanks in advance.

ajhvdb

What ever way you choose, it is always first saved to disk/memory = disk.

You can delete it after inserting it in excel.

redhotmustang

It's not possible, then?

Maybe if one could save it to some kind of temporary variable... I wonder.

garak

sorry, but in financials you must store the file to disk not C:\ if you are under Terminal Service

viewtopic.php?f=23&t=27187

or

viewtopic.php?f=23&t=28751&hilit=excel+picture

Regards