cancel
Showing results for 
Search instead for 
Did you mean: 

Copy Paste of a Excel sheet

bobo2001
New Contributor

Copy Paste of a Excel sheet

Hello Folks,



we have a specially requirement during a test scenario.



Scenario:



1. A customer choose a contract which is created in an excel file.



2. the Customer edit the excel.xlsx  file.



3. the customer select  the complete sheet or a range(header + data fields) and press copy



4. paste the data into a web form.



5. press submit



I have no idea how to handle the "copy paste" action. I tried to read from the excel

file line by line. But in that case the "TAB" separator are not correct insert into the 

web form.



Can anybody help me?



best regards





























1 REPLY 1
Ryan_Moran
Valued Contributor

RE: Copy Paste of a Excel sheet

For a simple way of handling this you could use the .Keys method to send control + c to copy the text, then parse the text however you want with Sys.Clipboard, then finally use control + v to paste the text.

Ex:



object.Keys("^c");

Sys.Clipboard = someFunctiontoParseText(Sys.Clipboard);

object2.Keys("^v");

''-Praise the sun and Give Kudos.''
New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors