ExcelToPdfGetSheetsNumber(Byte) Method |
Returns numbers of sheets from Excel workbook
Namespace: SautinSoftAssembly: SautinSoft.ExcelToPdf (in SautinSoft.ExcelToPdf.dll) Version: 2024.11.30
Syntax public int GetSheetsNumber(
byte[] excelBytes
)
Public Function GetSheetsNumber (
excelBytes As Byte()
) As Integer
Parameters
- excelBytes Byte
- Array of bytes containing Excel document
Return Value
Int32Number 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)
{
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()
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