Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Blank rows in Excel between Titles
Chris, I decided to check out the excelxp tagset, and really like the options on it including printing to multiple tabs, being able to include formatting options within proc tabulate and proc report, controlling excel's page set-up within sas, etc. Of course, when we get what we want, we want...- crkraft
- Post #4
- Forum: SAS Institute, Inc. solutions
-
Blank rows in Excel between Titles
Thanks for the info! I did figure it out eventually. Here is the code to write titles directly one after another in Excel, without blank lines in between: ods tagsets.msoffice2k file="test.xls" headtext='<style> h1 {margin:0;} table {margin-top: 1em; margin-bottom: 0em;} </style>'; The "h1...- crkraft
- Post #3
- Forum: SAS Institute, Inc. solutions
-
Blank rows in Excel between Titles
I am using the tagset MSOffice2K and am having trouble with the output in Excel putting a blank row between titles. For example, I have title1 'The University of Alabama'; title2 'C&BA Course Sections'; title3 'Fall 2008'; and want the titles to be in the first three rows of the Excel sheet...- crkraft
- Thread
- Replies: 5
- Forum: SAS Institute, Inc. solutions
