Repository navigation
Defined names - API #726
Description
As I look at implementing GetCellFormula(int index) for XLS, there are some dependencies, for example defined names. These are defined on the worksheet and workbook level. See, for example https://docs.devexpress.com/OfficeFileAPI/DevExpress.Spreadsheet.DefinedName.
To help shape how I implement this, would it be useful to expose a class like
public class DefinedName
{
public string Name { get; }
public string Formula { get; }
public bool IsGlobal { get; }
}and an API like
public interface IExcelDataReader
{
public IReadOnlyList<DefinedName> GetDefinedNames();
public IReadOnlyList<DefinedName> GetDefinedNames(int sheetIndex);
}What do you think?
Activity
appel1 commentedon Nov 11, 2025
Thank you for digging into this!
In general we've tried to only keep track of per-sheet data while the sheet is being read. Is there a compelling reason for GetDefinedName(int)? Or is this due to how the data is stored so we can load it on demand in an efficient manner?
Since both return values are lists maybe call both GetDefinedNames?
What's the IsGlobal property for when there are two separate methods for workbook/worksheet names?