How to Convert data table to String format

  • 121 Views
  • Last Post 27 May 2019
divya.vadiala@sparshcom.net posted this 24 May 2019

Hi Team,

I am reading some excel data from a range there the output is getting in Data table that data i want to paste it in an area eg : Notepad where am getting the error cant convert from data table to string type.

Please guide me how to achieve this issue.

Regards,

Divya

Attached Files

Swathi Muppalla posted this 27 May 2019

Hello Divya,

Thank you for reaching out to the Intellibot Forum Support Team.

You can use the Below -Mentioned method to solve the problem.

In the Excel Connector Drag and drop the Copy, method to the design Surface.

Specify the "Sheet Name" and the "Cell Range" to copy the data from.

Then go to Utilities click on Clipboard, Select the GetText Component.

In The (Actions UI) Select SetText Or SendKeys to write the data in Notepad

we have attached an image of the entire automation, kindly refer the same.

  

Feel free to revert for any further clarification.

Regards,

Swathi Muppalla

Close