Introduction

All Excel worksheets have Gridlines by default, which helps us in entering data to particular cells of a worksheet. Gridlines enable us to view a worksheet as a collection of cells, where each cell is easily identifiable. Using, Aspose.Cells , developers can also control the visibility of the gridlines in their worksheets.

Controlling the Visibility of the Gridlines

Aspose.Cells provides a class, Workbook that represents an Excel file. Workbook class contains a Worksheets collection that allows to access each worksheet in the Excel file.

A worksheet is represented by the Worksheet class. Worksheet class provides a wide range of properties and methods to manage a worksheet. But, to control the visibility of the gridlines, developers may use IsGridlinesVisible property of the Worksheet class. IsGridlinesVisible is a boolean property, which means that it can only store a true or false value.

Hiding Gridlines

Developers can hide gridlines by setting the IsGridlinesVisible property of the Worksheet class to false.

Example:

[C#]

 

 

//Hiding the gridlines of the worksheet

worksheet.IsGridlinesVisible = false;

 

 

[VB.NET]

 

 

'Hiding the gridlines of the worksheet

worksheet.IsGridlinesVisible = False

 

 

[JAVA]

 

 

//Hiding the gridlines of the worksheet

worksheet.setGridlinesVisible(false);

 

Making Gridlines Visible

Developers can make gridlines visible by setting the IsGridlinesVisible property of the Worksheet class to true.

Example:

[C#]

 

 

//Displaying the gridlines of the worksheet

worksheet.IsGridlinesVisible = true;

 

 

[VB.NET]

 

 

'Displaying the gridlines of the worksheet

worksheet.IsGridlinesVisible = True

 

 

[JAVA]

 

 

//Displaying the gridlines of the worksheet

worksheet.setGridlinesVisible(true);

 

Example:

A complete example is given below that demonstrates the use of IsGridlinesVisible property of Worksheet class to hide the gridlines of the first worksheet of the Excel file.

[C#]

 

             

//Instantiating a Workbook object

Workbook workbook = new Workbook();

 

 

//Creating a file stream containing the Excel file to be opened

FileStream fstream = new FileStream("C:\\book1.xls",FileMode.Open);

 

 

//Opening the Excel file through the file stream

workbook.Open(fstream);

 

 

//Accessing the first worksheet in the Excel file

Worksheet worksheet = workbook.Worksheets[0];

 

 

//Hiding the gridlines of the first worksheet of the Excel file

worksheet.IsGridlinesVisible=false;

 

 

//Saving the modified Excel file in default (that is Excel 2000) format

workbook.Save("C:\\output.xls",FileFormatType.Default);

 

 

//Closing the file stream to free all resources

fstream.Close();

 

 

[VB.NET]

 

 

'Instantiating a Workbook object

Dim workbook As Workbook = New Workbook()

 

 

'Creating a file stream containing the Excel file to be opened

Dim fstream As FileStream = New FileStream("C:\\book1.xls",FileMode.Open)

 

 

'Opening the Excel file through the file stream

workbook.Open(fstream)

 

 

'Accessing the first worksheet in the Excel file

Dim worksheet As Worksheet = workbook.Worksheets(0)

 

 

'Hiding the gridlines of the first worksheet of the Excel file

worksheet.IsGridlinesVisible = False

 

 

'Saving the modified Excel file in default (that is Excel 2000) format

workbook.Save("C:\\output.xls",FileFormatType.Default)

 

 

'Closing the file stream to free all resources

fstream.Close()

 

 

[JAVA]

 

 

//Instantiating a Workbook object

Workbook workbook = new Workbook();

 

 

//Opening the Excel file

workbook.open("C:\\book1.xls");

 

 

//Accessing the first worksheet in the Excel file

Worksheets worksheets = workbook.getWorksheets();

Worksheet worksheet = worksheets.getSheet(0);

 

 

//Hiding the gridlines of the first worksheet of the Excel file     

worksheet.setGridlinesVisible(false);

 

 

//Saving the modified Excel file in default (that is Excel 2000) format

workbook.save("C:\\output.xls");

 

Worksheet - Before Modification

In the screenshot below, you can see that Book1.xls file contains three worksheets: Sheet1, Sheet2 and Sheet3. All of these worksheets have gridlines as shown below:

 

 

Figure: Worksheet view before any modification

 

Worksheet - After Executing the Example Code

Book1.xls file is opened by calling the Open method of Workbook class and then the gridlines of the first worksheet of the Book1.xls file are made hidden. The modified file is saved as output.xls file whose pictorial view is shown below:

 

 

Figure: Worksheet view after modification