Gets or sets the sheet name.
public string Name { get; set; }
The sheet name.
With identifying and customizing the sheet name, it is easy to navigate and being referenced among multiple sheets.
using Leadtools;
using Leadtools.Document.LEADOffice.Sheet;
public void ReadExcelFileExample()
{
var filePath = Path.Combine(LEAD_VARS.ImagesDir, @"WorkbookTest.xlsx");
// Load an Excel workbook from a file
var workbook = LEADWorkbookFactory.LoadFromFile(filePath, new LoadWorkbookOptions());
Console.WriteLine("Sheets in the workbook:");
// Iterate over sheets
foreach (var sheet in workbook)
{
Console.WriteLine(sheet.Name);
}
}
static class LEAD_VARS
{
public const string ImagesDir = @"C:\LEADTOOLS23\Resources\Images";
}