Uploading data to table from a Excel file

Discussions

General J2EE: Uploading data to table from a Excel file

  1. Uploading data to table from a Excel file (4 messages)

    Hi,

        I am trynig to find a solution for a reqmt.
    I need to upload data from a set of Excel files , say 10 different uploads.

          The whole upload has to run in a predefined interval, which can be scheduled in windows.

       Now, regarding implementation, I am thinking of using threads which creates a separate thread for each of 10 uploads.. When all the threads finishes, the upload is marked as success.. Any body has done a similiar kind of thing before.. Any help is appreciated...

    Thanks..
  2. There are some MS Office/.Net stuff ----> web services stuff that works nice with J2EE:


    http://msdn.microsoft.com/webservices/building/office/default.aspx
    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnxpwst2/html/odc_wsrxl.asp

    http://www.microsoft.com/downloads/details.aspx?FamilyID=dc3d8474-d960-4d14-a9df-9024e39f5463&displaylang=en

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnxpwst/html/odc_wstoolkitoverview.asp

    Mike
  3. Thanks Mike.. Hope I will find some good stuff there.. Thanks for ur time..

    Inviting others comments too...
  4. I use
    JExcelAPI when I have to need import data from excel-file, or
    export from database to excel-file.

    good luck !
  5. Uploading data to table from a Excel file[ Go to top ]

    I had problems with JExcel.

    Try POI
    http://jakarta.apache.org/poi/index.html