AutoFitColumns会让隐藏列展示出来

中文技术支持
1

SyntaxEditor Code Snippet
代码：
string filePath = @“C:\Users\25477\Downloads\工作簿1.xlsx”;
using Workbook workbook = new Workbook(filePath);
workbook.Worksheets[0].Cells.HideColumn(1);
workbook.Worksheets[0].Cells.Columns[2].IsHidden=true;
workbook.Worksheets[0].AutoFitColumns();
workbook.Save(@“C:\Users\25477\Downloads\工作簿2.xlsx”);

4

@cloudy
这是符合预期的行为。如果你在excel里手动操作，隐藏的列也会显示出来。如果你想在调整行列时过滤掉隐藏的行列，你可以在调用AutoFitColumns方法时，设置AutoFitterOptions.IgnoreHidden为true来忽略隐藏的行列。请参考以下样例代码。

Workbook workbook = new Workbook();
Cells cells = workbook.Worksheets[0].Cells;
cells["A1"].Value = 1;
cells["B1"].Value = 2;
cells["C1"].Value = 3;
cells["D1"].Value = 4;
cells["E1"].Value = 5;
workbook.Worksheets[0].Cells.HideColumn(1);
workbook.Worksheets[0].Cells.Columns[2].IsHidden = true;

AutoFitterOptions options = new AutoFitterOptions();
options.IgnoreHidden = true;  

workbook.Worksheets[0].AutoFitColumns(options);
workbook.Save(filePath + "out_net.xlsx");