In Excel, I can select an entire column, right-click, select Format Cells and set the alignment or number format for the entire column. How do I do this in XlsIO?

Hi Jim Slater,

Thank you for using Syncfusion products.

We have an IRange array Columns property for selecting the entire column of the worksheet. We have given below the sample code snippet for your reference for setting the number format and cell style.

Code Snippet [C#]:

worksheet.Columns[0].NumberFormat = "#,###";
worksheet.Columns[0].CellStyle.ColorIndex = ExcelKnownColors.Black;

Please try the above code snipppet at your side and let us know if this helps you.

Please let me know if you require any further clarifications.

Thanks,
Sridhar.S