Stephen, I agree with you.
You loose the formatting capabilities using cf_excel.
CFX_Excel is much better !
I am going to install Excel on the Server.
Thank you very much for your code and your help.
Best Uwe
----- Original Message -----
From: Stephen Garrett <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, March 26, 2000 8:10 PM
Subject: Re: Problems with CFX_EXCEL
>
> 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.
------------------------------------------------------------------------------
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.
