It's not just you...
However, the following code is a prototype custom tag to place an excel XP
web component in a web page...Enjoy.
<!--- code starts here --->
<cfparam name="attributes.author" default="Steve Drucker">
<cfparam name="attributes.qdata">
<cfparam name="attributes.lcolumns">
<cfsavecontent variable="queryxml"><cfoutput
query="attributes.qdata"><Row><cfloop list="#attributes.lcolumns#"
index="thiscol"><cfset thedata =
evaluate("attributes.qdata.#thiscol#")><Cell><Data <cfif
isnumeric(thedata)>ss:Type="Number"<cfelse>ss:Type="String"</cfif>>#variable
s.thedata#</Data></Cell></cfloop></Row></cfoutput></cfsavecontent>
<cfset queryxml = htmleditformat(queryxml)>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<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";>
<head>
<title>Untitled</title>
</head>
<body>
<div id="Book1_10875" align=center x:publishsource="Excel"><object
id="Book1_10875_Spreadsheet"
classid="CLSID:0002E551-0000-0000-C000-000000000046">
<param name=DisplayTitleBar value=false>
<param name=Autofit value=true>
<param name=DataType value=XMLData>
<param name=XMLData
value="<?xml version="1.0"?> <Workbook
xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<DocumentProperties
xmlns="urn:schemas-microsoft-com:office:office">
<Author>Fig Leaf Software</Author>
<Created>2002-09-28T12:37:05Z</Created>
<Company>Personal</Company>
<Version>10.4219</Version>
</DocumentProperties> <OfficeDocumentSettings
xmlns="urn:schemas-microsoft-com:office:office">
<DownloadComponents/> <LocationOfComponents
HRef="file:///\\"/>
</OfficeDocumentSettings> <ExcelWorkbook
xmlns="urn:schemas-microsoft-com:office:excel">
<PublishObjects> <PublishObject>
<Id>10875</Id>
<DivID>Book1_10875</DivID>
<SourceType>SourceWorkbook</SourceType>
<HtmlType>HtmlCalc</HtmlType> <Location
x:HRef="C:\WINNT\Profiles\sdrucker\Desktop\Book1.htm"/> 
0; </PublishObject> </PublishObjects>
<WindowHeight>9855</WindowHeight>
<WindowWidth>11340</WindowWidth>
<WindowTopX>480</WindowTopX>
<WindowTopY>15</WindowTopY>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook> <Styles> <Style
ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom"/>
<Borders/> <Font/>
<Interior/> <NumberFormat/>
<Protection/> </Style>
</Styles> <Worksheet
ss:Name="Sheet1"> <Table
ss:ExpandedColumnCount="<cfoutput>#listlen(attributes.lcolumns)#</cfout
put>"
ss:ExpandedRowCount="<cfoutput>#attributes.qdata.recordcount#</cfoutput
>" <cfoutput>x:FullColumns="1"</cfoutput>
x:FullRows="1"> <CFOUTPUT>#queryxml# </CFOUTPUT>
</Table> <WorksheetOptions
xmlns="urn:schemas-microsoft-com:office:excel">
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions> </Worksheet>
<Worksheet ss:Name="Sheet2"> <WorksheetOptions
xmlns="urn:schemas-microsoft-com:office:excel">
<TopRowVisible>0</TopRowVisible>
<LeftColumnVisible>0</LeftColumnVisible>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions> </Worksheet>
<Worksheet ss:Name="Sheet3"> <WorksheetOptions
xmlns="urn:schemas-microsoft-com:office:excel">
<TopRowVisible>0</TopRowVisible>
<LeftColumnVisible>0</LeftColumnVisible>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet> </Workbook> ">
<p style='margin-top:100;font-family:Arial;font-size:8.0pt'>To use this Web
page interactively, you must have Microsoft(r) Internet Explorer 4.01
Service
Pack 1 (SP1) or later and the Microsoft Office XP Web Components.</p>
<a href="file:///\\files\owc\setup.exe">Click here to install the Office XP
Web Components.</a>
<p style='margin-top:100;font-family:Arial;font-size:8.0pt'>See the <a
href="http://office.microsoft.com/office/redirect/10/MSOWCPub.asp?HelpLCID=1
033">Microsoft
Office Web site</a> for more information.</p>
</object></div>
</body>
</html>
> -----Original Message-----
> From: Brook Davies [mailto:brook@;maracasmedia.com]
> Sent: Tuesday, October 22, 2002 2:26 PM
> To: CF-Talk
> Subject: RE: CF to excel formatting questions
>
> Is it just me or does CFGRID actually suck?
>
> I just did a search on google for ""Microsoft Office web components", the
> results are scary.
> http://www.google.ca/search?hl=en&ie=UTF-8&oe=UTF-
> 8&q=%22Microsoft+Office+we
> b+components%22&meta=
>
> -Brook
>
> At 02:07 PM 22/10/02 -0400, you wrote:
> >If all of your users have Excel, then you might look into using the
> >Microsoft Office web components. Web components allow you to embed an
> >activeX excel control on a web page -- inheriting the basic Excel
> >functionality. It's really the ultimate CFGRID replacement. Information
> >can be passed to the control as XML.
> >
> >Regards,
> >Steve Drucker
> >CEO
> >Fig Leaf Software
> >www.figleaf.com
> >
> > > -----Original Message-----
> > > From: Janine Jakim [mailto:jjakim@;albemarle.org]
> > > Sent: Tuesday, October 22, 2002 11:14 AM
> > > To: CF-Talk
> > > Subject: CF to excel formatting questions
> > >
> > > I'm using the basic call to excel (as explained by BF in his book)
> because
> > > I
> > > do know that all my users have excel.
> > > My questions:
> > > 1. Can you add an excel toolbar- I want the users to be able to sort
> the
> > > information on any of the columns.
> > > 2. Is there any way to get it so that the headings can wrap. Some of
> my
> > > headings are long so instead of making a long stretchy heading.
> > > Thanks in advance for any help.
> > > J
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
