How to programmatically create a new Excel File with a EntityCellValue populated?

Jan Krynauw 0 Reputation points
2024-03-27T10:07:03.65+00:00

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:

entity

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.

Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments
{count} votes

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.