Trying to export to xlsx I am creating a GridView and GridControl in code. After binding a DataTable to the GridControl I call the BestFitColumns method. To my surprise most columns in the exported Excel file have a width which is smaller than their longest content. I want the column width to adjust to the longest content. How can I achieve this desired result?
Below is all the code I use for manipulating the result:
Visual BasicgridControl.BindingContext = New BindingContext()
gridControl.MainView = gridView
gridView.GridControl = gridControl
gridControl.DataSource = dataTable
gridControl.ForceInitialize()
gridView.PopulateColumns()
gridView.OptionsPrint.PrintHeader = True
gridView.OptionsPrint.PrintFooter = False
'Disable grid lines
gridView.OptionsPrint.PrintVertLines = False
gridView.OptionsPrint.PrintHorzLines = False
'Best fit columns
gridView.OptionsPrint.AutoWidth = False
gridView.OptionsView.ColumnAutoWidth = False
gridView.BestFitColumns()