Jan Vostr Posted December 8, 2021 Share Posted December 8, 2021 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 Link to comment Share on other sites More sharing options...
John Gelona Posted December 10, 2021 Share Posted December 10, 2021 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 Link to comment Share on other sites More sharing options...
Sarah Buccellato Posted December 14, 2021 Share Posted December 14, 2021 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 Link to comment Share on other sites More sharing options...
Jan Vostr Posted January 10, 2022 Author Share Posted January 10, 2022 Thanx a lot of your inputs John and Sarah! Unfortunately I didnt have time to thank you. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now