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

AMorgan's avatar
AMorgan
New Contributor
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