Hi,

Iam using the below code and I need to rename the .xls file(otherwise everytime it says that that the excel is open and you need to close it or rename it) using the HTMLFORMTYPE=XLS method.

 -SET &ECHO='ALL';

-*SET FOCEXURL = 'http://myclm/ibi_apps/WFServlet?'

DEFINE FILE CAR
FIRST_HEAD1/A20='Car heading';
SECOND_HEAD2/A10='Period';
A/A3='';
THIRD_HEAD3/A15='Target deadline';
HEAD1/A10='15% to 39%';
HEAD2/A10='40% to 69%';
HEAD3/A11='70% to 100%';
END

TABLE FILE CAR
PRINT
COUNTRY
CAR
MODEL
BODYTYPE
SEATS
DEALER_COST
RETAIL_COST
SALES
LENGTH
WIDTH
HEIGHT
WEIGHT
WHEELBASE
FUEL_CAP
BHP
RPM
HEADING
"Car Categories report"
"SOURCE:CAR Data"
"Data Current as of TODAY"
" "
"<A<FIRST_HEAD1<SECOND_HEAD2<A<THIRD_HEAD3"
"<A<HEAD1<HEAD2<HEAD3"
ON TABLE HOLD AS HOLD_FILE FORMAT HTMTABLE
ON TABLE SET PAGE NOLEAD
ON TABLE SET HTMLCSS OFF
ON TABLE SET STYLE *
TYPE=REPORT,SQUEEZE=ON,FONT='ARIAL',SIZE=12,GRID=ON,TITLETEXT='Car Report',WRAP=OFF,BORDER=.1,$
TYPE=HEADING,HEADALIGN=BODY,$
TYPE=HEADING,LINE=1,JUSTIFY=CENTER,COLSPAN=16,COLOR='BLACK',FONT='ARIAL',SIZE=10,STYLE=BOLD,BORDER=.1,$
TYPE=HEADING,LINE=2,JUSTIFY=CENTER,COLSPAN=16,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD+ITALIC,BORDER=.1,$
TYPE=HEADING,LINE=3,JUSTIFY=CENTER,COLSPAN=16,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD+ITALIC,BORDER=.1,$
TYPE=HEADING,LINE=4,COLSPAN=16,COLOR='BLACK',FONT='ARIAL',SIZE=9,BORDER=.1,$
TYPE=HEADING,LINE=5,ITEM=1,COLSPAN=2,COLOR='BLACK',FONT='ARIAL',SIZE=9,BORDER=.1,$
TYPE=HEADING,LINE=5,ITEM=2,COLSPAN=1,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),BORDER=.1,$
TYPE=HEADING,LINE=5,ITEM=3,COLSPAN=1,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),BORDER=.1,$
TYPE=HEADING,LINE=5,ITEM=4,COLSPAN=6,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BORDER=.1,$
TYPE=HEADING,LINE=5,ITEM=5,COLSPAN=6,JUSTIFY=CENTER,COLOR=RGB(139 0 0),FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),BORDER=.1,$
TYPE=HEADING,LINE=6,ITEM=1,COLSPAN=2,COLOR='BLACK',FONT='ARIAL',SIZE=9,BORDER=.1,$
TYPE=HEADING,LINE=6,ITEM=2,COLSPAN=4,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),BORDER=.1,$
TYPE=HEADING,LINE=6,ITEM=3,COLSPAN=4,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),BORDER=.1,$
TYPE=HEADING,LINE=6,ITEM=4,COLSPAN=6,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),BORDER=.1,BORDER-COLOR=BLACK,$
TYPE=TITLE,FONT='ARIAL',SIZE=9,STYLE=+BOLD-UNDERLINE,COLOR='BLACK',JUSTIFY=CENTER,BACKCOLOR=RGB(169 169 169),$
TYPE=DATA,FONT='ARIAL',SIZE=9,STYLE=NORMAL,BORDER=.1,$
$
ENDSTYLE
END
-RUN
SET HTMLFORMTYPE=XLS
-RUN
-HTMLFORM BEGIN
<style>
table, th, td {
    border: 1px solid black;
	border-collapse: collapse;
	}
td {
    padding-left: 8px;
    padding-right: 8px;
}
</style>
!IBI.FIL.HOLD_FILE;
-HTMLFORM END
-EXIT

 

Can anyone please let me know how to do this?

Regards,
IP

This message has been edited. Last edited by: info4pal,

I'm confused... Why are you saving an XLS as a HTMTABLE / HTMLFORMTYP?

Hi Doug,

Iam using this Method - HTMLFORMTYPE =XLS because of the formatting issues in excel(like borders not aligned properly,font,color etc for the headings).

Regards,
IP

Hi IP

See the updated code in your other post, that should solve this problem as well.

Hi Chuck,

Iam using EXL97 format and your code worked.
Thanks a lot again for all your help on this!

Very much appreciated

Regards,
IP