コード例 #1
0
ファイル: Program.cs プロジェクト: AqueGen/AS.Excel
        public static void Main(string[] args)
        {
            System.Console.WriteLine(@"Start Spreadsheet Simulator");

            IInput input;

#if DEBUG
            System.Console.WriteLine("----------");
            System.Console.WriteLine("Debug mode");
            System.Console.WriteLine("----------");
            input = CreateTestInput();
#else
            input = new ConsoleInput();
            input.StartInput();
#endif

            ITable table = new CellTable();

            foreach (ICell cell in input.Cells)
            {
                cell.SetupProperties();
                table.AddCell(cell);
                System.Console.WriteLine("Add -> " + cell);
            }
            System.Console.WriteLine();

            table.CalculateCells();

            //Output cells in console
            foreach (ICell cell in table.Cells)
            {
                System.Console.WriteLine(cell.ToString());
            }
            System.Console.WriteLine();

            System.Console.WriteLine("-----Result-----");
            IOutput output = new ConsoleOutput(input.RowCount, input.ColumnCount, table.Cells);
            output.StartOutput();
            System.Console.WriteLine("-----Result-----");

            System.Console.ReadLine();
        }
コード例 #2
0
ファイル: Program.cs プロジェクト: AqueGen/AS.Excel
        private static IInput CreateTestInput()
        {
            List<ICellProperties> propertieses = new List<ICellProperties>
            {
                new CellProperties("12"),
                new CellProperties("=C2"),
                new CellProperties("3"),
                new CellProperties("'Sample"),
                new CellProperties("=A1+B1*C1/5"),
                new CellProperties("=A2*B1"),
                new CellProperties("=B3-C3"),
                new CellProperties("'Spread"),
                new CellProperties("'Test"),
                new CellProperties("=4-3"),
                new CellProperties("5"),
                new CellProperties("'Sheet")
            };

            foreach (var properti in propertieses)
            {
                properti.SetupProperties();
            }

            List<ICell> cells = new List<ICell>
            {
                new Cell(0, 0, propertieses[0]),
                new Cell(1, 0, propertieses[1]),
                new Cell(2, 0, propertieses[2]),
                new Cell(3, 0, propertieses[3]),
                new Cell(0, 1, propertieses[4]),
                new Cell(1, 1, propertieses[5]),
                new Cell(2, 1, propertieses[6]),
                new Cell(3, 1, propertieses[7]),
                new Cell(0, 2, propertieses[8]),
                new Cell(1, 2, propertieses[9]),
                new Cell(2, 2, propertieses[10]),
                new Cell(3, 2, propertieses[11])
            };

            foreach (ICell cell in cells)
            {
                cell.SetupProperties();
            }

            IInput input = new ConsoleInput();

            input.RowCount = 4;
            input.ColumnCount = 4;
            input.Cells = cells;

            return input;
        }