cancel
Showing results for 
Search instead for 
Did you mean: 

paste a list of values onto a column of cells in a table.

Former Member
0 Kudos

There is a requirement to copy a list of values from an Excel sheet and paste onto the application within a table column, Just like how it is done within the Excel sheet. Is it possible to implement this ?

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

arun_srinivasan
Contributor
0 Kudos

hi,

u can use Fileupload ui element to get the values from excel file and This valuecan be Retrieved one by one from its value attribute which is bind to the file upload ui and from that u can put it into tables. i have done this with .csv format of excel file.

let me know for further

regards,

Arun

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi ,

Go through this weblog:

/people/perumal.kanthan/blog/2005/03/21/reading-excel-data-from-java-using-hssf-api

This weblog takes file from c:// drive of your server.You can use upload UI element to load file from local system.

for file upload you can take help from this blog:

Regards,

Rajeev

Message was edited by: Rajeev Ranjan

Former Member
0 Kudos

Thanks Arun and Rajeev for the replies. I will try these options for meeting the requirement. Both these options are done programmatically. I was more looking for a simple cut and paste by the end-user of the application, similar to Windows <ctrl>c, <ctrl>v.