Billy,
I tried you snippet and am having a problen getting it to open as an xls (it
does open Excel in my browser, but it opens it as a cfm) and
saving as an xls (it tries to save as a cfm). But I would like you to try
running my snippet as excel.cfm and look at what I sumbled over by accident
(maybe you already knew all this, but I sure didn't).
Note the worksheet is named excel (hmmm, can I create multiple worksheets in
a spreadsheet)
click on cell A5 and B5 and notice the Excel formulas are in the worksheet.
Now what do I have to do to insert a macro as well?
What other things can we add dynamically this way? If we can create multiple
worksheets, can we refer to cells in another sheet?
Terry
----- Original Message -----
From: Billy Cravens <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Tuesday, January 23, 2001 2:18 PM
Subject: Re: Bold in excel
> What are you trying to do? If it's a fairly simple issue of creating a
> spreadsheet for a user to download, I don't use COM; I send the user a
> basic HTML table, but give them the right MIME type, which causes it to
> open in Excel, which can then be saved as a native xls (client-side)
> (it also gives them the option to save the file of course, which will
> open in Excel) The advantage is that you can do all your formatting in
> HTML (bold, bgcolor, etc), which appears as you'd like in Excel.
>
> Very basic format:
>
> <CFHEADER NAME="Content-Disposition" VALUE="inline;
> filename=myspreadsheet.xls">
> <cfcontent type="application/vnd.ms-excel">
>
> <table>
>
> <tr>
>
> <td>some data</td>
>
> <td>some data</td>
>
>
> </tr>
>
> <tr>
>
> <td>some data</td>
>
> <td>some data</td>
>
>
> </tr>
>
> <tr>
>
> <td>some data</td>
>
> <td>some data</td>
>
>
> </tr>
>
> </table>
>
>
>
> --
> Billy Cravens
> HR Web Development, Sabre
> [EMAIL PROTECTED]
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
