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;
}
}
