How to add data row using array of string?

[_itslw]

I want to add currency type and add into a data row and use write range to type into excel.

[_itslw]

[_itslw]

@Palaniyappan

[_itslw]

This is my array of strings.

[Manish540 (Manish Shettigar)]

Check this below screenshot, @_itslw
Steps: 1.First create a new empty row.
2.Add that created new row to your datatable using first data row.
3.Then use one more data row to add your values as array of string, like {“yourvalue”,"",…}

Hope this may help you

[_itslw]

Can i know what is your value for the new row? @Manish540

[Manish540 (Manish Shettigar)]

Sorry for the late reply, @_itslw
In next add data row, you can pass your values as {“yourvalue1”,“yourvalue2”,…} in this format and your values should be equal to number of columns.

[_itslw]

Is it possible you could send me this workflow?

[_itslw]

I mean the ones circled in red. What is NewRow = InputDT.NewRow**()**
and the add your value to datatable? Can you provide me with the full solution?

[Manish540 (Manish Shettigar)]

Check this workflow, @_itslw
Forum_Test_2.xaml (10.7 KB)
Hope this may help you

[_itslw]

Thank you so much! @Manish540

[Manish540 (Manish Shettigar)]

Happy Automation @_itslw