I just base it off of time and CFID...
<cfset ranport="T"&CFID&TimeFormat(Now(),"HHMMSS")>
<cfset RptFileDIR="q:\somedirpath\">
<cfset TmpRptFile= RptFileDIR & RanPort & ".xls">
Yes, Excel needs to be installed on the server for this to work. A fairly
inexpensive option given what you can do.
You can use the CF_EXCEL tags instead, which create a plain CSV file
that would not require EXCEL. But then you lose all of the formating
capabilities the the CFX tag will allow.
Basically the CFX_EXCEL tag is a wrapper to a com interface to the
M$ Excel objects that do all of the work...
Steve
At 02:06 PM 3/26/2000 +0200, cftalk wrote:
>Stephen, this did the trick.
>Although I had to leave the expression Worksheet="MySheet"
>It didn't really work. But this is optional anyway.
>
>Do you have any coding available showing how I could change the target file
>name, since the tag doesn't overwrite the target file ?
>The quality of the output is very good though in comparison with other low
>end solution working with cfcontent and application/msexcel
>
>What is disturbing is that MS-Excel has to be installed on the Server.
>
>Uwe
>
>----- Original Message -----
>From: Stephen Garrett <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Saturday, March 25, 2000 11:59 PM
>Subject: Re: Problems with CFX_EXCEL
>
>
>>
>> Ok, try this on:
>>
>> ><CFX_Excel Query="Test"
>>
>> Take the results of the Query "TEST"
>>
>> > File="C:\XLS\OUTPUT.XLS"
>>
>> Write the results to a new spreadsheet called "C:\XLS\OUTPUT.XLS"
>> > Workbook="C:\TEMPLATES\TEST.XLS"
>>
>> using a spreadsheet of the name "C:\TEMPLATES\TEST.XLS" as an input
>> template
>>
>> > Worksheet="MySheet"
>>
>> Using the worksheet "MySheet" in the Workbook (AKA Spreadsheet)
>> "C:\TEMPLATES\TEST.XLS"
>>
>>
>> > Row="5"
>>
>> Starting at Row 5 in the worksheet "MySheet"
>>
>> > Col="2">
>>
>> and Column 2 in the worksheet "MySheet"
>>
>> In other words:
>>
>> Input template workbook/spreadsheet + CF Query => New output Workbook/
>> spreadsheet.
>>
>>
>> Steve
>>
>> At 07:45 PM 3/25/2000 +0100, cftalk wrote:
>> >Steve, thank you for your guidance.
>> >To be honest I don't understand the detail-concept of this tag.
>> >Thomas Frey (Tag-Writer) wrote in his manual the following:
>> >
>> >Send the results of a query named "Test" to an existing Excel template
>named
>> >TEST.XLS in the C:\TEMPLATES directory on the Web server. Start the query
>> >results at Row 5, Column 2 on "MySheet":
>> ><CFX_Excel Query="Test"
>> > File="C:\XLS\OUTPUT.XLS"
>> > Workbook="C:\TEMPLATES\TEST.XLS"
>> > Worksheet="MySheet"
>> > Row="5"
>> > Col="2">
>> ><cfcontent type="application/msexcel"
>> > deletefile="YES"
>> > file="C:\XLS\OUTPUT.XLS">
>> >
>> >There he tells of an EXISTING excel-file. (see above)
>> >What I want to do is to overwrite an EXISTING worksheet in an EXISTING
>> >xls-file.
>> >The manual-example (above) didn't bring me any further. In my
>understanding
>> >the FILE and Workbook can just have the same absolute path and file e.g.:
>> >c:\test\test.xls
>> >But this is not working as well.
>> >
>> >Uwe
>> >----- Original Message -----
>> >From: Stephen Garrett <[EMAIL PROTECTED]>
>> >To: <[EMAIL PROTECTED]>
>> >Sent: Saturday, March 25, 2000 6:57 PM
>> >Subject: RE: Problems with CFX_EXCEL
>> >
>> >
>> >>
>> >> Yes, this is the error I would expect you to get. And the Error is
>> >> telling you what the problem is. The CFX_EXCEL tag does not overwrite
>> >> existing files. You need to pass it a file name that is guaranteed to
>> >> not exist.
>> >>
>> >> So either use CFFILE to delete the previous one if it exists, or
>> >> use a random file name to pass to CFX_EXCEL.
>> >>
>> >> Steve
>> >>
>> >>
>> >> At 02:12 PM 3/25/2000 -0000, Paul's Mail wrote:
>> >> >Hi,
>> >> > here is the link:-
>> >> >http://www.wheretoflyfish.com
>> >> >Any problems, let me know.
>> >> >Kind regards
>> >> >Paul Burgess
>> >> >
>> >> >> -----Original Message-----
>> >> >> From: cftalk [mailto:[EMAIL PROTECTED]]
>> >> >> Sent: Saturday, March 25, 2000 1:13 PM
>> >> >> To: [EMAIL PROTECTED]
>> >> >> Subject: Problems with CFX_EXCEL
>> >> >>
>> >> >>
>> >> >> I am using CFX-Excel.
>> >> >> For some reason CF is telling me, that the file
>> >> >> TOPInfo_Excel.XLS
>> >> >>
>> >> >> already exists.
>> >> >>
>> >> >>
>> >> >> Error Diagnostic Information
>> >> >>
>> >> >> Error in CFX_Excel Tag
>> >> >>
>> >> >> C:\cfusion\database\TOPInfo_Excel.XLS already exists.
>> >> >>
>> >> >> The error occurred while processing an element with a general
>> >> >> identifier of
>> >> >> (CFX_EXCEL), occupying document position (13:1) to
>> >> >> (18:19).
>> >> >>
>> >> >>
>> >> >> I am using the same name in file, workbook and worksheet.
>> >> >> Is this a problem ?
>> >> >>
>> >> >> <CFX_Excel Query="CollectDataTopInfo"
>> >> >> File="C:\cfusion\database\TOPInfo_Excel.XLS"
>> >> >> Workbook="C:\cfusion\database\TOPInfo_Excel.XLS"
>> >> >> Worksheet="TOPInfo_Excel"
>> >> >> Row="2"
>> >> >> Col="1">
>> >> >>
>> >> >> Best Uwe
>> >> >>
>> >> >>
>> >> >> SD Solutions
>> >> >> Uwe Degenhardt
>> >> >> Fon: 08122/903791
>> >> >> Fax: 08122/903792
>> >> >> Net: www.sdsolutions.de
>> >> >> Mail: [EMAIL PROTECTED]
>> >> >>
>> >> >>
>> >> >> ------------------------------------------------------------------
>> >> >> ------------
>> >> >> Archives: http://www.eGroups.com/list/cf-talk
>> >> >> To Unsubscribe visit
>> >> >> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
>> >> >_talk or send a message to [EMAIL PROTECTED] with
>> >> >'unsubscribe' in the body.
>> >> >
>> >>
>>
>>>--------------------------------------------------------------------------
>-
>> >> ---
>> >> >Archives: http://www.eGroups.com/list/cf-talk
>> >> >To Unsubscribe visit
>> >> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
>or
>> >> send a message to [EMAIL PROTECTED] with 'unsubscribe'
>in
>> >> the body.
>> >> >
>> >>
>> >> --
>> >> Stephen Garrett
>> >> GPS
>> >> [EMAIL PROTECTED] (360) 896-2714
>> >> ICQ# 10776767
>>
>>> -------------------------------------------------------------------------
>-
>> >----
>> >> Archives: http://www.eGroups.com/list/cf-talk
>> >> To Unsubscribe visit
>> >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
>or
>> >send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>> >the body.
>> >
>> >
>>
>>---------------------------------------------------------------------------
>> ---
>> >Archives: http://www.eGroups.com/list/cf-talk
>> >To Unsubscribe visit
>> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>> the body.
>> >
>>
>> --
>> Stephen Garrett
>> GPS
>> [EMAIL PROTECTED] (360) 896-2714
>> ICQ# 10776767
>> --------------------------------------------------------------------------
>----
>> Archives: http://www.eGroups.com/list/cf-talk
>> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>
>---------------------------------------------------------------------------
---
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
--
Stephen Garrett
GPS
[EMAIL PROTECTED] (360) 896-2714
ICQ# 10776767
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
