Set the column width for excel

Roger
Roger Member Posts: 57
edited 2008-12-12 in NAV/Navision Classic Client
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.
Many thanks, Roger

Comments

  • garak
    garak Member Posts: 3,263
    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)
    Do you make it right, it works too!
  • Roger
    Roger Member Posts: 57
    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?
    Many thanks, Roger
  • garak
    garak Member Posts: 3,263
    for a defined column the property ColumnWidth (to find under ExcelRange or ExcelWorkSheet.Range)
    Do you make it right, it works too!
  • Roger
    Roger Member Posts: 57
    That works well, many thanks!
    Many thanks, Roger
  • garak
    garak Member Posts: 3,263
    No problem, and welcome
    Do you make it right, it works too!

Categories