private static void LoadProviders() { if (_provider == null) { lock (_lock) { // Do this again to make sure _provider is still null if (_provider == null) { ProviderSection section = (ProviderSection)ConfigurationManager.GetSection("MetaBase"); if (section == null) { throw new System.Exception(string.Format("Section Not Found : {0}", "MetaBase")); } _providers = new ProviderCollection(); ProvidersHelper.InstantiateProviders(section.Providers, _providers, typeof(Data.DataProvider)); _provider = (Data.DataProvider)_providers[section.DefaultProvider]; if (_provider == null) { throw new System.Configuration.Provider.ProviderException("Unable to load Data Provider"); } } } } }
private void AddDemoSheet4() { /****************** Sheet3 : Built-in Cell Types ********************/ var worksheet = grid.NewWorksheet("DataProvider"); Data.DataProvider dp = null; dp = new Data.DataProvider(); dp.ItemsSource = new List <string>() { "A", "B", "C" }; worksheet.RegisterDataProvider(dp); worksheet[0, 0] = "A"; worksheet.GetCell(0, 0).DataProvider = dp; // set default sheet style }
private void AddDemoSheet1() { /****************** Sheet1 : Document Template ********************/ var worksheet = grid.NewWorksheet("Document"); // load template using (MemoryStream ms = new MemoryStream(Properties.Resources.order_sample)) { worksheet.LoadRGF(ms); } // fill data into worksheet var dataRange = worksheet.Ranges["A21:F35"]; dataRange.Data = new object[, ] { { "[23423423]", "Product ABC", 15, 150 }, { "[45645645]", "Product DEF", 1, 75 }, { "[78978978]", "Product GHI", 2, 30 }, }; // set subtotal formula worksheet.Cells["G21"].Formula = "E21*F21"; // auto fill other subtotals worksheet.AutoFillSerial("G21", "G22:G35"); var dp = new Data.DataProvider(); dp.ItemsSource = new List <string>() { "A", "B" }; worksheet.RegisterDataProvider(dp); for (int i = 0; i < 3; i++) { Cell cell = worksheet.GetCell(5, i); if (cell == null) { cell = worksheet.CreateAndGetCell(5, i); } cell.DataProvider = dp; } }