Click or drag to resize

ExcelToPdfGetSheetsNumber(Byte) Method

Returns numbers of sheets from Excel workbook

Namespace: SautinSoft
Assembly: SautinSoft.ExcelToPdf (in SautinSoft.ExcelToPdf.dll) Version: 2024.11.30
Syntax
public int GetSheetsNumber(
	byte[] excelBytes
)

Parameters

excelBytes  Byte
Array of bytes containing Excel document

Return Value

Int32
Number of sheets
-1 - unable to read workbook
Example
Get number of sheets in Excel workbook in C#
using System;
using System.IO;
using SautinSoft;

namespace Sample
{
    class Sample
    {
        static void Main(string[] args)
        {
            // Before starting, we recommend to get a free 100-day key:
            // https://sautinsoft.com/start-for-free/

            // Apply the key here:
            // SautinSoft.ExcelToPdf.SetLicense("...");
            // Get sheets number.
            ExcelToPdf x = new ExcelToPdf();

            FileInfo excelFile = new FileInfo(@"..\..\..\test.xlsx");            

            try
            {
                int sheets = x.GetSheetsNumber(excelFile.FullName);
                Console.WriteLine("The file {0} has {1} sheet{2}.",excelFile.Name, sheets, (sheets>1)?"s":"");
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);                
            }
            Console.ReadLine();
        }
    }
}
Get number of sheets in Excel workbook in VB.Net
Imports System
Imports System.IO
Imports SautinSoft

Module Sample

    Sub Main()

        ' Before starting, we recommend to get a free 100-day key:
        ' https://sautinsoft.com/start-for-free/

        ' Apply the key here:
        ' SautinSoft.ExcelToPdf.SetLicense("...");
        ' Get sheets number.
        Dim x As New ExcelToPdf()

        Dim excelFile As New FileInfo("..\..\..\test.xlsx")

        Try
            Dim sheets As Integer = x.GetSheetsNumber(excelFile.FullName)
            Console.WriteLine("The file {0} has {1} sheet{2}.", excelFile.Name, sheets, If(sheets > 1, "s", ""))
        Catch ex As Exception
            Console.WriteLine(ex.Message)
        End Try
        Console.ReadLine()
    End Sub
End Module
See Also