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]
John Anderson wrote:
>
> Hello,
> I am trying to send data to excel using cfobject.
>
> I can get the data there fine.
>
> The only problem is the formatting on the spreadsheet. The requirement is
> to have the excel file with nice bold headings etc.
>
> Has anyone done this before?
>
> I can find documentation for everything but this.
>
> Thanks,
> John
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
