I am using the msoffice2k_x tagset to create an Excel workbook with multiple sheets. I have been successful in creating the workbook, but I am having difficulty figuring out how to change a couple things on my sheets. For instance, if a value is '1-2' in my SAS output, it ends up in Excel looking like 2-Jan. It has been changed to a date value. How do I get around that? Also, the titles don't always align with my tables correctly in Excel. If the table is small, then the title will be much longer than the table. Is there a way to make it only the width of the table? Or at least to center it? Any assistance is appreciated.
... View more