<div>
Updated point value to 500.<br />
<br />
Please help! &nbsp;Thanks in advance!
</div>


<div>
Telling Excel not to wrap the text is straight forward though I'm curious because this is the default behavior.<br />
<br />
Range(&quot;A1&quot;).WrapText = False<br />
<br />
Do you have any more information about how your .html document i sent to excel (from what application, is there any custom code that does the job etc).
</div>


<div>
We are using ODS to send the .html to a .xls file.<br />
<br />
We're trying to solve the problem within the SAS code itself so we don't have to manually modify each Excel sheet that is generated by the SAS Job.<br />
<br />
I've attached the code we use in SAS.<br />

<pre><code class="code-1 nolinks" id="code-125783"><span>ods html file=&quot;[path]\Run List &amp;global_auction..xls&quot;;</span>
<span> </span>
<span> </span>
<span>//code for the title, which we don't want excel to text wrap</span>
<span> </span>
<span>Title </span>
<span>	j=center color=black height=10pt bold</span>
<span>	&quot;Please SELL the following unit(s):&quot;;</span>
</code></pre>
</div>


<div>
In your code do you have a reference or link to the excel object/type library?
</div>


<div>
We're not setting up a library.
</div>


<div>
by library I mean reference to certain files pertaining to Excel in this case. &nbsp;The code snippet you posted, is it from something within SAS? 
</div>


<div>
Yes...the code snippet is from SAS.
</div>


<div>
The excelxp tagset modification fixed the problem. &nbsp;Thank you!
</div>


<div>
<div class="content wysiwyg-content">
A proc report is exported out to an Excel file via ods html. &nbsp;There is a relatively long title to the report. &nbsp;In the Excel file export, the title falls into the first cell and is word wrapped. &nbsp;Is there a way to tell SAS to export that title without word wrapping in one cell (i.e. spanning across several cells in one line)?
</div>
</div>


A proc report is exported out to an Excel file via ods html.  There is a relatively long title to the report.  In the Excel file export, the title falls into the first cell and is word wrapped.  Is there a way to tell SAS to export that title without word wrapping in one cell (i.e. spanning across several cells in one line)?

How to Export SAS Reports to Excel with proper formatting?

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Programming theory deals with the design, implementation, analysis, characterization, and classification of programming languages and their individual features, along with introductory programming concepts like program structure, variable declaration and conditional and looping constructs. Sub-disciplines include the formal semantics of programming languages, type theory, program analysis and transformation, comparative programming language analysis, metaprogramming, domain-specific languages, compiler construction and run-time systems.