how to increase width of specfic colunn

[MANI SHANKAR]

i want to increase width of one specfic column.

 

 

For any help thanks in advance..

[Pannir Selvam S]

Hi Mani Shankar,

 

Thanks for contacting Syncfusion support.

 

You can set the width of a specific column by using the SetColumnWidthInPixels() method like below code snippet.

Code Snippet[C#]:

var grid = this.spreadSheetControl.GridProperties.ActiveSpreadsheetGrid;

IWorksheet sheet = this.spreadSheetControl.ExcelProperties.WorkBook.ActiveSheet;

sheet.SetColumnWidthInPixels(2, 100);

grid.InvalidateCell(GridRangeInfo.Col(2));

grid.InvalidateVisual(true);

 

 

Please let us know if you have any other queries.

 

Thanks,

Pannir