Sheet := eclapp.ActiveSheet as _WorkSheet;
C := Sheet.Cells.Item[3,7];
Range := Sheet.Range[C,C];
Range.ColumnWidth := Length(Range.Text)*2;//列宽计量单位是缺省字体的个数
Range.HorizontalAlignment := xlHAlignCenter;//水平居中
Range.VerticalAlignment := xlVAlignCenter;//垂直居中
//以下在excel97 or excel2000中有定义
type
XlVAlign = TOleEnum;
const
xlVAlignBottom = $FFFFEFF5;
xlVAlignCenter = $FFFFEFF4;
xlVAlignDistributed = $FFFFEFEB;
xlVAlignJustify = $FFFFEFDE;
xlVAlignTop = $FFFFEFC0;
type
XlHAlign = TOleEnum;
const
xlHAlignCenter = $FFFFEFF4;
xlHAlignCenterAcrossSelection = $00000007;
xlHAlignDistributed = $FFFFEFEB;
xlHAlignFill = $00000005;
xlHAlignGeneral = $00000001;
xlHAlignJustify = $FFFFEFDE;
xlHAlignLeft = $FFFFEFDD;
xlHAlignRight = $FFFFEFC8;