How to make columns in Excel resizable?

spadhye · February 19, 2006, 11:21am

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?

Laurence · February 19, 2006, 5:08pm

Please try Worksheet.AutoFitColumn method.

spadhye · February 19, 2006, 8:24pm

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.

Laurence · February 19, 2006, 8:45pm

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