コード例 #1
0
 /// <summary>
 /// Verifies that workbook-scoped named ranges exist, and that they have
 /// valid range references.
 /// </summary>
 /// <exception cref="iClickerQuizPts.AppExceptions.MissingInvalidNmdRngException">
 /// Caught and rethrown when there are problems with the validity of a
 /// workbook-scoped named range.</exception>
 public virtual void VerifyWbkScopedNames(params string[] nms)
 {
     for (int i = 0; i < nms.Length; i++)
     {
         string iClkrNm = nms[i];
         if (!_nrWrppr.WorkbookScopedRangeExists(iClkrNm))
         {
             MissingInvalidNmdRngException ex =
                 new MissingInvalidNmdRngException(RangeScope.Wkbk, iClkrNm);
             throw ex;
         }
     }
 }
コード例 #2
0
 /// <summary>
 /// Verifies that worksheet-scoped named ranges exist, and that they have
 /// valid range references.
 /// </summary>
 /// <exception cref="iClickerQuizPts.AppExceptions.MissingInvalidNmdRngException">
 /// Caught and rethrown when there are problems with the validity of a
 /// worksheet-scoped named range.</exception>
 public virtual void VerifyWshScopedNames(params string[] nms)
 {
     for (int i = 0; i < nms.Length; i++)
     {
         // Since this is the only sheet holding named ranges...
         string qzDataWshNm = Globals.Sheet1.Name;
         string iClikerNm   = nms[i];
         if (!_nrWrppr.WorksheetScopedRangeExists(qzDataWshNm, iClikerNm))
         {
             MissingInvalidNmdRngException ex =
                 new MissingInvalidNmdRngException(RangeScope.Wksheet, iClikerNm, qzDataWshNm);
             throw ex;
         }
     }
 }