Write range to .xml file but unable to export

Help Studio
1

Hi there,

I deserialize from json to datatable. I write range in table range at A10. I was not able to export it. Any help?

2

Use Excel Application Scope give your Excel file path inside it, place Write Range DataTable = dt Range = "A10" Check/Uncheck AddHeaders as needed.

Also if the JSON didn’t deserialize correctly, Generate DataTable may produce an empty table you can check with myDataTable.Rows.Count.ToString in a Message Box before writing.

Cheers

3

@mark_rajkumar1

Add log messages in your workflow to check what was deserialized, how many rows etc. to debug the issue. Sharing the workflow screenshot could be helpful to use to suggest you the solution more quickly.

4

@mark_rajkumar1

Can you please elaborate

  1. You are talking about json and datatable and in main heading I see xml
  2. When you say you are not able to export what error or issue you are facing
  3. Did you check the locals panel while debugging to check if all variables and values are proper?

Cheers

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.