Skip to main content
E
EndoplasmicReticulum
Participating Frequently
April 21, 2011
Question

Insert JPG into Excel

  • April 21, 2011
  • 2 replies
  • 1377 views

I'm using MX7 and I create a JPG file using cfchart but I need to insert that JPG into excel with ColdFusion - how do I do it?

Cfchart is working and I'm saving the file to a location without a problem but can't figure out how to insert it into excel.

This topic has been closed for replies.

2 replies

R
Reed_Powell-ttnmOb
Inspiring
April 25, 2011

There is a tag called CFX_EXCEL that you should look into.  It predates the built-in support in CF for

Excel interfacing, but uses the same POI library.  It supports the use of Excel tempalte files, which allows you to build a spreadsheet  or workbook in Excel, and then use the CF_EXCEL tag to put data into it.  You can build the graphs, etc., in the Excel doc to reference a specific block of cells for their data, and then populate those cells from the CF_EXCEL tag.  maybe put those cells into their own sheet.

-reed

Owainnorth
Owainnorth
Inspiring
April 21, 2011

MX7 doesn't have any direct support for Excel documents, you'd have to check the documentation for the Excel COM objects and see if there's any way of doing it through there.

If there is, you can use createObject("com") and try to interact that way, might be a bit painful mind.

O.

A
Adam Cameron.
Inspiring
April 21, 2011

If there is, you can use createObject("com") and try to interact that way, might be a bit painful mind.

You must really hate EndoplasmicReticulum to be suggesting that

;-)

Nah, I only say that because I had to try to do something like this once and calling Excel via COM in a production environment... really doesn't work very well.  Excel is a desktop app, and doesn't work well being used as a server-side app.

One could look to see if POI handles that sort of thing?

If not, from Excel save a sample of the end result as XML, and unpick the XML to work out what one has to do to recreate such a file dynamically, and then... do that.

--

Adam

Owainnorth
Owainnorth
Inspiring
April 21, 2011
You must really hate EndoplasmicReticulum to be suggesting that

Oh I do, saw something about a rectum endoscopy and instantly went off the guy.

Incidentally, why are you trying to process data, create a chart and then import it into a data processing and charting package?

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices