Re: Copy from excel --> clipborad --> datagridview

[vamsikrishna20]

Hello,
i am working with vs2008 (web application) and I want to copy some content from an excel sheet and and using the clipboard i want to copy the contents in a gridview

I have tried using Clipboard.GetDataObject() but no matter what ever i do it is always returning null so can anyone suggest me solution of how to implement this.

regards,
vamsi.

[Plater]

Is there anything IN the clipboard object? Like did you do a copy from excel?
Office has its own weird clipboard that might not put data into the regular clipboard until it thinks it needs it?

EDIT:
Calling .GetFormats(true) returned the following data types in my Clipboard from an excel copy:

 
        [0]    "EnhancedMetafile"
        [1]    "MetaFilePict"
        [2]    "System.Drawing.Bitmap"
        [3]    "Bitmap"
        [4]    "Biff8"
        [5]    "Biff5"
        [6]    "BIFF4"
        [7]    "Biff3"
        [8]    "Biff"
        [9]    "SymbolicLink"
        [10]    "Wk1"
        [11]    "DataInterchangeFormat"
        [12]    "XML Spreadsheet"
        [13]    "HTML Format"
        [14]    "System.String"
        [15]    "UnicodeText"
        [16]    "Text"
        [17]    "Csv"
        [18]    "Rich Text Format"
        [19]    "Embed Source"
        [20]    "Object Descriptor"
        [21]    "Link Source"
        [22]    "Link Source Descriptor"
        [23]    "Link"
        [24]    "Format129"
 
 

[vamsikrishna20]

thanks for the reply but are you sure that you are using a web applicaion developed in vs2008 and windows 2003 as when i am tring to fetch teh data from teh clipboard by using teh object Clipboard.GetDataObject() it is always returning a null value so please let me know how do you want me to proceed regarding this issue.

[Plater]

Ah ha! I missed that part about the web application!
Ok then. Well copy/paste is handled by the browser on the client side.
It if highly unlikely that any copy/paste operation will ever make it back to the server for it to process.

In IE, I think javascript can access that clipboard, but FF does not allow it.

What you could MAYBE do, is provide a small textbox, that the user will PASTE the data into, and you would have javascript watch for the changed event and it would then process the data and fill in your gridview?

[Curtis Rutland]

Remember: all .NET code is executed on the server. So when you're doing the Clipboard.GetDataObject(), you are accessing the Clipboard object of the server, not the client.