Copy / Paste, Excel To flexgrid

[VoTiger]

Hi everyone,

i am ttrying to find a way to do the copy / paste between an existing
excel file and my flexgrid (in runtime application). But the fact is
that i don't know how to proceed.

The thing that i am trying to do is to code this : A man can do ctrl+c
in an excel application and do ctrl+v in his flexgrid (in runtime mode)

Regards,

 

[Samuel Shulman]

Are you trying programmatically?

 

[VoTiger]

Yes, in VB.NET.

Regards,

 

[Samuel Shulman]

I don't know of such a simple method but you may access the data of the
Excel sheet via the Object Model of Excel and then populate the data into
the GridControl

You have to consider the following
How will the program know the path of the file
How to use the object model, if you haven't used it before it is not so easy

Another method if the file can be .csv then you can read it and parse it
yourself that should be quite easy

hth,
Samuel Shulman

 

[IdleBrain]

Hello Samuel,

If you want the user to press Ctrl+C to copy, Ctrl+V to paste:

Use KeyData of the KeyUp event to sense Ctrl + V press by the user.

Checkout how the results can be copied from the clipboard into your
application.
http://msdn2.microsoft.com/en-us/library/system.windows.forms.clipboard.aspx

Finally, use a table to write into flexgrid.

Hope it helps.

 

[VoTiger]

Thank you IdleBrain and Samuel for your both help. As IdleBrain said i
am using the Clipboard control and it is working perfectly using the
method GetDataObject.Getdata(). But the thing that disturb me is that i
am getting just the text and i would like to have the object that
contains the type of the value and the text. If someone has any idea to
make this i would truely appreciate.

Regards,

 

[IdleBrain]

Hai:
Have you tried using IDataObject.GetData (Type) as mentioned in:
http://msdn2.microsoft.com/en-us/library/system.windows.forms.idataobject.getdata.aspx

Also check out IDataObject.GetFormats () as mentioned in:
http://msdn2.microsoft.com/en-us/library/system.windows.forms.idataobject.getformats.aspx


Hope it helps.

 

[VoTiger]

Thank you for your reply idlebrain.

I will try to see that, and will tell if it works.

Regards,