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

            public void createOrUpdate(SubscriptionDefinition d)
            {
                var subs = getWorksheet("amps-subs");
                int row = 1;
                if (!Subscriptions.ContainsKey(d.Name))
                {
                    // go make a new row.
                    while (true)
                    {
                        if (string.IsNullOrEmpty(subs.Cells[row, 1].Value)) break;
                        row++;
                    }
                }
                else
                {
                    row = Subscriptions[d.Name].Row;
                }

                subs.Cells[row, 1].Value = d.Name;
                subs.Cells[row, 2].Value = d.ServerName;
                subs.Cells[row, 3].Value = d.Topic;
                subs.Cells[row, 4].Value = d.Filter;
                subs.Cells[row, 5].Value = d.WorksheetRange;
                d.Row = row;
                Subscriptions[d.Name] = d;
            }