From: Luigi on
Hello,
is it possible to copy and paste values taken from an Excel spreedsheet into
the grid of a GridView in a ASP.NET page?

Luigi
From: Alexey Smirnov on
On May 21, 4:29 pm, Luigi <Lu...(a)discussions.microsoft.com> wrote:
> Hello,
> is it possible to copy and paste values taken from an Excel spreedsheet into
> the grid of a GridView in a ASP.NET page?
>
> Luigi

You mean from a single cell or entire table?

The standard gridview control is a data-bound control for rendering
data. It has no paste function. To copy and paste values from Excel
you can use a separated textbox where you can paste the text, parse
it, update datasource with a new data and refresh gridview after that.
The parsing can be easily done, just loop through each line of text
and split it on the tab character.

Hope this helps
From: Mark Rae [MVP] on
"Alexey Smirnov" <alexey.smirnov(a)gmail.com> wrote in message
news:56ff8a1a-5617-4912-aa43-78ceb47bba76(a)u7g2000vbq.googlegroups.com...

> The standard gridview control

What you say is correct, though there are several 3rd-party controls
available which support this behaviour and, although they are not free of
course, they may be more cost-effective for the OP in the long run due to
the "not re-inventing the wheel" factor...


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

From: Alexey Smirnov on
On May 21, 6:19 pm, "Mark Rae [MVP]" <m...(a)markrae.net> wrote:
> "Alexey Smirnov" <alexey.smir...(a)gmail.com> wrote in message
>
> news:56ff8a1a-5617-4912-aa43-78ceb47bba76(a)u7g2000vbq.googlegroups.com...
>
> > The standard gridview control
>
> What you say is correct, though there are several 3rd-party controls
> available which support this behaviour and, although they are not free of
> course, they may be more cost-effective for the OP in the long run due to
> the "not re-inventing the wheel" factor...
>
> --
> Mark Rae
> ASP.NET MVPhttp://www.markrae.net

Yes, I agree why reinvent the wheel if it is already exist... On
another hand, such thing can be easily implemented and might be useful
in a variety of contexts

Cheers!
From: MK on
Do you know what third party controls offer this ability?

*** Sent via Developersdex http://www.developersdex.com ***