export multi vs export ascii

Dennis Malen dmalen at malen.com
Wed Oct 7 08:55:06 PDT 2009


Just want to confirm that I didn't miss anyone's reply.

I was looking for a way to use "export multi" and to specifically be able to 
post, at any point in the report process, to a particular row and column 
similar to what we are able to do in "export ascii" with the use of:

exp(5)="C;Y1;X3;K\""&7&"\""&chr("10")

It would make the creation of the processing table so much easier. For the 
major part of the task I could just use exp(5)=7 as opposed to the above. 
For the one time two pieces of information that have to be placed in a 
specific cell and row I could use more extensive processing if there was 
such an animal.

It appears so far that I will have to go back to "export ascii" to solve the 
problem.

Any ideas?

Dennis Malen
516.479.5912
----- Original Message ----- 
From: "Dennis Malen" <dmalen at malen.com>
To: <filepro-list at lists.celestial.com>
Sent: Sunday, October 04, 2009 8:12 PM
Subject: export multi vs export ascii


> Is there any way when using "export multi" such as:
>
>
>
> export multi exp=(pn) r=1 f=1
>
>
>
> to identify which row and column that I would like information placed? 
> "Export multi" works when run a report in sequence. As the report runs it 
> places the information in the appropriate cell.
>
>
>
> For instance I can use plain text "export ascii" command such as:
>
>
>
> export ascii exp=/tmp/asciicost2.xls r=\r r=\n -x -a
>
>
>
> If I use an export command such as:
>
>
>
> exp(5)="C;Y1;X3;K\""&7&"\""&chr("10")
>
>
>
> the information is placed in row 1, column 3.
>
>
>
> Can I do something similar to that using "export multi"?
>
>
>
> Reason: I have no problem when I manipulate where export multi places 
> information. What I do need is a recap of totals that I want at the top of 
> the spreadsheet. When I get to the end of the report with export multi I 
> would like to place the totals I have accumlated somewhere at the 2nd, 3rd 
> or 4th rows and in a particular column. When the report is run I have 
> already passed those rows.
>
>
>
> Can this be done? I can do it with "export ascii" but would like to save 
> programming time and not have to define each cell such as 
> "C;Y1;X3;K\""&7&"\""&chr("10"). Export multi would do that for me. What I 
> need would only reside in two or three cells at the top of the spreadsheet 
> but the information (totals) would only be available at the end of the 
> report.
>
>
>
> Dennis Malen
> 516.479.5912 



More information about the Filepro-list mailing list