exporting table into excel with keeping numbers and images into it

Wed, 05 Dec 2012 08:44:32 GMT

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

Re: exporting table into excel with keeping numbers and images into it

Anonymous — Wed, 05 Dec 2012 09:10:19 GMT

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.

Re: exporting table into excel with keeping numbers and images into it

Wed, 05 Dec 2012 09:33:20 GMT

I hope this will be an issue for QV12

Re: exporting table into excel with keeping numbers and images into it

hectorgarcia — Wed, 22 Apr 2015 18:01:30 GMT

I posted the ide

vote for it

topic Re: exporting table into excel with keeping numbers and images into it in QlikView

exporting table into excel with keeping numbers and images into it

Re: exporting table into excel with keeping numbers and images into it

Re: exporting table into excel with keeping numbers and images into it

Re: exporting table into excel with keeping numbers and images into it