Skip to main content
M
MarkBird
September 5, 2023
Solved

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

  • September 5, 2023
  • 1 reply
  • 0 views

Hi 

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

MarkBird_0-1693930996527.png

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

Thanks,

Mark

Best answer by JackLacava

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.

1 reply

J
JackLacava
September 8, 2023

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

JackLacava_0-1694157996413.png

 

M
MarkBirdAuthor
September 8, 2023

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'.

J
JackLacavaAnswer
September 8, 2023

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.

Terms & ConditionsAccessibility statement