But, when I actually import the following code into Excel, the HTML tag and
style is imported into the Excel spreadsheet also.
<CFCONTENT type="application/vnd.ms-excel" >
<cfheader name="Content-Disposition" value="Attachment;
filename=pas_data_ref_report.xls" >
<cfoutput query="Q_ref_table" startrow="#startrow#" maxrows="#maxrows#">
<tr>
<cfloop index="i" list="#colList#" delimiters=",">
<td style="mso-number-format:\@" OR class="text">
#trim(Q_ref_table[i][currentrow])#</td>
</cfloop>
</tr>
</cfoutput>
>The way I actually do it is to create a class.
>
><style type="text/css">
> td.text {mso-number-format:"\@";}
></style>
>
><td class="text">00001</td>
>
>I think you're problem is that the format needs to be quoted. Try the
>above.
>
>
>
>leading zeroes from disappearing
>
>I have used that. Here is the code.
><CFCONTENT type="application/vnd.ms-excel" >
><cfheader name="Content-Disposition" value="Attachment;
>filename=pas_data_ref_report.xls" >
><cfelseif (exportType IS 'currentpage')>
><cfoutput query="Q_ref_table" startrow="#startrow#"
>maxrows="#maxrows#">
><!--- BEGIN THIS DISPLAYS ACTUAL REFERENCE DATA RESULTS --->
><tr>
><cfloop index="i" list="#colList#" delimiters=",">
><cfif ListFindNoCase(variables.dateColList,i)>
>#DateFormat(Q_ref_table[i][currentrow],"MM/DD/YYYY")#
><cfelse >
><td style="mso-number-format:\@"
>>#trim(Q_ref_table[i][currentrow])#</td> </cfif>
></cfloop>
></tr>
><!--- END THIS DISPLAYS ACTUAL REFERENCE DATA RESULTS --->
></cfoutput>
></cfif>
>
>It appears in Excel as:
><tr>
><td style="mso-number-format:\@">FBRM</td>
><td style="mso-number-format:\@">1</td>
><td style="mso-number-format:\@">10</td>
><td style="mso-number-format:\@">0000</td>
></tr>
>
>I am at wits end on this one.
>
>Thanks.
>
>You apply that as a style to the specific cells. Something like this
>need
>>something that would act the way the Excel text import wizard does.
>I've
>not
>>sure how/where to apply this style in my coldfusion code so that the
>>Excel spreadsheet reads 0000 instead of 0.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298096
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
