We are using Aspose.Cells in our application. we have a requirement is to autofit columns based on the contents of specifc cells. Please let us know if this is possible.
We tried to the AutoFitColumns property for a range but the issue is its not autofitting based on the specifed range only its considering the contents in the whole column.
FullDataRange.Worksheet.AutoFitColumns(FullDataRange.FirstRow, FullDataRange.FirstColumn, FullDataRange.FirstRow + FullDataRange.RowCount, FullDataRange.FirstColumn + FullDataRange.ColumnCount)
We have a long description in the header which we dont need to consider while autofit (Basically we need to exclude few cell contents in the column which is not in a specifed range). Is this possible?