Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    May 12, 2006 at 05:02 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 12, 2006 at 05:14 AM

    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:

    File upload

    Regards,

    Rajeev

    Message was edited by: Rajeev Ranjan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.