Focal Point
[CLOSED] EXCEL TEMPLATE IMAGE

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1427006096

July 24, 2018, 09:57 AM
JACQUETL
[CLOSED] EXCEL TEMPLATE IMAGE
Hi

If i run this code with PCHOLD XLSX

 
TABLE FILE CAR
PRINT
MODEL
BY COUNTRY
 NOPRINT PAGE-BREAK
HEADING
" line1"
" line2"
" "
" line4"
""
FOOTING BOTTOM
" "
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
UNITS=IN, PAGESIZE='A4', ORIENTATION=LANDSCAPE,
SIZE=7,FONT=ARIAL,
LEFTMARGIN=0.300000, RIGHTMARGIN=0.300000,
TOPMARGIN=0.100000,  BOTTOMMARGIN=0.300000,
SQUEEZE=0.1527,JUSTIFY=CENTER,
LEFTGAP=0.06,RIGHTGAP=0.06,$
TYPE=REPORT, COLUMN=P1, WRAP=1, BACKCOLOR='YELLOW', $
TYPE=DATA,   COLUMN=P1, JUSTIFY=LEFT,$
TYPE=REPORT, COLUMN=P2, WRAP=0.8, BACKCOLOR='YELLOW', $
TYPE=DATA,   COLUMN=P2, JUSTIFY=CENTER,$
TYPE=DATA,  GRID=ON,$
TYPE=TITLE, GRID=ON, STYLE=BOLD, SIZE=8, $
TYPE=HEADING, STYLE=BOLD, COLOR=NAVY, SIZE=14, TOPGAP=0.02,$
TYPE=HEADING, IMAGE='d:\ibi\apps\technique\img\img.gif',POSITION=(9.5 0),SIZE=(1.5 0.8),$

TYPE=FOOTING, STYLE=BOLD, COLOR=NAVY, SIZE=9,JUSTIFY=LEFT,$
ENDSTYLE


Result : picture appear

if i run code with TEMPLATE :

 
ON TABLE PCHOLD FORMAT XLSX TEMPLATE 'template_excel.xltm' SHEETNUMBER 2


the picture does not appear..

someone to an idea of ​​why the picture does not appear anymore

This message has been edited. Last edited by: FP Mod Chuck,


Webfocus 8.201M.
Windows
InfoAssist +
Chrome, IE, Excel, HTML; PDF, AHTML,GRAPH
July 25, 2018, 02:58 AM
JACQUETL
is it impossible to integrate images into an excel template? :-/


Webfocus 8.201M.
Windows
InfoAssist +
Chrome, IE, Excel, HTML; PDF, AHTML,GRAPH
July 25, 2018, 10:39 AM
FP Mod Chuck
Jacquetl

I found this in a case on techsupport..

The ability to use images and logos with XLSX templates not supported. There is an existing New Feature Request. Targeted post 8203, considered a major project.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
July 25, 2018, 10:55 AM
JACQUETL
oh sniff !

Thanks for this answer..


Webfocus 8.201M.
Windows
InfoAssist +
Chrome, IE, Excel, HTML; PDF, AHTML,GRAPH