Send a text to an exel sheet

[Afsaneh]

when importing data to an exel file using transfer spreadsheet, can I use
useOA argument to send a text as a title for the table? in this case how can
I initial the cell with this value?
and one more question :
since I wanna transfer a crosstab query (rows and cols are variable ) how
can I format the exel sheet?
tnx in advance

 

[pietlinden]

when importing data to an exel file using transfer spreadsheet, can I use
useOA argument to send a text as a title for the table?

Yes.

in this case how can

I initial the cell with this value?

do what?

and one more question :
since I wanna transfer a crosstab query (rows and cols are variable ) how
can I format the exel sheet?
tnx in advance

most of the answers to questions like these are on Ken Snell's
website.

 

[pietlinden]

when importing data to an exel file using transfer spreadsheet, can I use
useOA argument to send a text as a title for the table? in this case how can
I initial the cell with this value?
and one more question :
since I wanna transfer a crosstab query (rows and cols are variable ) how
can I format the exel sheet?

Either use automation after the fact (if you don't know how many
columns will be returned) or export to a template.