C# Класс ExoModel.ETL.ExcelFile

Loads an XLSX file into memory and exposes each worksheet as a table of string values.
Наследование: IDisposable
Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод Описание
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.

Приватные методы

Метод Описание
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

Описание методов

Read() публичный статический Метод

Reads an ExcelFile from the specified stream as an ITable instance.
public static Read ( Stream file, TableMapping mapping = null ) : ITable
file Stream
mapping TableMapping
Результат ITable

Write() публичный статический Метод

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
Результат void

Write() публичный статический Метод

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
Результат void