FlatDataSource flatDataSource = new FlatDataSource();

            ExcelDataConnectionSettings excelDataSettings = new ExcelDataConnectionSettings

            {

                FileStream = pStream,

                GeneratedTypeName = pName,

                WorksheetName = pWorksheetName

            };

            ExcelDataConnectionSettings.AddExcelCellFormatMapping(

                "\"$\"#,##0.00_);[Red]\\(\"$\"#,##0.00\\)",

                "{0:C3}"

            );

            ExcelDataConnectionSettings.AddExcelDateTimeCellFormatMapping("d/m/yy;@", "M/d/yy");

            flatDataSource.ConnectionSettings = excelDataSettings;

            CubeMetadata cubeMetadata = new CubeMetadata()

            {

                DataTypeFullName = "ExcelData",

                DisplayName = "Data",

            };

            flatDataSource.CubesSettings.Add(cubeMetadata);

Column A

Column B

Result

1

2

3

3

4

6

10

8

0

8

System.ArgumentException: Object of type 'System.String' cannot be converted to type 'System.Double'.

   at Infragistics.Olap.Excel.ExcelDataConnectionSettings.RunWorkerCompleted(Object sender, RunWorkerCompletedEventArgs e)

   at System.ComponentModel.BackgroundWorker.OnRunWorkerCompleted(RunWorkerCompletedEventArgs e)

   at System.ComponentModel.BackgroundWorker.AsyncOperationCompleted(Object arg)