Hi All,

I need the below HTML output in XLSX format. Can anyone help me on this?


HTML Code:

TABLE FILE CAR
PRINT COUNTRY CAR MODEL BODYTYPE SEATS
WHERE RECORDLIMIT EQ 10
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=DATA,COLUMN=CAR,WIDTH=5.50,WRAP=5.50,$
TYPE=DATA, FONT='ARIAL', SIZE=10, BACKCOLOR=('WHITE' RGB(221 235 247)), COLOR=BLACK,BORDER=LIGHT,$
TYPE=DATA,WHEN= MODEL EQ 'DORA 2 DOOR',STYLE=BOLD,BACKCOLOR=RGB(155 194 230),COLOR=BLACK,$
ENDSTYLE
END
-EXIT

XLSX Code:

TABLE FILE CAR
PRINT COUNTRY CAR MODEL BODYTYPE SEATS
WHERE RECORDLIMIT EQ 10
ON TABLE PCHOLD FORMAT XSLX
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=DATA,COLUMN=CAR,WIDTH=5.50,WRAP=5.50,$
TYPE=DATA, FONT='ARIAL', SIZE=10, BACKCOLOR=('WHITE' RGB(221 235 247)), COLOR=BLACK,BORDER=LIGHT,$
TYPE=DATA,WHEN= MODEL EQ 'DORA 2 DOOR',STYLE=BOLD,BACKCOLOR=RGB(155 194 230),COLOR=BLACK,$
ENDSTYLE
END
-EXIT

Thanks,
Yeshwanth

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

quote:

TYPE=DATA,COLUMN=CAR,WIDTH=5.50,WRAP=5.50,$

To apply such styling in Excel, you need to add a Macro to your Excel or have your report produced from a Template.

Hi All,

I was able achieve it with workaround below.

TABLE FILE CAR
PRINT COUNTRY CAR MODEL BODYTYPE SEATS
WHERE RECORDLIMIT EQ 10
ON TABLE PCHOLD FORMAT XLSX
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=DATA, BACKCOLOR=('WHITE' RGB(221 235 247)),$
TYPE=REPORT,COLUMN=P2,WIDTH=5.50,WRAP=5.50, $
TYPE=DATA,WHEN= MODEL EQ 'DORA 2 DOOR',STYLE=BOLD,BACKCOLOR=RGB(155 194 230),$
TYPE=DATA,COLUMN=P2,STYLE=BOLD,BACKCOLOR=RGB(155 194 230),WHEN= MODEL EQ 'DORA 2 DOOR',$
ENDSTYLE
END
-EXIT

Thanks,
Yeshwanth