IExcelReader Interface

Provide methods for reading an excel file.

Examples

var reader = Readers.GetExcelReader();
using(reader.Open(documentApi.OpenRead(ctx.Input.DocumentAttribute)))
{
    var workSheetReader = reader.GetSheet(0);
    var rowCount = workSheetReader.RowCount;
    var columnCount = workSheetReader.ColumnCount;
    for (int row = 0; row < rowCount; row++) {
        for (int col = 0; col < columnCount; col++) {
            var value = workSheetReader.Read<string>(row, col);
        }
    }
}

Namespace: Casewhere.Runtime.IO
Assembly: Casewhere.Runtime.IO (in Casewhere.Runtime.IO.dll) Version: 1.0.0.0 (1.0.0.0)

Syntax

Copy

public interface IExcelReader : IDisposable, 
	IIOApi

The IExcelReader type exposes the following members.

Methods

	Name	Description
	Close	Close the connection to an excel file.
	Dispose	Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. (Inherited from IDisposable.)
	GetSheet	Get a sheet by its index.
	Open(Byte)	Connect to the byte array of an excel file to prepare for reading.
	Open(Stream)	Connect to the file stream to prepare for reading.

Top

Reference

Casewhere.Runtime.IO Namespace