How to programmatically create a new Excel File with a EntityCellValue populated?
End goal: For a given JSON object, which is a valid Data Entity Type, how would one create a new MS Excel File with Sheet1!A1 populated with the Data Entity Type.
MS Excel supports Data Entity Types which allows one to store and display richer data structures within Excel: https://learn.microsoft.com/en-us/office/dev/add-ins/excel/excel-data-types-entity-card
Here is an example of what this looks like:
We are able to programmatically populate simple data types (string, numbers, etc.) using a package like excelize (https://github.com/qax-os/excelize/issues/1853). But since a Data Entity Type is a fairly complex structure, how would one programmatically create a new MS Excel file with say Sheet1!A1 value populated with a Data Entity Type?
I'm able to populate a cell with a Data Entity Type using the Script Lab. Here is a gist one could use to Import into Script Lab: https://gist.github.com/jankrynauw/56e85aa73aea3bfd3fc2d9f4b707d6bb Script Labs obviously runs within an existing MS Excel environment which then renders the custom function response as a Data Entity Type. How would one do this 'outside' an excel environment.