//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; worksheet.Range["E1"].Value = 1; //Hidden row 2:6. worksheet.Range["2:6"].Hidden = true; //Hidden column A:D. worksheet.Range["A:D"].Hidden = true; // Save to an excel file workbook.Save("HiddenRowColumn.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) worksheet.Range!E1.Value = 1 'Hidden row 2:6. worksheet.Range("2:6").Hidden = True 'Hidden column A:D. worksheet.Range("A:D").Hidden = True ' save to an excel file workbook.Save("HiddenRowColumn.xlsx")