Aspose excel autofitcolumn but for a certain width

Question

I want to fit column according to header width not the properties width.Ie Header size should be the column width )

i am using sheet.AutoFitColumns(); which fits according to the max length of cell.

ie

I want to have sheet like this.(Header size should be the column width ie 3b 3c)

Thank you in advance.

pfx · Accepted Answer · 2022-12-17 15:36:53Z

2

That AutFitColumns method has an overload that allows to specify the range upon which to apply the autofit.

public void AutoFitColumns(int firstRow, int firstColumn, int lastRow, int lastColumn)

For your scenario that might be below one (indexes are 0-based) - you might need to adjust.

sheet.AutoFitColumns(2, 1, 2, 2);

answered Dec 17, 2022 at 15:36

pfx

23.9k52 gold badges105 silver badges125 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1