Skip to main content
SearchCtrl K
Community

Source code

OfficeIMO.NET libraries, PowerShell module, CLI, Studio and browser tools 658 stars

Talk and help

DiscordQuestions, ideas and show and tell Report an issueBugs and feature requests SponsorFund ongoing development

Mode

Background

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Search the whole siteOpen search page →
Documentation Search all OfficeIMO/
Class

ExcelDocumentMappingExtensions

OfficeIMO.Excel

Edit on GitHub
Namespace
OfficeIMO.Excel
Assembly
OfficeIMO.Excel
Source revision
e163ccb36643 with working tree changes
Source
ExcelDocument.Mapping.cs:14
Modifiers
static

Typed row projections over a loaded Excel document.

Inheritance

  • object
  • ExcelDocumentMappingExtensions

Methods

RowsAsParallel``1 3 overloads
public static IEnumerable<T> RowsAsParallel<T>(ExcelDocument document, ParallelRowMappingOptions? parallelOptions = null, ExcelReaderOptions? options = null, CancellationToken cancellationToken = default) #

Projects rows in bounded parallel batches, preserving source order.

Type Parameters

T

Parameters

document OfficeIMO.Excel.ExcelDocument required
parallelOptions OfficeIMO.Data.ParallelRowMappingOptions? = null optional
options OfficeIMO.Excel.ExcelReaderOptions? = null optional
cancellationToken System.Threading.CancellationToken = default optional

Returns

IEnumerable<T>
public static IEnumerable<T?> RowsAsParallel<T>(ExcelDocument document, Action<RowMapper<T?>> configure, ParallelRowMappingOptions? parallelOptions = null, ExcelReaderOptions? options = null, CancellationToken cancellationToken = default) #

Projects rows in bounded parallel batches, preserving source order.

Type Parameters

T

Parameters

document OfficeIMO.Excel.ExcelDocument required
configure System.Action<OfficeIMO.Data.RowMapper<T?>> required
parallelOptions OfficeIMO.Data.ParallelRowMappingOptions? = null optional
options OfficeIMO.Excel.ExcelReaderOptions? = null optional
cancellationToken System.Threading.CancellationToken = default optional

Returns

IEnumerable<T?>
public static IEnumerable<T?> RowsAsParallel<T>(ExcelDocument document, Func<IDataRecord, T?> factory, ParallelRowMappingOptions? parallelOptions = null, ExcelReaderOptions? options = null, CancellationToken cancellationToken = default) #

Projects rows in bounded parallel batches, preserving source order.

Type Parameters

T

Parameters

document OfficeIMO.Excel.ExcelDocument required
factory System.Func<System.Data.IDataRecord, T?> required
parallelOptions OfficeIMO.Data.ParallelRowMappingOptions? = null optional
options OfficeIMO.Excel.ExcelReaderOptions? = null optional
cancellationToken System.Threading.CancellationToken = default optional

Returns

IEnumerable<T?>
RowsAs``1 3 overloads
public static IEnumerable<T?> RowsAs<T>(ExcelDocument document, ExcelReaderOptions? options = null, CancellationToken cancellationToken = default) #

Projects rows through the shared data-reader mapping contract.

Type Parameters

T

Parameters

document OfficeIMO.Excel.ExcelDocument required
options OfficeIMO.Excel.ExcelReaderOptions? = null optional
cancellationToken System.Threading.CancellationToken = default optional

Returns

IEnumerable<T?>
public static IEnumerable<T?> RowsAs<T>(ExcelDocument document, Action<RowMapper<T?>> configure, ExcelReaderOptions? options = null, CancellationToken cancellationToken = default) #

Projects rows through the shared data-reader mapping contract.

Type Parameters

T

Parameters

document OfficeIMO.Excel.ExcelDocument required
configure System.Action<OfficeIMO.Data.RowMapper<T?>> required
options OfficeIMO.Excel.ExcelReaderOptions? = null optional
cancellationToken System.Threading.CancellationToken = default optional

Returns

IEnumerable<T?>
public static IEnumerable<T?> RowsAs<T>(ExcelDocument document, Func<IDataRecord, T?> factory, ExcelReaderOptions? options = null, CancellationToken cancellationToken = default) #

Projects rows through the shared data-reader mapping contract.

Type Parameters

T

Parameters

document OfficeIMO.Excel.ExcelDocument required
factory System.Func<System.Data.IDataRecord, T?> required
options OfficeIMO.Excel.ExcelReaderOptions? = null optional
cancellationToken System.Threading.CancellationToken = default optional

Returns

IEnumerable<T?>