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.
