[Advanced Excel] Workbook_Create parameter SheetNames should be marked mandatory

Forge Component
Published on 2019-08-27 by Hanno
66 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



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


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.