09-05-2023 12:25 PM
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
Solved! Go to Solution.
09-08-2023 03:38 AM
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.
09-08-2023 03:26 AM
Some named ranges are created by default, did you see them?
09-08-2023 03:31 AM
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'.
09-08-2023 03:38 AM
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.
09-08-2023 03:42 AM - edited 09-08-2023 03:44 AM
Haha!
I have actually been trying to create an excel export using a an extender business rule (using information found on this post - https://community.onestreamsoftware.com/t5/Rules/Create-Excel-spreadsheet-from-Business-Rules/m-p/24...) but I am getting an error that says 'Could not find a part of the path' when trying to create the file.
09-08-2023 03:49 AM
That's a filesystem issue. If the rule is running in the Windows app, it likely has no access to your Documents folder; and if (more likely) it's executed on the server, that folder probably does not even exist there. You should target server folders that you know exist and are writeable by OneStream.