How to write datatable to Excel or CSV

RPA Automation Studio Pro
1

I am getting the data from SQL and trying to write it either on excel or csv file.
But using write excel, write range it is throwing error.

Regards
Ankit Dwivedi

2

Hello @AnkitDwivedi

Could you please contact the support team for this situation? As they will be able to understand exactly how your workflow is built and what need to be fixed.

But it also an option to try to use the activity “Save table”, it may work for your case.

3

Hello @AnkitDwivedi , what is the error message that you are getting? is it related to the object?

4

@Oquandiah_Bridley - Getting below error

Selectors: “Error converting value "[{"UploadID":15,"FileId":4280,"FileName":"sp_tg_hve_2309221839_ankit.xlsx\r\n","UploadTime":"28-09-2022","FileStatus":null,"BotStatus":"Completed","LastUpdateTime":null,"ClientName":"”,"FileUploadedStatus":"File Uploaded Successfully"}]" to type ‘System.Collections.Generic.IDictionary2[System.String,System.Collections.Generic.IDictionary2[System.String,System.String]]’. Path

5

@Renan.Mancilha - Tried that too also but no luck.

6

@AnkitDwivedi , are you able to share with me a screenshot of your workflow, and also the parameters of your write excel file activity?

It may be throwing an error because of the type of data you are looking to write. you may just need to change the format of the data.

7

Hi @AnkitDwivedi Please share a screenshot and the parameters of your write excel file.