Question

Copy and paste Multiple row values from an excel/textfile to K2 comment box

  • 31 August 2019
  • 2 replies
  • 5 views

Badge +1

Need help to find solution for Copy and paste Multiple row values from an excel/textfile to K2 comment box.For example if i manually copied 10 rows from an excel file to K2 box then i wants to insert all 10 rows to database table(10 rows).Please suggest.


2 replies

Hi  @vraj;


 


I don't think there's out of the box feature that can enable you to achieve that directly, however you can make use excel smartobject that will allow you to GetList rows to smartform control(https://community.k2.com/t5/K2-blackpearl/Excel-Import-Service-Broker/ba-p/65814?nobounce).


 


Kind regards;


Widson.

@vraj  - Your requirement is vague. Database table has primary keys, auto increment ids, foreign keys etc where as excel is just plain text. Expecting pasted text to be inserted as rows in a SQL  table is error prone. You can achieve this by using UIPath Robot which does the background work of copying data from excel and inserting that as a row in the database table.

Reply