Using a Nintex Workflow, has anyone had success getting data from an excel file, transforming it to be used in Workflow Variables, and then writing it back to a new excel file? I am able to get the data from the file and “read” it, but it’s funky, like Json nested in Json or something, and I can’t get the columns or values as normal text so that the workflow can read it accordingly in branching or transformation steps. I’ve worked on this a lot over the last year and have not been successful. I have already reviewed existing help articles on this topic.
I am looking for someone who may have already accomplished this in a workflow who wouldn’t mind sharing their workflow actions/configuration so that I can plug in my own file information and get rolling. Thank you in advance.
