Excel File in Book

Question

Hello,
I am trying to insert an excel file (tab) into a book that will export to excel. The purpose of the file is to insert a tab as a separator between report tabs so that the name of this excel tab denotes the type of reports that come next. I am having trouble inserting an excel file so I have created a work around by creating a blank cube view and giving it the output name that I want it to have and then brining that "report" into the book, but I don't feel like I should have to do that. If anyone has any knowledge on adding an excel file to a book, that would be great.
Thanks!

AMorgan · Accepted Answer

Hello lp,As of now I do not believe you can add file components to a XLBook report book. See design & reference guide: I believe your method is the best bet as of now, but I believe there would be enough interest in making an enhancement to address this issue, so it might be worthwhile posting this request in Ideastream. Additionally, you might be able to use OpenXML to build the "separator" tabs into your workbook. That would be a heavier up-front task, but if built right, you should be able to reuse the logic and even develop a dashboard to control it all.-Allen

MikeG · Answer

Hi lp Is this how you have your setup? You'll want to create your objects in the Book as Excel Export Item:

This can be a Cube View:

Lastly, how you name the Book file is important, it needs to be an XLBook.

You can create a Loop and use a Loop1Variable as the sheet name, i.e. Entity is the loop member list as Loop1Variable. If you want to insert a Page Break, I think your method is valid. I've created Report Book cover pages by using a Report Designer component, that gives you more formatting flexibility on your Page Breaks.

So it would look like this:

Hope this helps,

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded