The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Thomas_Bennett
2 years agoNew Contributor III
Add a non CV Excel workbook to a book.
Hi all. So I have a book set up that creates an excel workbook based on a loop of entities. It works absolutely fine, however, the book is 300 worksheets or so. Therefore its pretty handy to have an ...
- 2 years ago
I'm just going by the documentation (not a book expert).
"Output Name: Type a name for the file when creating a Zip book. If the .pdf extension is included for a Word or Excel file, the file will be converted into a PDF. This property is optional and does not apply to PDF books."
That would indicate to me that your output name must contain the file extension.
However, if your book is an excel one, there is this addition:
NOTE: Report and File items are not supported by Excel books and are ignored if added.
... which sadly is your case, I believe.
Thomas_Bennett
2 years agoNew Contributor III
Shame about that, Not the end of the world though. I can add the finishing touches and the page with VBA.
Cheers,
Tom
Related Content
- 2 years ago
- 7 months ago
- 4 years ago
- 2 years ago