Hiding the Display of Zero Values in the Worksheet

Sometimes, you need to hide zero values in a spreadsheet. It might be a personal preference or a formatting standard.

To hide zero values in a worksheet in Microsoft Excel (for example Microsoft Excel 2003):

1. From the Tools menu, select Options, and then select the View tab.
2. Deselect the Zero values option.
3. Click OK.

Please see the following sample code that demonstrates hiding zeros using Aspose.Cells.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Create a new Workbook object
Workbook workbook = new Workbook(dataDir + "book1.xlsx");

// Get First worksheet of the workbook
Worksheet sheet = workbook.Worksheets[0];

// Hide the zero values in the sheet
sheet.DisplayZeros = false;

// Save the workbook
workbook.Save(dataDir + "outputfile.out.xlsx");