Excel Cell Alignments: Numerical values for e.g. xlLeft, xlRight or xlCenter?

For VerticalAlignment:

Top:    -4160Center: -4108Bottom: -4107

And HorizontalAlignment:

Left:    -4131Center:  -4108Right:   -4152

asp.net vb.net excel alignment

You can use xlLeft:

Imports Microsoft.Office.Interop.Excel...oSheet.Range("A1").HorizontalAlignment = Constants.xlLeft

asp.net vb.net excel alignment

xcl.Range("J:J").EntireColumn.HorizontalAlignment = _Microsoft.Office.Interop.Excel.Constants.xlCenter

CodeHunter