//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; worksheet.Range["H6:M7"].Value = 1; worksheet.Range["J9:J10"].Merge(); //set interior color for worksheet usedRange "H6:M10". var usedrange = worksheet.UsedRange; usedrange.Interior.Color = Color.LightBlue; // Save to an excel file workbook.Save("GetWorksheetUsedRange.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) worksheet.Range("H6:M7").Value = 1 worksheet.Range("J9:J10").Merge() 'set interior color for worksheet usedRange "H6:M10". Dim usedrange = worksheet.UsedRange usedrange.Interior.Color = Color.LightBlue ' save to an excel file workbook.Save("GetWorksheetUsedRange.xlsx")