Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

exporting table into excel with keeping numbers and images into it

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.

yearly comparison.png

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 PointMonth2011 [TRON]2012 [TRON]YTD [TRON]
OradeaSales 20112.398,7402.398,74
Sales 201202.383,702.383,70
Delta Abs-2.398,742.383,70-15,04
Delta %-100.00%n/a-0.63%
qmem://<bundled>/BuiltIn/smiley3_r.pngqmem://<bundled>/BuiltIn/smiley1_g.pngqmem://<bundled>/BuiltIn/smiley3_r.png
HalmeuSales 20110 0
Sales 20120 0
Delta Abs0 0
Delta %n/a n/a
qmem://<bundled>/BuiltIn/smiley3_r.pngqmem://<bundled>/BuiltIn/smiley3_r.pngqmem://<bundled>/BuiltIn/smiley3_r.png
Total Sales 2011 2.398,7402.398,74
Sales 2012 02.383,702.383,70
Delta Abs-2.398,742.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

3 Replies
Anonymous
Not applicable
Author

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.

Not applicable
Author

I hope this will be an issue for QV12

hectorgarcia
Partner - Creator III
Partner - Creator III

I posted the ide

vote for it