4 Replies Latest reply: Aug 6, 2013 8:59 AM by Elad Betite RSS

    Get sheet name of active sheet , GetProperties();

    Elad Betite

      I'm trying to get seet name by the following code:

      ...

      Sheet s = axQlikOCX1.ActiveDocument.GetSheet(i.ToString());

      string sheetName = s.GetProperties().Name;

      ...

      In some files I get the display sheet name BUT in some I get a formula like this:

      for sheet Name="Dashboard" I get "=Only({<Index = {1}>} [$(vLanguage)])  "

      in other file

      for sheet name="Intro" I get   "=Minstring(if(Reference = 'Intro', [$(vLanguage)])) "

       

      Is there a way to get the display sheet name ("Intro"/"Dashboard") that suitable for all QV files?

       

      best regards