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.
