I tried with the schema also , but still showing that warning msg.... :(
<cfset tabstr = "<html
xmlns:o=""urn:schemas-microsoft-com:office:office""
xmlns:x=""urn:schemas-microsoft-com:office:excel"" xmlns=""
http://www.w3.org/TR/REC-html40"";>">
<cfset tabstr= tabstr & "<head><style> @page {margin:.25in .25in .25in
..25in; mso-page-orientation:landscape; mso-header-margin:.25in;
mso-footer-margin:.25in; mso-horizontal-page-align:center;}</style>">
<cfset tabstr= tabstr & "<!--[if gte mso
9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:WorksheetOptions><x:Print><x:LeftToRight/><x:RowColHeadings/></x:Print></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><Table
border='1'>">
<cfset tabstr = tabstr & "<tr>">
<cfloop list="#TheColumnList#" index="TheCol">
<cfset tabstr = tabstr & "<th>"&TheCol&"</th>">
</cfloop>
<cfset tabstr = tabstr & "</tr>">
<cffile action="write" file="C:/a.xls" output="#tabstr#"
attributes="Temporary">
On Feb 4, 2008 10:56 PM, FROEHLING, ROBERT (ATTSI) <[EMAIL PROTECTED]> wrote:
> Try adding the following when creating your HTML output:
>
> <html xmlns:0="urn:schemas-microsoft-com:office:office"
> xmlns:x="urn:schemas-microsoft-com:office:excel"
> xmlns="http://www.w3.org/TR/REC-html40";>
> <body>
> <!--- table data content here --->
> </body>
> </html>
>
>
> -----Original Message-----
> From: Timmy Tom [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 04, 2008 7:58 AM
> To: CF-Talk
> Subject: Re: Excel 2007
>
> <cfcontent type="application/msexcel">
>
> <!--- Suggest default name for XLS file. --->
> <!--- "Content-Disposition" in cfheader also ensures
> relatively correct Internet Explorer behavior. --->
> <cfheader name="Content-Disposition" value="filename=Employees.xls">
>
> <!--- Format data using cfoutput and a table.
> Excel converts the table to a spreadsheet.
> The cfoutput tags around the table tags force output of
> the HTML when
> using cfsetting enablecfoutputonly="Yes" --->
> <cfoutput>
> <table cols="4">
> <cfloop query="GetEmps">
> <tr>
> <td>#Emp_ID#</td>
> <td>#FirstName#</td>
> <td>#LastName#</td>
> </tr>
> </cfloop>
> </table>
> </cfoutput>
>
> when we open the excel file in a machine having office 2003 or earlier
> no
> problem , but when we open that file from a machine having office 2007
> it
> shows this warning msg.
>
> On Feb 4, 2008 7:21 PM, Tom Chiverton <[EMAIL PROTECTED]>
> wrote:
>
> > On Monday 04 Feb 2008, Timmy K Tom wrote:
> > > I created Excel file using coldfusion,
> >
> > How ?
> >
> > --
> > Tom Chiverton
> > Helping to confidentially accelerate visionary materials
> > on: http://thefalken.livejournal.com
> >
> > ****************************************************
> >
> > This email is sent for and on behalf of Halliwells LLP.
> >
> > Halliwells LLP is a limited liability partnership registered in
> England
> > and Wales under registered number OC307980 whose registered office
> address
> > is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3
> 3EB.
> > A list of members is available for inspection at the registered
> office. Any
> > reference to a partner in relation to Halliwells LLP means a member of
> > Halliwells LLP. Regulated by The Solicitors Regulation Authority.
> >
> > CONFIDENTIALITY
> >
> > This email is intended only for the use of the addressee named above
> and
> > may be confidential or legally privileged. If you are not the
> addressee you
> > must not read it and must not use any information contained in nor
> copy it
> > nor inform any person other than Halliwells LLP or the addressee of
> its
> > existence or contents. If you have received this email in error
> please
> > delete it and notify Halliwells LLP IT Department on 0870 365 2500.
> >
> > For more information about Halliwells LLP visit www.halliwells.com.
> >
> >
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:298172
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
