export multi vs export ascii
Dennis Malen
dmalen at malen.com
Sun Oct 4 17:12:01 PDT 2009
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