Dump Excel File Alingement

[jaiprogress]

Hi,
I have generated one dump program, this program will dump open purchase requisition into excel file.
I am putting nealy 10 field in excel file.
But i am facing allingment problem,
Example for supplier field some value coming left align and some coming right allign in excel sheet.
EXample:-
PR No. Quantity Supplier
-----------------------------
pr1 20 sup1
pr2 30 sup2
pr3 40 sup3
pr4 50 sup4.
You can see in example that supplier values sup1 and sup4 is left allign and sup2,sup3 is right allign.
Please can you suggest me what should i do If i want value some put in excel file as left allign only.
Thank u

 

[mrobles]

Hi.

chWorksheet:Range('A1:C1'):HorizontalAlignment = -4108. /* Center */
chWorksheet:Range('A2:C2'):HorizontalAlignment = -4131. /* Left */
chWorksheet:Range('A3:C3'):HorizontalAlignment = -4152. /* Right */