Class RVExcelDataSourceItem

The data source item used to represent a dataset from an Excel file, it includes information like the name of the sheet to get data from and the range to use when loading data.

Inheritance
System.Object
RVDataSourceItem
RVResourceBasedDataSourceItem
RVExcelDataSourceItem
RVGoogleSheetDataSourceItem
Inherited Members
Namespace: Reveal.Sdk.Data.Excel
Assembly: Infragistics.Reveal.DataLayer.dll
Syntax
public class RVExcelDataSourceItem : RVResourceBasedDataSourceItem, IDataSourceItem

Constructors

RVExcelDataSourceItem(IRVResourceItem)

Declaration
public RVExcelDataSourceItem(IRVResourceItem resourceItem)
Parameters
Type Name Description
IRVResourceItem resourceItem

RVExcelDataSourceItem(IRVResourceItem, BaseDataSourceItem)

Declaration
public RVExcelDataSourceItem(IRVResourceItem resourceItem, BaseDataSourceItem modelDataSourceItem)
Parameters
Type Name Description
IRVResourceItem resourceItem
Infragistics.ReportPlus.DashboardModel.BaseDataSourceItem modelDataSourceItem

Properties

FirstRowContainsLabels

Flag indicating if the first row contains labels or data, it defaults to true. If you set this flag to false the columns will be automatically named as 'COL1', 'COL2', etc.

Declaration
public bool FirstRowContainsLabels { get; set; }
Property Value
Type Description
System.Boolean

NamedRange

Named range to get data from, it's optional and if no specified the sheet specified in Sheet will be used.

Declaration
public string NamedRange { get; set; }
Property Value
Type Description
System.String

PivotTable

Name of the pivot table to get data from.

Declaration
public string PivotTable { get; set; }
Property Value
Type Description
System.String

Range

Definition of the range to load data from in the specified sheet.

Declaration
public RVExcelRange Range { get; set; }
Property Value
Type Description
RVExcelRange

Sheet

Name of the sheet in the worksheet to get the data from, if not specified and NamedRange is null, then the first sheet in the file will be used.

Declaration
public string Sheet { get; set; }
Property Value
Type Description
System.String

Methods

CreateModelDataSourceItem()

Declaration
public override BaseDataSourceItem CreateModelDataSourceItem()
Returns
Type Description
Infragistics.ReportPlus.DashboardModel.BaseDataSourceItem
Overrides
RVResourceBasedDataSourceItem.CreateModelDataSourceItem()