private static void ReadExcel() { var repo = new YieldRepository(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "sample.xlsx")); var date = new DateTime(2015, 4, 2); var meetings = repo.GetCopomMeetings(date).ToArray(); Debug.Assert(meetings.Length == 22); var di1s = repo.GetDI1s(date).ToArray(); Debug.Assert(di1s.Length == 37); var from = date; var to = date.AddDays(1); int days = repo.GetNetworkDays(from, to); Debug.Assert(days == 1); var yields = repo.BuildYield(date).ToArray(); Debug.Assert(yields.Length == meetings.Length + di1s.Length + 1); }
private static void Main(string[] args) { ReadExcel(); //var repo = new YieldRepository(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "sample.xlsx")); var repo = new YieldRepository("sample.xlsx"); while (Console.ReadLine() != "q") { var clock = Stopwatch.StartNew(); var yields = repo.BuildYield(new DateTime(2015, 4, 2)).ToArray(); Console.WriteLine($"ElapsedMilliseconds={clock.ElapsedMilliseconds}"); //MinimizeSimple(); var form = new Form(); var grid = new DataGridView(); form.Controls.Add(grid); grid.Dock = DockStyle.Fill; grid.AutoGenerateColumns = true; grid.DataSource = yields; grid.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableAlwaysIncludeHeaderText; form.ShowDialog(); } }