XlsDataProvider Class

In This Topic

Object Model
Syntax
Remarks
Inheritance Hierarchy
Requirements
See Also

This data provider can be used to bind to Microsoft Excel data (*.xls, *.xlsx).

Object Model

Syntax

public sealed class XlsDataProvider : IDataProvider

public ref class XlsDataProvider sealed : public IDataProvider

'Declaration
 
Public NotInheritable Class XlsDataProvider 
   Implements IDataProvider

Remarks

General information:
- When using multiple different field types in a single column the field type wins that was added first and therefore defines the field type for all fields in a column.
- Worksheet = Table, i.e. every single worksheet will be added as a single table.
- Content of connected cells will be passed as content for the first field of the interconnection. Following fields will be added with content "0".

Restrictions:
- The output of evaluated field content is not possible.
- Sorting the data provider is not possible. Data must be sorted in the excel file.
- Empty lines in the excel file are ignored and not used.
- For worksheet names the same conditions for field and variable names apply, further information can be found in the Programmer's Manual (chapter "Hints on Variable and Field Names").

Inheritance Hierarchy

System.Object
combit.Reporting.DataProviders.XlsDataProvider

Requirements

Reference

XlsDataProvider Members
combit.Reporting.DataProviders Namespace

Send Feedback