Wrox Home  
Search P2P Archive for: Go

  Return to Index  

aspx thread: Copy Paste from Excel


Message #1 by Ankur Kalsi <akalsi@q...> on Tue, 24 Jul 2001 09:52:12 -0700
Does anybody know if there is any such thing in ASP.NET that will let me

paste multiple rows and columns from excel to a ASPX page and then save that

data to sql.



Thanks

AK

Message #2 by "Thomas Tomiczek" <t.tomiczek@t...> on Tue, 24 Jul 2001 19:26:23 +0200
Yes.



No.



Like in ASP.



Sorry, you are in for some programming by hand. Well, actually - I am

not sure whether cut/paste into a textbox works. This is my best bet.

Then taking this and handling it's formatting whatever it is.



Thomas Tomiczek

THONA Consulting Ltd.



-----Original Message-----

From: Ankur Kalsi [mailto:akalsi@q...]

Sent: Dienstag, 24. Juli 2001 18:52

To: ASP+

Subject: [aspx] Copy Paste from Excel



Does anybody know if there is any such thing in ASP.NET that will let me

paste multiple rows and columns from excel to a ASPX page and then save

that

data to sql.



Thanks

AK



Message #3 by "Samuel Engelman" <samuel_engelman@p...> on Tue, 24 Jul 2001 15:46:35 -0400
you can try to host a copy of excel in your page and then use script to

 build a

delimited string with the data and put that into a hidden form field





|--------+--------------------------------->

|        |   "Thomas Tomiczek"             |

|        |   <t.tomiczek@t...|

|        |   om>                           |

|        |                                 |

|        |                                 |

|        |   Tuesday July 24, 2001 01:26 PM|

|        |   Please respond to "ASP+"      |

|        |                                 |

|--------+--------------------------------->

                                                         

        |

  |      To:                                  "ASP+" <aspx@p...

>       |

  |      cc:                                                           

        |

  |      Subject: [aspx] RE: Copy Paste from Excel                     

        |







Yes.



No.



Like in ASP.



Sorry, you are in for some programming by hand. Well, actually - I am

not sure whether cut/paste into a textbox works. This is my best bet.

Then taking this and handling it's formatting whatever it is.



Thomas Tomiczek

THONA Consulting Ltd.



-----Original Message-----

From: Ankur Kalsi [mailto:akalsi@q...]

Sent: Dienstag, 24. Juli 2001 18:52

To: ASP+

Subject: [aspx] Copy Paste from Excel



Does anybody know if there is any such thing in ASP.NET that will let m

e

paste multiple rows and columns from excel to a ASPX page and then save



that

data to sql.



Thanks

AK



Message #4 by "SATHISH C.G." <cgs@s...> on Wed, 25 Jul 2001 11:29:19 +0530
Hi there,



                Use the excel objects to access the excel sheet and use the

ado.net to insert the dates in to the database. Hope this helps u.



Regards



SATHISH C.G.











----- Original Message -----

From: "Ankur Kalsi" <akalsi@q...>

To: "ASP+" <aspx@p...>

Sent: Tuesday, July 24, 2001 10:22 PM

Subject: [aspx] Copy Paste from Excel





> Does anybody know if there is any such thing in ASP.NET that will let me

> paste multiple rows and columns from excel to a ASPX page and then save

that

> data to sql.

>

> Thanks

> AK

>


  Return to Index