can anyone tell me is it possible to write python or csharp code using the invoke code to create and add value to different cells in excel?
i was trying to automate json extracted from apis that i got from openflow and then flatten the json so that it comes as key value pairs and is saved in excel file. if someone could help me with that , it would be a huge help .thanks.
you can, i think you can even find example code in both languages on this forum.
But what is the use case, that makes you need that, and don’t want to use the Office Activities or the Read Excel/Write Excel ?
1 Like
using write excel i cant create a new file and save the file , that’s why i was opting to python code. i think i am not familiar with how the write excel and save excel works isn’t the save excel supposed to save whatever path i provide it
yes, if you give it a datatable that has data in it, it should save that.
Do you get any errors ?
i got a solution for my problem by using a python script thankyou
1 Like