AMPSExcel.AMPSAddin.WorkbookInfo.WorkbookInfo C# (CSharp) Method

            public WorkbookInfo(Excel.Workbook workbook)
            {
                // make the special worksheet
                _workbook = workbook;
                Excel.Worksheet subsSheet = getWorksheet("amps-subs");
                Excel.Worksheet serversSheet = getWorksheet("amps-servers");
                for (int i = 1; i < serversSheet.Cells.Rows.Count; i++)
                {
                    if (string.IsNullOrEmpty(serversSheet.Cells[i, 1].Value)) break;
                    string name = serversSheet.Cells[i, 1].Value;
                    string url = serversSheet.Cells[i, 2].Value;
                    string messageType = serversSheet.Cells[i, 3].Value;
                    this.Servers[name] = new ServerDefinition
                    {
                        Name = name,
                        URL = url,
                        MessageType = messageType,
                        Row = i
                    };
                }
                for (int i = 1; i < subsSheet.Cells.Rows.Count; i++)
                {
                    if (string.IsNullOrEmpty(subsSheet.Cells[i, 1].Value)) break;
                    string serverName = subsSheet.Cells[i, 1].Value;
                    this.Subscriptions[subsSheet.Cells[i, 1].Value] = new SubscriptionDefinition
                    {
                        Name = subsSheet.Cells[i,1].Value,
                        ServerName = subsSheet.Cells[i, 2].Value,
                        Topic = subsSheet.Cells[i, 3].Value,
                        Filter = subsSheet.Cells[i, 4].Value,
                        WorksheetRange = subsSheet.Cells[i, 5].Value,
                        Row = i
                    };
                }
            }