Column Settings

[parker-dean]

How am I able to set the width of columns and width of the table?

Tried searching source code and using the following:
sheet.Column(0,0).Width = "200px";

sheet.Width = "100%";

sheet.Range("A1:A1").Format = new CellFormat() { Width = "200px" };

[anmcgrath]

Hi @parker-dean you can use

_sheet.Columns.SetSize(indexStart, indexEnd, sizeInPx);

or

_sheet.Columns.SetSize(index, sizeInPx);

[parker-dean]

Thank you for getting back to me so quickly. Faster than companies that get paid for support. :)