Has anyone found a good way to deal with setting row heights (in place of Autofit) when there are merged cells in the focus row as Excel does not allow AutoFit to set row heights with merged cells. Brief testing tells me it is the same when creating xls
files with NPOI.
Using Excel automation I have previously used the following approach..
If objCurrentCell.MergeCells Then
If .Rows.Count = 1 And .WrapText = True Then
objExcelApp.ScreenUpdating = False
CurrentRowHeight = .RowHeight
ActiveCellWidth = objCurrentCell.ColumnWidth
For Each CurrCell In .Cells
MergedCellRgWidth = CurrCell.ColumnWidth + MergedCellRgWidth
.MergeCells = False
.Cells(1).ColumnWidth = MergedCellRgWidth
PossNewRowHeight = .RowHeight
.Cells(1).ColumnWidth = ActiveCellWidth
.MergeCells = True
.RowHeight = PossNewRowHeight