> How can I use SpreadsheetSetRowHeight for all rows?
(No points)
As gdemaria mentioned, there's SpreadsheetSetRowHeight. But it doesn't accept a range. You must call it in a loop.
<cfset maxRow = Results.recordCount + (number of header rows)>
<cfloop from="1" to="#maxRow#" index="rowNum">
<cfset SpreadsheetSetRowHeight(sObj, rowNum, (height you want))>
</cfloop>
_agx_
One more thing. I'm pretty sure Excel doesn't have the concept of cell padding like in html tables. AFAIK the best you can get is either change the row height (plus center align) like gdemaria suggested OR add indentation like pravinasar suggested. There is no setting to add padding on all sides.
@DJPro - I think you accidentally omitted pravinasar's response as part of the answer. He mentioned using chr(10) to force a new line. (I just combined both of your answers into a working example.) If you want to reallocate, just use the "Request Attention" link in the original question and the mods can re-open it for you. Cheers!
Pravin Asar
It is weird
I put quite a bit of effort in explaining with cf functions