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
Solved
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 ...
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.
Thanks Jack! Shame the Freeze pane option isnt already in OS. You could assume book functionality is a lower priority than system reports like CVs and Dashboards but they are so handy as accountants loooove Excel! I guess for now its trusty VBA!
As for the index page. Where am I going wrong? I have no index page in my report nor as I assumed incorrectly did it generate separately.
JackLacava
OneStream Employee
OneStream EmployeeI'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.