try with ExcelUseConstantColumnWidth as false
Dim CrFormatTypeOptions As New ExcelFormatOptions
CrFormatTypeOptions.ExcelUseConstantColumnWidth = False
You may need to change the report as well to avoid alignment issues when exporting to excel.
check this article.[
^]