topic ods tagsets.excelxp formats with bigger cells in SAS Programming

ods tagsets.excelxp formats with bigger cells

SASAna — Fri, 12 Apr 2019 12:05:31 GMT

Hi SAS Team,

I am using ods tagsets.excelxp for Excel data reporting and the sheet has bigger cell sizes than the value. How to fix this?

ods tagsets.excelxp file="test.xls" style = minimal headtext="<style> td {mso-number-format:\@}</style>"
options(embedded_titles='yes' sheet_name="Summary");

ODS LISTING CLOSE;

proc report data = output_data ;
column _all_;
title;

run;

Thanks,

Ana

Re: ods tagsets.excelxp formats with bigger cells

Cynthia_sas — Fri, 12 Apr 2019 14:05:27 GMT

Hi:
You have several choices:
There is an absolute column width suboption, a default column width suboption and you can always use width= in a style override on the define statement.

There have been a lot of previous postings on altering cellwidth in the Forums. I'd recommend seaerching in the ODS and Reporting forum.
Cynthia