Desktop productivity for business analysts and programmers

Excel Output Template

Reply
Valued Guide
Posts: 610

Excel Output Template

I created an HTML template for outputting reports in Enterprise Guide By Clicking Tools > Options > HTML and creating a custom template. 

 

I would like to do something similar with Excel.  Ideally I could create a report then click Send to > Excel and when the Excel document opens it would have a preassigned banner, header, footer, margins, and colors.  Is any of this possible?

 

 

Super User
Posts: 3,856

Re: Excel Output Template

Posted in reply to DavidPhillips2

I suggest you check out ODS style templates - see link. That way you can create a template for your reporting that works not just for HTML but for other types of output as well like Excel, PDF and so on.

 

http://documentation.sas.com/?docsetId=odsproc&docsetTarget=n0t3hg40qj76o0n1sh5ehunqu048.htm&docsetV...

 

 

Ask a Question
Discussion stats
  • 1 reply
  • 155 views
  • 0 likes
  • 2 in conversation