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 , August 01, 2018 03:49 PM July 25, 2018, 02:58 AM
JACQUETL is it impossible to integrate images into an excel template? :-/
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.