Set the column width for excel

Roger

I'm trying to write an export to excel with the excel buffer table. But I don't know how I can set the width for a specific column in excel.

Could anyone helps me? Many thanks.

garak

You can use the function AutoFit() <- this is used in the EXCELBuffer table or for a defined column the property ColumnWidth (to find under ExcelRange or ExcelWorkSheet.Range)

Roger

Thanks for the answer. But autofit works for all columns in the sheet. I want to set the width only for one specific column. Is this possible?

garak

for a defined column the property ColumnWidth (to find under ExcelRange or ExcelWorkSheet.Range)

Roger

That works well, many thanks!

garak

No problem, and welcome