InterfaceICellExporter
Streams cell content and formatting to an output spreadsheet document in a forward-only, low-memory fashion.
Definition
Namespace:Telerik.Documents.SpreadsheetStreaming
Assembly:Telerik.Documents.SpreadsheetStreaming.dll
Syntax:
public interface ICellExporter : IDisposableInherited Members
Methods
SetFormat(SpreadCellFormat)
Apply the provided cell format (style, number format, alignment, borders, etc.) to the current cell.
Declaration
void SetFormat(SpreadCellFormat cellFormat)Parameters
cellFormat
The cell format.
SetFormula(string)
Write a formula expression and mark the cell as formula typed.
Declaration
void SetFormula(string value)Parameters
value
The formula value.
Remarks
Cells written via this overload are always visible during a BeginFiltering(SpreadAutoFilter) block because no cached value is available for filter evaluation. Use SetFormula(string, string) to participate in filtering.
SetFormula(string, string)
Write a formula expression with a pre-computed cached value. The cached value is written to the output as the cell value element and is used for filter evaluation when the cell participates in a BeginFiltering(SpreadAutoFilter) block.
Declaration
void SetFormula(string formula, string cachedValue)Parameters
formula
The formula expression.
cachedValue
The pre-computed cached value.
Exceptions
Thrown when formula or cachedValue is null.
Remarks
The cachedValue is REQUIRED for the cell to participate in
BeginFiltering(SpreadAutoFilter) evaluation. The single-arg
SetFormula(string) overload writes a formula whose cell is always
visible during filtering (no cached value to evaluate against).
SetValue(DateTime)
Write a DateTime value converted to the spreadsheet serial number representation.
Declaration
void SetValue(DateTime value)Parameters
value
The DateTime value.
SetValue(bool)
Write a boolean value (TRUE/FALSE) to the current cell.
SetValue(double)
Write a numeric (double) value to the current cell for number/date formatting.
SetValue(string)
Write a string value to the current cell.