Solved

Copy / Paste to /from a datawindow

Posted on 2004-04-01
3
1,776 Views
Last Modified: 2013-12-26
Hi

I have some functionality I'm trying to get to work. I allow a user to copy rows from a datawindow into the clipboard. Behind the scenes I copy the selected rows to a datastore.

The problem is if they then paste the values into Excel , change some values and try to paste the rows back into the visible datawindow, there is no change. Behind the scenes I try to do a Paste() into the datastore then row by row put them back into the visible datawindow but nothing seems to happen. The datawindow object is external.

any ideas would be appreciated.

cheers
0
Comment
Question by:maran_software
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 8

Accepted Solution

by:
Vikas_Dixit earned 125 total points
ID: 10733767
Try the following ( you may need to customize a bit) :

string ls_Data

ls_Data = Clipboard()

dw_1.ImportString(ls_Emp_Data)


Or use : dw_1.ImportClipboard().. see the variations that accept row/column range.

Also can you debug and see if your code is being executed at all ??
--VIkas
0
 
LVL 15

Expert Comment

by:namasi_navaretnam
ID: 10737088
Yes. You need to debug further. Check the retrun codes from ImportString, ImportClipboard functions. The data needs to be tab-delimited. Also post your code.
0
 

Author Comment

by:maran_software
ID: 10739075
Thanks your suggestion worked well! Thanks again.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project (http://www.eclipse.org/sequoyah/) automates most of the tasks discussed in this article. You can even fin…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question