Free Support Forum -

How to make columns in Excel resizable?

I do not want to set specific column widths or row heights for the Excel spreadsheet created in my application. But the columns and rows on the datasheet are not resizable. What do I need to do to make them resizable so that the user can resize them like they can in regular Microsoft Excel?

Please try Worksheet.AutoFitColumn method.

I had already tried AutoFitColumn. It does adjust the width automatically, but it does not let me manually resize the column by dragging the column divider like in Microsoft Excel.

Aspose.Cells is a non-UI component. To set the column width, you can use Cells.SetColumnWidth method.