Merge pull request #372 from syncfusion-content/FLUT-6849-HideSheet-HF

Mohan2401 · web-flow · commit ee5f8b38bd19 · 2022-09-16T18:05:09.000+05:30
FLUT-6849 - UG documentation to hide Excel worksheet - Development
diff --git a/Flutter/xlsio/working-with-excel-worksheet.md b/Flutter/xlsio/working-with-excel-worksheet.md
@@ -116,6 +116,28 @@ File('Output.xlsx').writeAsBytes(bytes);
 
 {% endhighlight %}
 
+## Show or Hide Worksheet
+
+The following code snippet shows how to hide the worksheet using **visibility** property.
+
+{% highlight dart %}
+
+//Create a new Excel Document.
+final Workbook workbook = Workbook(10);
+
+//Accessing sheet via index.
+final Worksheet sheet = workbook.worksheets[2];
+sheet.getRangeByName('A1:M10').setText('Visibility');
+
+//set the visibility for the worksheet.
+sheet.visibility = WorksheetVisibility.hidden;
+
+final List<int> bytes = workbook.saveAsStream();
+File('Output.xlsx').writeAsBytes(bytes);
+workbook.dispose();
+
+{% endhighlight %}
+
 ## Adjust Row Height and Column Width
 
 **Resize a range of rows or columns**
