|
| The AccuTerm forum has moved. Go to community.rocketsoftware.com to register for the new Rocket forum. |
|
Post Reply 
|
| Author | |
w_godsoe 
Newbie 
Joined: April 14 2005 Location: United States Status: Offline Points: 26 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Sending data to a specific Excel tabPosted: September 17 2008 at 5:00am |
|
Help! I am trying to send data to a specific tab in a workbook. My code looks like
** TABNAME="Summary" TITLE ="STOCK.xls" CALL DOSSVC(","C:\TEMP",TITLE:"!":TABNAME,RPT,"","","") ** What occurs is that the workheet is created in another book, with the extention of ".xls!Summary". Any ideas? Thanks |
|
 |
|
|
PSchellenbach
Admin Group 
Moderator Joined: December 15 2003 Location: United States Status: Offline Points: 2150 |
Post Options
Thanks(0)
Quote Reply
Posted: September 18 2008 at 12:28pm |
|
Hi Walter -
DOSSVC does not support Excel files directly. FTD and FTEXPORT will allow you to specify the desired worksheet tab. Thanks, Pete |
|
|
|
|
w_godsoe
Newbie
Joined: April 14 2005 Location: United States Status: Offline Points: 26 |
Post Options
Thanks(0)
Quote Reply
Posted: September 19 2008 at 12:02am |
|
Hi Pete,
I have tried FTEXPORT and FTD and the result remain the same, a new workbook is created. Coluld this be an EXCEL 2003 issue? The session with FTD looks like. (S)end, (R)eceive, (C)onfigure, (O)ptions, (H)elp or (E)xit ? s File transfer protocol: (A)SCII or (K)ERMIT ? k Enter source (PICK) file name: DM.WORK Enter source (PICK) item list: 23893.578 Enter target (DOS) file name (d:\directory\file.ext): C:\DOWNLOAD\test.xls Attributes to transfer: * Generate Header Record (<Y>/N): n Transfer status: Successful transfer. Transferred 1 items, 30520 bytes. 2nd Transfer Method for 2nd sheet (S)end, (R)eceive, (C)onfigure, (O)ptions, (H)elp or (E)xit ? S File transfer protocol: (A)SCII or (K)ERMIT ? K Enter source (PICK) file name: DM.WORK Enter source (PICK) item list: 23893.578 Enter target (DOS) file name (d:\directory\file.ext): C:\DOWNLOAD\TEST.xls!sheet2 Attributes to transfer: * Generate Header Record (<Y>/N): N Transfer status: Successful transfer. Transferred 1 items, 30520 bytes. Results in 2 workbooks TEST.xls and TEST.XLS!sheet2 Thanks Walt |
|
|
|
|
PSchellenbach
Admin Group
Moderator Joined: December 15 2003 Location: United States Status: Offline Points: 2150 |
Post Options
Thanks(0)
Quote Reply
Posted: September 22 2008 at 3:28am |
|
Hi Walt -
I'm not sure what you are doing different than me. I tested the same two FTD commands with Excel 2003 and I end up with a single workbook, TEST.XLS, with two worksheets, sheet1 and sheet2. What release of AccuTerm are you running? What version of the host programs (ED FTBP FTVERSN)? Thanks, Pete |
|
|
|
|
w_godsoe
Newbie
Joined: April 14 2005 Location: United States Status: Offline Points: 26 |
Post Options
Thanks(0)
Quote Reply
Posted: September 23 2008 at 2:24am |
|
Hi Pete,
Here are the releases. 2k2 Release 5.3c (5.3.304) FTBP FTVERSN * VERSION: 5.4.3 VERSN = '5.004.003' Thanks Walt |
|
|
|
|
PSchellenbach
Admin Group
Moderator Joined: December 15 2003 Location: United States Status: Offline Points: 2150 |
Post Options
Thanks(0)
Quote Reply
Posted: October 08 2008 at 10:48am |
|
Hi Walt -
I have studied the code that creates and updates Excel files and I cannot find any way that an Excel file can be created with the sheet name apended to the file extension, nor can I reproduce the problem. If you could work up a small sample BASIC program or PROC that reproduces the problem, I'll see if I can reproduce it. You could email it to support at asent.com. If possible, create your sample in the ACCUTERM account using the sample data files. Thanks, Pete |
|
|
|
|
volkmaniac
Newbie
Joined: June 12 2008 Location: United States Status: Offline Points: 21 |
Post Options
Thanks(0)
Quote Reply
Posted: October 15 2008 at 5:18am |
|
Have you tried this with FTD? It's not going to assign a title (you can use a variety of methods to format the worksheet after it downloads) but it will direct the output to the sheet you assign. Directory Path\File Name\Sheet Name\Target Cells
Enter target (DOS) file name (d:\directory\file.ext):
c:\STOCK.xls!Summary!A3:G99 THIS WILL CREATE OR OVERWRITE WHATEVER SHEET YOU ASSIGN AND BEGIN WRITING ON LINE #3
|
|
|
Jim Volkman
jamesvolkman@yahoo.com |
|
|
|
|
TonyG
Beta Tester 
Joined: February 04 2004 Location: United States Status: Offline Points: 127 |
Post Options
Thanks(0)
Quote Reply
Posted: October 15 2008 at 8:31am |
|
It looks like you're trying to use formula notation, which may not work entirely. For example, this is a valid formula reference to another workbook, sheet, and cell:
'C:\Full Path\To Spreadsheets\[Budget08.xls]Month01'!R2C1 I hope you can accomplish what you want with AccuTerm but if you cannot, have a look at NebulaXLite which has been slowly gaining popularity: http://Nebula-RnD.com/products/xlite.htm Forum here: http://Nebula-RnD.com/forum This is not a replacement for AccuTerm! The difference is that rather than using Excel on the client system with AccuTerm, you can generate an Excel document on the server with NebulaXLite and then upload the finished version to a client PC with AccuTerm. This also allows you to deploy an Excel document to people who don't even have Excel, just a reader - or even a web browser. NebulaXLite is completely free for all developers and only $200 for production use on an end-user server. It can't hurt to check it out. HTH |
|
|
Tony Gravagno Nebula Research & Development
TG@ Nebula-RnD . com http://Nebula-RnD.com/blog http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms https://www.linkedin.com/groups/64935 |
|
|
|
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
Sending data to a specific Excel tab
Topic Options