Sorry, I sent above though not finished writing.
So I send it again.
-----------------------------------------------------
I'm using Syncfusion Essential Studio 6.4.0.15.
In the attached sample, text of multiple lines is set to IRange.Text Property.
------
var sb = new System.Text.StringBuilder();
sb.Append( string.Format( "row{0}", i ) );
sb.AppendLine();
sb.Append( string.Format( "col{0}", j ) );
var text = sb.ToString();
sheet.Range[i, j].Text = text;
------
And after that, autofit all rows and export to Excel file.
------
for ( int i = 0 ; i < RowCount ; i++ ) {
sheet.AutofitRow( i + 1 );
}
for ( int j = 0 ; j < ColCount ; j++ ) {
sheet.AutofitColumn( j + 1 );
}
------
But in the result of Excel file, whole cell is not autofitted by row.
I'd like to export remaining line count of whole cell, and whole cells autofitted by row height.
How can I achieve that?
ExportExcelSample_2fa16470.zip