Hello WF family, does anybody has any documentation for Exce...

[Jan Vostr]

Hello WF family,

does anybody has any documentation for Excel Templates I was trying to Google but I wasnt very lucky. Long time ago when I was playing with that and now I am stuck because nor xltx, xltm, xlsx works for me. It just creates xlsx without stuff which is in the template.

ON TABLE SET PAGE-NUM NOLEAD

ON TABLE SET ASNAMES ON

ON TABLE NOTOTAL

ON TABLE PCHOLD FORMAT XLSX TEMPLATE template.xltx SHEETNUMBER 1

ON TABLE SET XLSXPAGESETS ON

ON TABLE SET HTMLCSS ON

 

Thanks a lot for any feedback

Jan

[John Gelona]

We have several hundred, but all of ours have macros so we use .xltm. The actual output is a .xlsm. The macros do things like freeze panes, turn on filters, filtered sub-totals, set borders, etc. Also, you dont need all the other ON TABLE SET commands (we have ASNAMES set in the edasprof). The one we use most with Excel is ON TABLE SET BYDISPLAY ON

[Sarah Buccellato]

Hi Jan,

We have content on Creating Excel XLSX Worksheets Using Templates in the Creating Reports With

TIBCO WebFOCUS Language PDF. This topic starts on page 710 in the PDF linked below. I hope this information is helpful.

 

 

docs.tibco.com

 

 

 

TIB_wfwf_8207.28.0_cr_language.pdf

 

19.02 MB

[Jan Vostr]

Thanx a lot of your inputs John and Sarah! Unfortunately I didnt have time to thank you.