Visibility of rows and columns can be set by using the [showRows](https://pub.dev/documentation/syncfusion_flutter_xlsio/latest/xlsio/Range/showRows.html) and [showColumns](https://pub.dev/documentation/syncfusion_flutter_xlsio/latest/xlsio/Range/showColumns.html) methods as shown below.

{% highlight dart %}

// Create a new Excel Document.

final Workbook workbook = Workbook(1);

// Accessing sheet via index.

final Worksheet sheet = workbook.worksheets[0];

// Show or hide rows in the given range. TRUE by default.

sheet.getRangeByName('A1').showRows(false);

sheet.getRangeByName('A2:A5').showRows(false);

// Show or hide columns in the given range. TRUE by default.

sheet.getRangeByName('C10').showColumns(false);

sheet.getRangeByName('D10:E10').showColumns(false);

// Save and dispose workbook.

final List<int>? bytes = workbook.saveAsStream();

File('HideRowsAndColumns.xlsx').writeAsBytes(bytes!);

workbook.dispose();

{% endhighlight %}

The following code snippet shows how to set the visibility for a specific range through [showRange](https://pub.dev/documentation/syncfusion_flutter_xlsio/latest/xlsio/Range/showRange.html) method .

{% highlight dart %}

// Create a new Excel Document.

final Workbook workbook = Workbook(1);

// Accessing sheet via index.

final Worksheet sheet = workbook.worksheets[0];

// Show or hide rows and columns in the given range. TRUE by default.

sheet.getRangeByName('G15').showRange(false);

sheet.getRangeByName('J22:J25').showRange(false);

// Save and dispose workbook.

final List<int>? bytes = workbook.saveAsStream();

File('HideRowsAndColumns.xlsx').writeAsBytes(bytes!);

workbook.dispose();

{% endhighlight %}