[Excel_Library] Data_WriteJSON action generates empty Excel despite valid JSON input

Harjindra Singh

Question

I am using ODC Studio and the Excel Library ODC component. I am trying to use the Data_WriteJSON action, which is intended to load JSON data into an Excel table.

Steps Performed:-

1. Created a workbook using Workbook_Create.
2. Prepared a valid JSON payload from a local record list using JSONSerialize.
3. Stored the serialized JSON in a Text variable.
4. Passed the JSON string, Excel binary, worksheet name, and other required inputs to the Data_WriteJSON action.
5. Downloaded the generated Excel file.

Expected Result The JSON data should be written to the specified worksheet and displayed as rows and columns in the generated Excel file.

Actual Result The Excel file is generated successfully, but the worksheet remains empty. No data is written to the sheet.

SS1.png

SS2.png

30 Sep

Shilpa Uppund

Hi Harjindra,

In the assignment which you have shown, you are trying to assign values to some list?

Check that part, it doesn't look right.

30 Sep

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines