C#中如何设置Excel各列的宽度

Question

Excel.ApplicationClass excel=new Excel.ApplicationClass();;
int rowIndex=4;
int colIndex=1;Excel._Workbook xBk;
Excel._Worksheet xSt;xBk=excel.Workbooks.Add(true);
xSt=(Excel._Worksheet)xBk.ActiveSheet;
...
xSt.get_Range(excel.Cells[4,2],excel.Cells[rowSum,colIndex]).Select();
xSt.get_Range(excel.Cells[4,2],excel.Cells[rowSum,colIndex]).Columns.AutoFit();

Answer 1

Excel.Application excel = new Excel.ApplicationClass();
Excel._Workbook wb;
Excel._Worksheet ws;wb = excel.Workbooks.Add(true);
ws = (Excel._Worksheet)excel.ActiveSheet;excel.Cells[1,1] = "name";
excel.Cells[1,2] = "age"
excel.Cells[1,3] = "sex"ws.get_Range(excel.Cells[1,1],excel.Cells[1,1]).ColumnWidth=宽度;