[Advanced Excel] Workbook_Create parameter SheetNames should be marked mandatory

Forge Component
(60)
Published on 2019-08-27 by Hanno
60 votes
Published on 2019-08-27 by Hanno

I've been scratching my head trying to figure out how to get a simple Workbook downloaded using Advanced_Excel. Here is the entire flow:

The problem lies in Workbook_Create. When SheetNames is not populated, then I'll get an error "The workbook must contain at least one worksheet" when I call Workbook_GetBinaryData:


To get this to work... I actually need:


My understanding from the documentation is that I can specify:

FirstSheetName AND NrSheets

OR

SheetNames

But as it turns out, I MUST specify SheetNames. This is quite confusing! SheetNames should be marked as Mandatory in the Extension.

Solution

Thank you Nicolaas, it is indeed a bug. It is fixed in the latest "under development" version I believe. If not I will take a look at it asap. 

Solution