ExcelToPdfGetSheetsNumber(String) Method |
Returns numbers of sheets from Excel workbook
Namespace: SautinSoftAssembly: SautinSoft.ExcelToPdf (in SautinSoft.ExcelToPdf.dll) Version: 2024.11.30
Syntax public int GetSheetsNumber(
string excelPath
)
Public Function GetSheetsNumber (
excelPath As String
) As Integer
Parameters
- excelPath String
- Path to Excel file
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