ICellExporter
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
Apply the provided cell format (style, number format, alignment, borders, etc.) to the current cell.
void SetFormat(SpreadCellFormat cellFormat)The cell format.
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.
void SetFormula(string formula, string cachedValue)The formula expression.
cachedValuestringThe pre-computed cached value.
Exceptions:Thrown when formula or cachedValue is null.
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).
Write a formula expression and mark the cell as formula typed.
void SetFormula(string value)The formula value.
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.
Write a boolean value (TRUE/FALSE) to the current cell.
Write a DateTime value converted to the spreadsheet serial number representation.
Write a numeric (double) value to the current cell for number/date formatting.
Write a string value to the current cell.