ExcelDataConnectionSettings Class

Used by Infragistics.Olap.FlatData.FlatDataSource to open and use Excel files as data source.

Syntax

Visual Basic

'Declaration
 
Public Class ExcelDataConnectionSettings 
   Implements Infragistics.Olap.FlatData.IFlatDataConnectionSettings, Infragistics.Olap.IConnectionSettings 

C#

public class ExcelDataConnectionSettings : Infragistics.Olap.FlatData.IFlatDataConnectionSettings, Infragistics.Olap.IConnectionSettings  

Remarks

Setting the FileStream property will initiate processing of the data found in the file so it's important to have GeneratedTypeName and WorksheetName or WorksheetIndex properties set first. When GeneratedTypeName is not specified then default "ExcelData" value will be used for that type name. For each row found in the excel's sheet specified by WorksheetName or WorksheetIndex will be generated instances of type specified by GeneratedTypeName and ItemsSource list will be updated with these instances and then ItemsSourceChanged event is fired.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2