in Excel, save as HTML, and then view the HTML to see how it persisted the
formatting information.
The only difference of opinion I have is that this technique is extremely
flexible and can be used to accomplish a very wide range of goals. I've
used it extensively for formatting, formulas, and styles. I've also seen
others use it to insert comments into a dynamically generated workbook
(those little red triangles that you mouse over for more information).
The trick is once you save as HTML, incrementally remove things until you've
removed everything other than what you actually need. Then you can know for
sure what tags/attributes create the result you want.
Pay attention to the XML declarations on the root tag. They're required and
even the prefixes must remain the same even though some point to the same
namespace. This is contrary to XML standards but is fact of life when
working with Office HTML/XML/CSS.
MS does have a reference guide for this, Microsoft Office HTML and XML
Reference. It doesn't have a tutorial or examples or anything, just a
reference.
http://msdn.microsoft.com/library/default.asp?url=""> ml/ofxml2k.asp?frame=true
I have some related entries and presentations on my blog, but nothing
directly on point.
HTH,
Sam
----------------------------------------
Blog http://www.rewindlife.com
TeamMM http://www.macromedia.com/go/team
----------------------------------------
> -----Original Message-----
> From: Hagan, Ryan Mr (Contractor ACI)
> [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 19, 2004 1:51 PM
> To: CF-Talk
> Subject: Writing formatted data to Excel
>
> Greetings,
>
> I know that MS has kept .xsl files proprietary, but I was wondering if
> anyone knew any tricks for spitting out some formatted data
> into Excel.
> Basically, I really just want to set the format to a column
> as "currency".
> I can dump a TAB delimited file from CFMX just fine into
> Excel, but that
> extra little bit of formatting would be REALLY nice. Anyone? Thanks!
>
> Ryan Hagan
> ph: 540-731-3588
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
