How to convert system.data.dataset to system.data.datatable in uipath

Help Studio
1

I want to save extracted data into excel but facing “cannot covert system.data.dataset to system.data.datatable” error

2

Hi,

DataSet can has multiple datatables. If there is single datatable in it, the following will work.

dt = ds.Tables(0)

If we can know name of the datatable, the following also works.

dt = ds.Tables("TableName")

Note: ds is DataSet, dt is DataTable.

Regards,

3 Likes
3

@raju_alakuntla The extracted data will be in a datset. You have to get each table from the data set then you can write that into an excel

Please find the below workflow your scenario

Dataset.zip (2.4 KB)

1 Like
4

I could able to convert it but its overwriting data in excel.please give some solution

5

thanks. but data is overwriting into one cell everytime. please give me solution

6

Hi,

Can you share your input and expected output, workflow etc?

Regards,

7

I am extracting handwritten data using document understading and intelligent Ocr and storing in excel for 4-5 files.
is it the problem with loop or anyother

8

@raju_alakuntla Did you go through the workflow that I have shared with you ?

Also, can you share the screenshots of your code for writing data into excel

9

Have you gotten a solution for this? I am having the same issue.

1 Like