@herong0101
Again I am pasting my above solution...
My sample doc which i uploaded in my OneDrive(This document also attached for your reference - you modify as per your requirement and upload into your onedrive).
Launching Excel and reading data:
- The code starts by launching Excel and opening an existing Excel file located at. For example: C:\\Boot\\Wordtemplate.xlsx.
- It reads all the data from the Excel file into a variable named ExcelData.
Converting data to JSON format:
- A new variable named JsonVar is created as an empty object.
- The data read from Excel (ExcelData) is stored as a property named 'Table' in the JsonVar object.
Converting JSON data back to an object:
- The JSON data stored in CustomObjectAsJson is converted back to a custom object using the Variables.ConvertJsonToCustomObject action.
- The resulting custom object is stored in a variable named JsonAsCustomObject.
Accessing specific data from the object:
- The data from the 'Table' property of the JsonAsCustomObject is extracted and stored in a variable named JSONDATA.
Populate a Microsoft word template:
Invoke the word document which we want to fill and pass json data in contactsrow parameter.
Output:
Hope it helps!!
Thanks,
Deenuji Loganathan 👩💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥
-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀
