The following tables list the members exposed by ExcelDataConnectionSettings.
| Name | Description | |
|---|---|---|
 | ExcelDataConnectionSettings Constructor |
| Name | Description | |
|---|---|---|
 | FileStream | Gets or sets System.IO.Stream of the excel file. Setting this property will initiate processing of the data found in the file. 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. |
| GeneratedTypeName | Gets or sets the name that is used for dynamically created class for the data extracted from the excel's file. |
| ItemsSource | Gets the collection of the items source. |
| WorksheetIndex | Gets or sets the index of the worksheet that is opened. |
| WorksheetName | Gets or sets the name of the worksheet that is opened. Is takes precedence over WorksheetIndex property. |
| Name | Description | |
|---|---|---|
  | AddExcelCellFormatMapping | Maps given excel cell format string to format string that will be used when data is visualized. |
| AddExcelDateTimeCellFormatMapping | Maps given excel datetime cell format string to format string that will be used when data is visualized. |
| GetDateTimeValueFormat | Gets the format string registered for given datetime excel cell format string. |
| GetValueFormat | Gets the format string registered for given excel cell format string. |
| RemoveExcelCellFormatMapping | Remove the mappings for given excel cell format string. |
| RemoveExcelDateTimeCellFormatMapping | Remove the mappings for given excel datetime cell format string. |
| Name | Description | |
|---|---|---|
 | OnItemsSourceChanged | Called when ItemsSource property changes. |
| Name | Description | |
|---|---|---|
 | ItemsSourceChanged | Fired when Infragistics.Olap.FlatData.IFlatDataConnectionSettings.ItemsSource is changed. |