How to check empty worksheets in .NET Excel Library

16 Aug 20263 minutes to read

The following code examples demonstrate how to check whether a worksheet is empty in Excel using C# (Cross-platform and Windows-specific) and VB.NET.

using (ExcelEngine excelEngine = new ExcelEngine())
{
    IApplication application = excelEngine.Excel;
    application.DefaultVersion = ExcelVersion.Xlsx;
    IWorkbook workbook = application.Workbooks.Open(Path.GetFullPath(@"Data/Input.xlsx"));
    IWorksheet worksheet;
    for (int i = 0; i < workbook.Worksheets.Count; i++)
    {
        // Access the worksheet 
        worksheet = workbook.Worksheets[i];

        // Check if worksheet is empty
        if (worksheet.UsedCells.Length == 0)
            Console.WriteLine("The worksheet with name \""+ worksheet.Name + "\" is empty");
    }
}
using (ExcelEngine excelEngine = new ExcelEngine())
{
    IApplication application = excelEngine.Excel;
    application.DefaultVersion = ExcelVersion.Xlsx;
    IWorkbook workbook = application.Workbooks.Open("Input.xlsx");
    IWorksheet worksheet;
    for (int i = 0; i < workbook.Worksheets.Count; i++)
    {
        // Access the worksheet 
        worksheet = workbook.Worksheets[i];

        // Check if worksheet is empty
        if (worksheet.UsedCells.Length == 0)
            Console.WriteLine("The worksheet with name \""+ worksheet.Name + "\" is empty");
    }
}
Using excelEngine As New ExcelEngine()
    Dim application As IApplication = excelEngine.Excel
    application.DefaultVersion = ExcelVersion.Xlsx

    Dim workbook As IWorkbook = application.Workbooks.Open("Input.xlsx")
    Dim worksheet As IWorksheet

    For i As Integer = 0 To workbook.Worksheets.Count - 1
        ' Access the worksheet 
        worksheet = workbook.Worksheets(i)

        ' Check if worksheet is empty
        If worksheet.UsedCells.Length = 0 Then
            Console.WriteLine("The worksheet with name """ & worksheet.Name & """ is empty")
        End If
    Next
End Using

A complete working example in C# is present on this GitHub page.