ods tagsets.excelxp formats with bigger cells

[SASAna]

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

[Cynthia_sas]

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