How to center text in an MSExcel cell & set font size

[elmtx]

Hey y'all

I've been digging all over the place but to no avail. I'm running powerbuilder 6.5, I have a report that the user wants the results dumped to an MSExcel spreadsheet. No problem, however, I cannot find any documentation that explains how to center text in a cell, or how to set the font size. The report creates several spreadsheets based on region, and each spreadsheet has multiple tabs one per location.

If anyone has an insite into this, I would greatly appreciate the help.

Also, if anyone can point me to where I can find this information on my own, that would be awesome as well. I didn't have much luck via powerbuilder help, sybase.com or google.

Thanks in advance!!!
Eddie

 

[subynuby]

See if this MSDN Library helps if you haven't looked here already...

http://msdn.microsoft.com/library/d...odcore/html/deovrunderstandingrangeobject.asp