creating xls file in Server

[kann]

hi,
Can we create xls files in server using data form database.
CFFILE tag should be used? what is the attibute for action
copy/write?
thanks
kann

 

[kann]

I got it. I can create using CFFile tag with action as 'Write'. then i can append using action=append. My question is, how can i make bolds, fonts in the data in
xls files from CF.
Thanks
Kann

 

[MarcDePoe]

oof ...
you could always look at an xls file that contains bold font in a simple text editor, try deciphering the jibberish, then append your text along with that jibberish when using cffile.



Good Luck,
Marc

 

[strantheman]

hi kann

You can write an XCEL file by specifying the type of document you wish to write, and making its extension XLS, and putting HTML tables in the file.

We reviewed this a while ago. See post: thread232-67136

let me know if this helped

 

[strantheman]

This should do what you need:

<CFFILE contentType=&quot;application/x-msexcel&quot;
action=&quot;write&quot;
file=&quot;/

http://wwwroot/03292001a.xls&quot;

output =
'

<table border=1>
<tr>
<td><b>Name</b></td>
<td><b>Phone</b></td>
</tr>
<tr>
<td>strantheman</td>
<td>youwish</td>
</tr>
</table>
'>
Test.xls created!<Br><Br>


<!--- add to the file --->
<CFFILE
contentType=&quot;application/x-msexcel&quot;
action=&quot;append&quot;
file=&quot;/

http://wwwroot/03292001a.xls&quot;

output =
'

<table border=1>
<tr>
<td>jackblack</td>
<td>5551212</td>
</tr>
</table>
'>
file added to!

----

Remember, you can use any combination of CFFILE action=&quot;append&quot; if say, you wanted to append only 1 row, not an entire table, for each record returned. Then when you're done looping through the output, close the table.