API Reference
Class
ExcelHostExtensions
Helper extensions for common Excel document tasks (sheet resolution, A1 parsing).
Inheritance
- Object
- ExcelHostExtensions
Methods
public static ExcelSheet GetOrCreateSheet(ExcelDocument document, String name, SheetNameValidationMode validationMode) #Returns:
ExcelSheetReturns the named sheet if it exists, otherwise creates it; falls back to the last sheet.
Parameters
- document OfficeIMO.Excel.ExcelDocument
- name System.String
- validationMode OfficeIMO.Excel.SheetNameValidationMode
public static ValueTuple<Int32, Int32> ResolveCellAddress(Nullable<Int32> row, Nullable<Int32> column, String address) #Returns:
ValueTuple<Int32, Int32>Resolves a cell address from either A1 notation or row/column coordinates.
Parameters
- row System.Nullable{System.Int32}
- column System.Nullable{System.Int32}
- address System.String
public static Int32 ResolveColumnIndex(Nullable<Int32> columnIndex, String columnName) #Returns:
Int32Resolves a column index from either a numeric index or column letters.
Parameters
- columnIndex System.Nullable{System.Int32}
- columnName System.String
Inherited Methods
public override Boolean Equals(Object obj) #Returns:
BooleanInherited from Object
Parameters
- obj Object