Forum Discussion

MarkBird's avatar
MarkBird
Contributor III
2 years ago

Add a named range to an excel export item in a book

Hi 

We are creating a book that loops over an excel export item to create multiple tabs (see below):

Is there any way to add a named range around each exported cube view?

Thanks,

Mark

Books
  • JackLacava's avatar
    JackLacava
    2 years ago

    Book definitions are too dumb to do that sort of work. The only way I can see this happening is by triggering an extender after export, to postprocess the file.

  • JackLacava's avatar
    JackLacava
    Honored Contributor
    2 years ago

    Some named ranges are created by default, did you see them?

     

    • MarkBird's avatar
      MarkBird
      Contributor III
      2 years ago

      I did, but we are looking to have a custom named range.

      We are trying to create a extract book that we can use as an upload template. So we are trying to create custom named ranges that start with 'xfd'.

      • JackLacava's avatar
        JackLacava
        Honored Contributor
        2 years ago

        Book definitions are too dumb to do that sort of work. The only way I can see this happening is by triggering an extender after export, to postprocess the file.