Esempio n. 1
0
        public void ExcelMappingTest()
        {
            //IMcOleDbHelper helper = (IMcOleDbHelper)Activator.GetObject(typeof(IMcOleDbHelper),
            //                                                    ConfigurationManager.AppSettings["McOleDbServiceString"]);

            //DataSet dataSet = helper.ConvertExcelToDataSet("price.xls");
            DataSet dataSet = ConvertExcelToDataSet("price.xls");

            MappingEngine mapEngine = new MappingEngine();

            mapEngine.MappingErrorEvent += ErrorHandler;

            MappingDocument mapDoc = MappingDocument.LoadFromFile("priceMapping.xml");

            mapEngine.ProcessMapping(mapDoc, dataSet);
        }