public Form1()
{
InitializeComponent();
_calcEngine = new C1CalcEngine(new VBAEngine());
c1FlexGrid1.DataSource = _calcEngine.DataSource = new Prod[]
{
new Prod {
Product = "Chai", Qnt = 18, Price = 18.1
},
new Prod {
Product = "Pavlova", Qnt = 11, Price = 17.45
},
new Prod {
Product = "Sir Rodney's Marmalade", Qnt = 1, Price = 40
},
new Prod {
Product = "Ipoh Coffee", Qnt = 10, Price = 14.0
},
new Prod {
Product = "Mascarpone Fabioli", Qnt = 16, Price = 32.0
},
new Prod {
Product = "Schoggi Schokolade", Qnt = 12, Price = 43.9
},
};
}
public ExcelEngineDemo()
{
InitializeComponent();
// Create C1CalcEngine instance with ExcelEngine
_calcEngine = new C1CalcEngine(new ExcelEngine());
// Set data source for the first grid.
var data1 = GetDataTable("Sheet1");
sheet1.DataSource = data1;
for (int i = 1; i <= 80; i++)
{
sheet1.Rows[i][0] = i;
}
sheet1.AutoSizeCol(0);
// Configure the second grid.
LoadUnboundGrid(sheet2);
// Set engine data source.
_calcEngine.DataSource = new List <IDataSheet> {
data1, sheet2
};
// Select some cells.
this.sheet1.Select(1, 1, 2, 2);
sheet2.Select(3, 2, 5, 3);
}
public Form1()
{
InitializeComponent();
_calcEngine = new C1CalcEngine(new ExcelEngine());
var sheet1 = GetDataTable("Sheet1");
c1FlexGrid1.DataSource = sheet1;
for (int i = 1; i <= 80; i++)
{
c1FlexGrid1.Rows[i][0] = i;
}
c1FlexGrid1.AutoSizeCol(0);
LoadUnboundGrid(sheet2);
sheet2.AutoSizeCol(0);
_calcEngine.DataSource = new List <IDataSheet> {
sheet1, sheet2
};
c1FlexGrid1.Select(1, 1, 2, 2);
sheet2.Select(3, 2, 5, 3);
}
