exporting table into excel with keeping numbers and images into it

[#1]

Hello,

I have a problem with export from QV to Excel using a macro of tables which contains images as expressions:

I have a table as below (with numbers and smily faces for trends) and I want to export it using a macro directly into an excel file.

My current macro is

aryExport(1,0) = "CH84"
aryExport(1,1) = "Overview on All Products"
aryExport(1,2) = "A10"
aryExport(1,3) = "data"

But, the result of export is a table which does not contains images in the field of trend, but only the definition as below. If I use aryExport(1,3) = "image", it will export me a picture with no right to use data

Working Point	Month	2011 [TRON]	2012 [TRON]	YTD [TRON]
Oradea	Sales 2011	2.398,74	0	2.398,74
	Sales 2012	0	2.383,70	2.383,70
	Delta Abs	-2.398,74	2.383,70	-15,04
	Delta %	-100.00%	n/a	-0.63%
		qmem://<bundled>/BuiltIn/smiley3_r.png	qmem://<bundled>/BuiltIn/smiley1_g.png	qmem://<bundled>/BuiltIn/smiley3_r.png
Halmeu	Sales 2011	0		0
	Sales 2012	0		0
	Delta Abs	0		0
	Delta %	n/a		n/a
		qmem://<bundled>/BuiltIn/smiley3_r.png	qmem://<bundled>/BuiltIn/smiley3_r.png	qmem://<bundled>/BuiltIn/smiley3_r.png
Total	Sales 2011	2.398,74	0	2.398,74
	Sales 2012	0	2.383,70	2.383,70
	Delta Abs	-2.398,74	2.383,70	-15,04
	Delta %	-100.00%	n/a	-0.63%
		qmem://<bundled>/BuiltIn/smiley3_r.png	qmem://<bundled>/BuiltIn/smiley1_g.png	qmem://<bundled>/BuiltIn/smiley3_r.png

Does someone have an idea about what to add into macro script for having the table into excel with those smily faces instead of that text?

Thank you!

Olivia

[Anonymous]

Hi Olivia,

Unfortunately that is not possible as far as I know. Excel seems to only support images floating on top of the cells, not actual images embedded in the cells.

Either try dragging and dropping the object as an OCX object in Excel, or paste a screenshot of it. Those are my only ideas for workarounds.

[#3]

I hope this will be an issue for QV12

[hectorgarcia]

I posted the ide

vote for it