Skip to main content
Veteran
Sep 5, 2023 4:25 PM UTC
Solved

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):

MarkBird_0-1693930996527.png

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

Thanks,

Mark

Employee - Sage
Sep 8, 2023 7:38 AM UTC

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.

5 replies

Employee - Sage
Sep 8, 2023 7:26 AM UTC

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

JackLacava_0-1694157996413.png

 

MarkBirdAuthor
Veteran
Sep 8, 2023 7:31 AM UTC

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

Employee - Sage
Sep 8, 2023 7:38 AM UTC

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.