将数据记录从excel复制到gridview

问题描述:

是否可以从excel复制多行和多列数据记录并直接将其粘贴到GridView中?



例如我有Excel记录



Is it possible to copy multiple rows and columns of data record from excel and directly paste it in GridView?

For example I have Excel record

FirstName	LastName	Address	   Age	    Contact
kaye	    cruz	    hjjkh	    3	    9879
halt	    man	        jhkkl	    4	    7689
Just	    mik	        kjhk	    7	    99089





然后我有多个人的记录,我想复制整个事情并将值粘贴到GridView的相应字段中。



我可以直接复制和粘贴excel数据到网页/ gridview(在aspx页面中)或者是否有任何其他方法来执行此操作?谢谢。



我尝试了什么:



我还在寻找可能的方法。请你能帮帮我吗?谢谢。



then I have multiple records of people and I want to just copy the whole thing and paste the values into corresponding fields in GridView.

Can i directly copy and paste the excel data to the webpage/gridview (in aspx page) or if there is any other method to do this? Thanks.

What I have tried:

I'm still searching for possible methods for this. Please can you help me with this? Thanks.

Quote:

我可以直接复制并粘贴excel数据到网页/ gridview(在aspx页面)

Can i directly copy and paste the excel data to the webpage/gridview (in aspx page)



不,它不可能直接。



是的,通过javascript它可以通过从剪贴板获取值然后捕获行和单元格,然后将数据粘贴/分配到gridview中的相应单元格,这是一个繁琐的过程



或者你可以查看 Handsontable JS Excel Framework [ ^ ]