I want to be able to autofit rows and if incase the row height is less than 30 want to set it to 30.
What I have done is autofit all the rows and columns and after constructing the worksheet. I parse all columns and set max width of 50. After which, I parse all rows and set its wrap to true and apply the style.
Now when I get the height of row, it does not show the actual height of the row but rather before applying any style.
When the Excel is saved I can see the styles being applied successfully…
Trying to get height of a row after applying styles does not return the new height.
Even after I save and try to get the height it is same and does not get updated height.