Forum Discussion

lp's avatar
lp
New Contributor II
11 months ago

Excel File in Book

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 ...
Books
  • AMorgan's avatar
    AMorgan
    11 months ago

    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's avatar
MikeG
Contributor III
11 months ago

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,