Save 'with format' when using Cognos script editor

[dalex17]

Hello,

Does anyone know of a way to save an .xls file with format using the Cognos script editor?

I'm trying to automate a process where I click on a macro button developed through Cognos script editor to save an Impromptu report as either excel or text WITH FORMAT.


Thank you,

dalex

 

[drlex]

dalex,
Unless you prepared to manage a kludge using Sendkeys on earlier versions, 7.1 has an ExportExcelWithFormat command. (Note that the Excel version saved is in 5.0, not 2000)
lex

 

[dalex17]

thanks drlex for your help!

p.s. Kludge? Never heard of that word. I'm guessing it must mean something similiar to concoction...

 

[drlex]

you're welcome.
I think the etymology of kludge (if one can be said to exist) would be klu(nky) crossed with (fu)dge, being an inelegant, unsatisfactory and unreliable solution.
If you need to see sendkeys in a script, do a search on the forum for excel & format.
lex

 

[dalex17]

DRLX,

Is the export with format command as you write it above (i.e. exportwithformat), or does it look different in syntax?

Thanks,

Dalex

 

[drlex]

dalex,
it's as written. Example:
objImpRep.ExportExcelWithFormat strfilename
(assuming object objImpRep and string strfilename defined)
lex