I need to dynamically expand the width of Excel headers, like columns A and C. How can I achieve this?

Aspose.Cells Product Family
1

I need to dynamically expand the width of Excel headers, like columns A and C. How can I achieve this? please find the attachment.

image.png1281×41 3.07 KB
image.png (3.1 KB)

2

@parthiveera,

Thanks for the screenshot.

See the document with examples on how to set/extend column widths in the worksheet for your reference.
https://docs.aspose.com/cells/net/adjusting-row-height-and-column-width/#working-with-columns

3

I need to handle this in JavaScript. Could you please share the relevant link?

4

@parthiveera
Please try the below code in GridJs client

//assume xs is the instance of GridJs client instance
//column index is zero based
//get column width at column index 1,
xs.sheet.data.cols.getWidth(1)
//set width
xs.sheet.data.cols.setWidth(1,120)
//row index is zero based
//get row height at row index 1,
xs.sheet.data.rows.getHeight(1)
//set height
xs.sheet.data.rows.setHeight(1,50)
//trigger ui render
xs.reRender()