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.
