Hi, thanks in advance for any help!
I have several reports that I am adding to an Excel document. There will be five total tabs, the first being a cover page, and the second will be a table of contents page, the last three will just be basic reports. I would like to add images to the cover page and table of contents, like logos/banners/etc. I am able to add the images with
"TYPE=HEADING,
IMAGE=IBFS:/WFC/Repository/Informatics/AppStudio/Header.jpg,
$"
but they are automatically placed in the top left corner and I cannot move them. I would like one image at the top, then text in the middle, and another image near the bottom. Is there a way to do this? Or a better way to do what I am trying to do? Still pretty new, thanks again for your help!


DEFINE FILE CAR
Blank/A1 = IF COUNTRY EQ COUNTRY THEN ' ' ELSE ' ';
END

TABLE FILE CAR
BY Blank AS ' '
HEADING
" "
" "
" "
" "
" "
" "
" "
" TITLE"
" "
" I"
" a:"
" - 1"
" - 2"
" - 3"
" - 4"
" 4.1"
" "
" b: "
" - 1"
" "
" II"
" a:"
" - 1 "
" 1.1"
" - 2"
" 2.1"
" - 3"
" - 4"
" - 5"
" 5.1"
WHERE RECORDLIMIT EQ 1
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XLSX
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT,
FONT='ARIAL',
SIZE=12,
COLOR='BLACK',
BOTTOMGAP=0.025,
SQUEEZE=1,
$
TYPE=REPORT,
SQUEEZE=8.75,
$
TYPE=HEADING,
IMAGE=IBFS:/WFC/Repository/Informatics/AppStudio/Header.jpg,
POSITION=(0 0),
$
TYPE=HEADING,
IMAGE=IBFS:/WFC/Repository/Informatics/AppStudio/Footer.jpg,
POSITION=(0 200),
$
TYPE=HEADING,
LINE=1,
STYLE=BOLD,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=2,
STYLE=BOLD,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=3,
STYLE=BOLD,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=4,
STYLE=BOLD,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=5,
STYLE=BOLD,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=6,
STYLE=BOLD,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=7,
STYLE=BOLD,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=8,
STYLE=BOLD,
SIZE=18,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=9,
STYLE=BOLD,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=10,
STYLE=BOLD,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=11,
SIZE=9,
BACKCOLOR=RGB(0 63 114),
COLOR=RGB(255 255 255),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=12,
SIZE=9,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=13,
SIZE=9,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=14,
SIZE=9,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=15,
SIZE=9,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=16,
SIZE=9,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=17,
SIZE=9,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=18,
SIZE=9,
BACKCOLOR=RGB(0 63 114),
COLOR=RGB(255 255 255),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=19,
SIZE=9,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=20,
SIZE=9,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=21,
STYLE=BOLD,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=22,
SIZE=9,
BACKCOLOR=RGB(0 63 114),
COLOR=RGB(255 255 255),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=23,
SIZE=9,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=23,
SIZE=9,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=24,
SIZE=9,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=25,
SIZE=9,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=26,
SIZE=9,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=27,
SIZE=9,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=28,
SIZE=9,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=29,
SIZE=9,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=30,
SIZE=9,
COLOR=RGB(0 0 0),
JUSTIFY=LEFT,
$
ENDSTYLE
END

This message has been edited. Last edited by: <Emily McAllister>,

It´s a pain to handle images on excel nowadays.

I got it creating the report on HTMTABLE and then used !IBI.FIL to show it as a XLS.

Can you try this: http://www.informationbuilders...ers/EmbedImagesExcel

Have you tried specifying the line numbers
like, TYPE=HEADING, LINE=1, IMAGE=...., $

It seems ridiculously difficult to get an image into an Excel spreadsheet these days.

Thanks for all your help everyone. I ended up adding a heading and footing and then the images in the style.

TYPE=HEADING, IMAGE=IBFS:/WFC/Repository/Informatics/AppStudio/Header.jpg,
$

TYPE=FOOTING, IMAGE=IBFS:/WFC/Repository/Informatics/AppStudio/Footer.jpg,
$

This added the header to the top of the sheet and the footer on the bottom, both left justified. I had to add some blank lines to adjust the height of everything, but eventually got it to line up close to what I wanted. I never figured out how to place an image in a specific location but this will work for what I need.

I still cant.

 
TABLE FILE CAR
SUM
     CAR.BODY.SALES
BY  CAR.ORIGIN.COUNTRY
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
 -*    INCLUDE = IBFS:/EDA/UNICODE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=HEADING,
     IMAGE=IBFS:/WFC/Repository/vesir218/std_reports/dev/ford_logo.jpg,
$
ENDSTYLE
END

 

I was able to get this to work with XLSX, not EXL2K, by adding

HEADING
" "

After the BY statements. You may need to add some extra blank lines
" "
" "
" "
to get it to line up the way you want.

TABLE FILE CAR
SUM
CAR.BODY.SALES
BY CAR.ORIGIN.COUNTRY
HEADING
" "
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
-* INCLUDE = IBFS:/EDA/UNICODE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=HEADING,
IMAGE=IBFS:/WFC/Repository/vesir218/std_reports/dev/ford_logo.jpg,
$
ENDSTYLE
END

Still no image.

Image appers if I change output to PDF or XSLX.


How can I add a heading on the right of the image?

This message has been edited. Last edited by: Ricardo Augusto,

 

TABLE FILE CAR
SUM
 CAR.BODY.SALES
BY CAR.ORIGIN.COUNTRY
HEADING 
"Heading 1"
"Sub Heading 2"
""
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XLSX
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
 -* INCLUDE = IBFS:/EDA/UNICODE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=HEADING,
 IMAGE=IBFS:/WFC/Repository/vesir218/std_reports/dev/ford_logo.jpg,
 position=(0 0),
 SIZE=(0.6 0.25),
$

TYPE=HEADING, LINE=1, COLOR='RED', COLSPAN=5, JUSTIFY=CENTER, $
TYPE=HEADING, LINE=2, COLOR='RED', COLSPAN=5, JUSTIFY=CENTER, $
-*TYPE=TABHEADING, LINE=1, COLSPAN=2, $
-*TYPE=TABHEADING, LINE=2, COLSPAN=2, $

ENDSTYLE
END