将数据记录从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.
我可以直接复制并粘贴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 [ ^ ]