Hi,
Finally i could get the correct row output using ws.AutoFitRows(True)
Eariler i was using ws.AutoFitRows() i.e. without true which was giving me wrong output.
On the similar lines i want to use autofit columns with below code but its making all column auto instead of just intended columns. In the attached template i have kept all column as fix width but in output.xlsx all columns are getting auto width.
can you please let me know what code i should add for this in vb?
Dim myopt As New Aspose.Cells.AutoFitterOptions
myopt.IgnoreHidden = True
myopt.OnlyAuto = True
ws.AutoFitColumns(myopt)