Aspose.Cells

Aspose.Cells中设置列自动撑开，可以使用以下代码：

复制// 加载Excel文件
Workbook workbook = new Workbook("input.xlsx");

// 获取第一个工作表
Worksheet worksheet = workbook.Worksheets[0];

// 设置列自动撑开
worksheet.AutoFitColumns();

// 保存Excel文件
workbook.Save("output.xlsx");

Aspose.Cells设置列背景色：

//设置列样式
Aspose.Cells.Style rowBg = workbook.Styles[workbook.Styles.Add()];
rowBg.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin;
rowBg.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;
rowBg.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin;
rowBg.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin;
rowBg.Pattern = BackgroundType.Solid;
rowBg.ForegroundColor = System.Drawing.Color.FromArgb(226, 239, 218);

//获取需要设置样式的列

 Aspose.Cells.Range range = cells.CreateRange(0, i, Rownum + 1, 1);

  // 设置背景颜色为红色
range.ApplyStyle(rowBg, new StyleFlag() { All = true });