C# Class ExoModel.ETL.ExcelFile

Loads an XLSX file into memory and exposes each worksheet as a table of string values.
Inheritance: IDisposable
Exibir arquivo Open project: vc3/ExoModel Class Usage Examples

Public Methods

Method Description
Read ( Stream file, TableMapping mapping = null ) : ITable

Reads an ExcelFile from the specified stream as an ITable instance.
Write ( ITable table, SpreadsheetDocument document, TimeZoneInfo timezone = null ) : void

Writes an ITable instance as an ExcelFile to the specified stream.
Write ( ITable table, Stream file, TimeZoneInfo timezone = null ) : void

Writes an ITable instance as an ExcelFile to the specified stream.

Private Methods

Method Description
ExcelFile ( ) : System
ExcelFile ( Stream file ) : System

Create a new ExcelFile from the specified stream.
GetCellReference ( uint column, uint row ) : string

Gets the cell reference for the specified column and row indexes.
IDisposable ( ) : void

Method Details

Read() public static method

Reads an ExcelFile from the specified stream as an ITable instance.
public static Read ( Stream file, TableMapping mapping = null ) : ITable
file Stream
mapping TableMapping
return ITable

Write() public static method

Writes an ITable instance as an ExcelFile to the specified stream.
public static Write ( ITable table, SpreadsheetDocument document, TimeZoneInfo timezone = null ) : void
table ITable
document SpreadsheetDocument
timezone System.TimeZoneInfo
return void

Write() public static method

Writes an ITable instance as an ExcelFile to the specified stream.
public static Write ( ITable table, Stream file, TimeZoneInfo timezone = null ) : void
table ITable
file Stream
timezone System.TimeZoneInfo
return void