//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; //set row height for row 1:2. worksheet.Range["1:2"].RowHeight = 50; //set column width for column C:D. worksheet.Range["C:D"].ColumnWidth = 20; // Save to an excel file workbook.Save("SetRowHeightColumnWidth.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) 'set row height for row 1:2. worksheet.Range("1:2").RowHeight = 50 'set column width for column C:D. worksheet.Range("C:D").ColumnWidth = 20 ' save to an excel file workbook.Save("SetRowHeightColumnWidth.xlsx")