Click or drag to resize

IExcelReader Interface

Provide methods for reading an excel file.
Example
C#
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
C#
public interface IExcelReader : IDisposable, 
	IIOApi

The IExcelReader type exposes the following members.

Methods
 NameDescription
Public methodClose Close the connection to an excel file.
Public methodDisposePerforms application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
(Inherited from IDisposable)
Public methodGetSheet Get a sheet by its index.
Public methodOpen(Byte) Connect to the byte array of an excel file to prepare for reading.
Public methodOpen(Stream) Connect to the file stream to prepare for reading.
Top
See Also