//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; worksheet.Range["A1:C1"].Merge(); worksheet.Range["A1:C1"].Value = "Enhancement of MS Excel auto fit, Auto fit a row contains merged cell"; worksheet.Range["A1:C1"].WrapText = true; worksheet.Range["A1:C1"].Rows.AutoFit(true); // Save to an excel file workbook.Save("AutoFitContainMergedCell.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) worksheet.Range("A1:C1").Merge() worksheet.Range("A1:C1").Value = "Enhancement of MS Excel auto fit, Auto fit a row contains merged cell" worksheet.Range("A1:C1").WrapText = True worksheet.Range("A1:C1").Rows.AutoFit(True) ' save to an excel file workbook.Save("AutoFitContainMergedCell.xlsx")
