C# 클래스 ExoModel.ETL.ExcelFile

Loads an XLSX file into memory and exposes each worksheet as a table of string values.
상속: IDisposable
파일 보기 프로젝트 열기: vc3/ExoModel 1 사용 예제들

공개 메소드들

메소드 설명
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