//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; IRange rangeB1 = worksheet.Range["B1"]; rangeB1.Value = "The ShrinkToFit property is applied"; rangeB1.ShrinkToFit = true; // Save to an excel file workbook.Save("ShrinkToFit.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) Dim rangeB1 As IRange = worksheet.Range!B1 rangeB1.Value = "The ShrinkToFit property is applied" rangeB1.ShrinkToFit = True ' save to an excel file workbook.Save("ShrinkToFit.xlsx")